Emva koko, siya kukufundisa Uyenza njani iMacros ngokugqwesaUkuba ungathanda ukwazi ukuba ungayenza njani ngokulula nangokukhawuleza? sicebisa ukuba uqhubeke ufunda.
Funda Uyenza njani iMacros ngokugqwesa.
Uyenza njani imacros kwi-Excel? Inyathelo nenyathelo
Ukuba usebenzisa i-Excel rhoqo, kunokwenzeka ukuba sele uchonge imisebenzi enzima ekufuneka uyenzile. Zintsonkothileyo ukuze unyanzele izinto ezininzi ngokulandelelana, ezinje:
Hlela ukungeniswa kwemali eyahlukeneyo kwaye uyiguqulele kwitshathi, utshintshe imibala kwintloko, kwaye usebenzise iifomula ezahlukeneyo kwiseti yeeseli.
IiMacros zenzelwe ukugcina ixesha kunye nokwenza imisebenzi esiyenzayo emva kwenye. Ukuba sele uyazi ukuba zeziphi ezi zinto zintathu okanye zine uhlala usenza isicelo, ngendlela efanayo ungayiguqula ibe yi-macro, oko kukuthi, i-odolo enikwa amandla ngalo lonke ixesha ucinezela amaqhosha aliqela kwaye wenza imisebenzi emininzi ngokuzenzekelayo.
Uyenza njani kwaye uyiqhube njani iMacro kwi-Excel?
Into yokuqala ekufuneka uyenzile ukuvula i-Excel, vula iphepha elingenanto kwaye ufake i "Jonga" isithuba kwaye ujonge ukuba ngaba "Macros" icon ikhona. Ukuba ayiveli, kufuneka uye kwi "Fayile", emva koko uye kwicandelo "Khetha" kwaye emva koko ithi "Yenza iRibhoni ngokwezifiso", apha kufuneka wenze i "Macro" icon ukuze ivele "Jonga".
Ukwenza ushicilelo olukhulu, konke okufuneka ukwenze kukucinezela uphawu lwe «Macro», faka iimenyu kwaye ubhale yonke into ngokwendlela eyabelwe ngayo indibaniselwano yezitshixo ezinokuba «Ulawulo + oluphambili» ofuna ukumisela, khumbula ukukhetha indibaniselwano yezitshixo zezenzo, kwaye nje ukuba zirekhodwe ziya kuphinda-phindwa ngalo lonke ixesha ulisebenzisa, njenge:
Ukuba uza kwenza i-macro elula, kufuneka wongeze isihloko kwiphepha elingenanto, kwiikholamu ezinokuthi "Isishwankathelo sosuku, iindleko zentengiso kunye netotali", kwakhona ii-macros zisetyenziswa kwizenzo ezintsonkothileyo, nangona kunjalo , ukuba sisebenzisa lo mzekelo ulula unokuqondwa ngcono.
Kwakhona kwi "Jonga" isithuba kufuneka ubeke "Macros" ukhetho kwaye xa imenyu ivuliwe, kufuneka ukhethe "Rekhoda ii-macros", kuya kufuneka unike le Macro igama, ngaphandle kwezithuba. Ke kwicandelo "leqhosha elinqumlayo" kufuneka ubonise isitshixo esizakusebenzisa le macro, enje nge "Control + R". Khumbula ukuba ungasebenzisi izitshixo ezisetyenziswa yiWindows ukwenza eminye imisebenzi enje ngo "Lawula + C" ukukopa isicatshulwa.
Ke kwi "Inkcazo" kufuneka uchaze, yeyantoni le Macro? Xa ucofa u "Kulungile", ukurekhoda okuphezulu kuya kuqala, uya kuqaphela ukuba le iya kuba njalo kuba iqhosha lokurekhoda liza kuvela kwicala lasekhohlo le-Excel. Ukusuka apha, nasiphi na isenzo osenzayo siya kurekhodwa ngaphakathi kwe-macro.
Ukubuyela kumzekelo, uya kongeza isihloko njengoko besitshilo "Isishwankathelo sosuku, ukuthengisa, iindleko kunye netotali", ngemvelaphi kunye nonobumba wemibala eyahlukeneyo, emva koku uya kucofa iqhosha lokurekhoda elikhulu ukumisa ukurekhoda, kwaye ugqibile.wenze i-macro ukuze ukwazi ukugcina incwadi yomsebenzi ye-Excel kwaye xa uyigcina kubalulekile ukuba ukhethe ibhokisi yoluhlobo "Type" kunye nenketho "yeencwadi zomsebenzi ze-Excel ezenzelwe ii-macros", ukuba awuyenzi, i-macro ayisebenzi.
Ngoku ungasebenzisa le macro kuyo nayiphi na incwadi ngale ndlela ilandelayo: Uvula iphepha elingenanto kwaye xa ucinezela «Alt + F8», uluhlu lweemacros ozigcinileyo luya kuvulwa, emva koko uza kukhetha leyo ufuna ukuyisebenzisa kwaye Cofa ku «Phumeza» kwaye ngale ndlela ushicilelo olukhulu luya kongezwa ngokuzenzekelayo. Ungayisebenzisa kwakhona ngamaqhosha owabelwe njengo "Control + R".
Ukuba olu lwazi beluluncedo, musa ukuthandabuza, ndwendwela iwebhusayithi yethu, apho uza kufumana amanye amanqaku anje: Uyenza njani ikhalenda kwiLizwi Inyathelo nenyathelo?