Ukudityaniswa kweeqhosha ezishushu kukhetho apho kunokwenzeka ukuba ucofe indibaniselwano ethile kwikhibhodi, apho unokufumana khona ukufikelela ngokukhawuleza kwiimpawu ezithile zomhleli we-Eks. Kwinqaku, cinga ngeendlela zokucima imigca kwitheyibhile yomhleli usebenzisa izitshixo ezishushu.
Ukucima umtya ngekhibhodi enezitshixo ezishushu
Indlela yokukhupha ngokukhawuleza nokuba liliqela kukusetyenziswa kwendibaniselwano yamaqhosha ashushu. Ukwenzela ukususa into yomgca usebenzisa indibaniselwano ephambili, kufuneka ucofe amaqhosha ama-2, inye ethi "Ctrl", kunye neyesibini "-".
Kuya kufuneka kuqatshelwe ukuba umgca (okanye izinto ezininzi) kufuneka wabelwe kwangaphambili. Umyalelo uza kususa uluhlu oluchaziweyo nge-offset. Isicelo siza kubonelela ngamathuba okunciphisa ixesha elichithwe kwaye lishiya isenzo esingeyomfuneko apho ibhokisi yencoko ibizwa khona. Kuyenzeka ukuba ukukhawulezisa inkqubo yokususa imitya nge-HOSTKYs, kodwa ngenxa yesi sizathu kuya kufuneka senze isenzo 2. Okokuqala, gcina i-macro, emva koko udibanise ukubulawa kwayo kwindibaniselwano ethile yamaqhosha.
Ukulondolozwa kweMacroNgokusebenzisa ikhowudi yesoftware ye-macro ukuba isuse into ethile, kunokwenzeka ukuyisusa ngaphandle kokuhamba ngebhayisikile kwisalathiso semouse. Umsebenzi uya kunceda ekumiseleni inani lezinto zomgca apho iphawu lokuyahlula likhona kwaye lisuse umgca kunye nokuvalwa. Ukuphumeza isenzo, akuyi kudingeka ukwaba inqaku ngokwalo. Ukutshintshela ikhowudi enjalo kwi-PC, kufuneka uyikhuphele kwaye unamathisele ngqo kwimodyuli yeprojekthi.
2 Ukunikezela umdibaniso ophambili macroKuyenzeka ukuba kuchaze ii-HOOHEYs zazo, ukuze inkqubo yokucima iyakukhawuleziswa, kodwa ngenxa yesi sizathu 2 sezenzo ziyafuneka. Ekuqaleni, kufuneka ugcine i-macro kwincwadi, emva koko udibanise nayiphi na indibaniselwano ephambili yokubulawa kwayo. Indlela yokususwa kwemitya ilungele kakhulu kubasebenzisi abaphambili boMhleli we-EKKEC.
Ukongeza, umhleli wahlulahlulwe ngoonobumba beeleta, ngenxa yokuba ungayigxininisi kwisakhiwo ngexesha lokuphehlelelwa kweMacro, kunokwenzeka ukuba ukukopa ngegama elihle kwaye ukhethe i-componitions ephambili esebenzisa iqhosha elifanayo .
I-Macros isuse imitya ngemeko
Kukwakhona izixhobo eziphambili zokuphunyezwa kwenkqubo ekuqwalaselweni, ukusebenzisa engafunekiyo ukugxila ekufumaneni imigca ukuze isuswe. Umzekelo, ungathatha i-macro efuna kwaye icime izinto ezisezantsi ezinombhalo ochazwe ngumsebenzisi, kunye no-Excel kwi-Excel. Isusa imigca enemiqathango emininzi kunye nokukwazi ukuzibeka kwibhokisi yencoko yababini.Ukuqukumbela
Ukususa izinto ezisezantsi kumhleli we-Excel kukho izixhobo ezilula ezininzi. Ungasebenzisa izitshixo ezishushu zokuphumeza ukusebenza okunjalo, kunye nokwenza i-macro isuse izinto ezisezantsi etafileni, eyona nto iphambili kukuthobela i-algorithm yezenzo.
Umyalezo "Cima umgca" kwitheyibhile ye-Excel wavela kuqala kwitekhnoloji yolwazi.