Kuyaziwa ukuthi ngesimo esijwayelekile, izihloko zekholomu ezinhlelweni ze-Excel zikhonjiswa ngezinhlamvu zezinhlamvu zesiLatini. Kepha, ngesinye isikhathi, umsebenzisi angabona ukuthi manje amakholomu aboniswa ngamanani. Lokhu kungenzeka ngenxa yezizathu eziningana: izinhlobo ezahlukahlukene zokungasebenzi kahle kohlelo, izenzo ezingahlosile, ukushintshwa ngenhloso ukushintshana ngomunye umsebenzisi, njll. Kepha, yiziphi izimbangela ezazingezona, lapho kwenzeka isimo esifanayo, umbuzo wokubuyisa ukubonisa amagama amakholomu esimweni esijwayelekile kuyasebenza. Ake sibheke ukuthi ungashintsha kanjani izinombolo ezinhlokweni eziku-Excel.
Ibonisa izinketho zokushintsha
Kunezinketho ezimbili zokuletha iphaneli yokuxhumanisa engqondweni ejwayelekile. Enye yazo yenziwa ngesibonisi se-exl, kanti umzuzwana usho umyalo wokuyala usebenzisa ikhodi. Cabanga ngemininingwane eminingi zombili izindlela.
Indlela 1: Usebenzisa isikhombimsebenzisi sohlelo
Indlela elula yokushintsha ukubonisa kwamagama amakholomu ngezinombolo ngakunye ukufaka amathuluzi wohlelo oluqondile.
- Senza ukuguqukela kuthebhu "yefayela".
- Sithuthela esigabeni se- "Parameters".
- Kuhlelo lwezinhlaka zohlelo ezivula, ziye esigatshaneni se- "formula".
- Ngemuva kokushintshela engxenyeni ephakathi yewindi, sithola "umsebenzi nge-Izilungiselelo Block. Mayelana nepharamitha ye-R1C1 Link isitayela susa umkhaza. Chofoza inkinobho ethi "Kulungile" ezansi kwewindi.
Manje igama lamakholomu kwiphaneli yokuxhumanisa lizothatha ukubukeka okujwayelekile kithi, okungukuthi, lizophawulwa ngezinhlamvu.
Indlela 2: Ukusetshenziswa kweMacro
Inketho yesibili njengesixazululo senkinga ifaka ukusetshenziswa kwe-macro.
- Yenza kusebenze imodi yonjiniyela ethepheni, uma kuvela ukuthi kukhutshazwe. Ukuze wenze lokhu, yenza ukuthuthela kuthebhu "yefayela". Okulandelayo, sichofoza okubhaliwe "kwepharamitha".
- Ewindini elivula, khetha into yokusetha iribhoni. Ngakwesokunene sewindows, sibeka umkhaza eduze kwento "yonjiniyela". Chofoza inkinobho ethi "KULUNGILE". Ngakho-ke, imodi kanjiniyela iyasebenza.
- Iya kuthebhu kanjiniyela. Sichofoza inkinobho ethi "Visual Basic", etholakala emaphethelweni wesobunxele wetheyipu ku-Izilungiselelo ze- "Code". Awukwazi ukukhiqiza lezi zenzo ethepheni, kepha umane ushayele ukhiye wekhibhodi kukhibhodi ye-ALT + F11.
- Isihleli se-VBA siyavula. Chofoza kukhibhodi inhlanganisela yezinkinobho ze-CTRL + G. Efasiteleni elivula, faka ikhodi:
Isicelo.Referencencedyle = XLA1
Chofoza inkinobho ethi Enter.
Ngemuva kwalezi zenzo, ukuboniswa kwegama legama lekholamu eshidi kuzobuya, kuguqule inketho yezinombolo.
Njengoba ubona, ukushintshwa okungalindelekile kwegama lamakholomu izixhumanisi ezivela encwadini kuya ezinhlamvwini akufanele zifakwe ekupheleni komsebenzisi. Konke kulula kakhulu ukubuyela esimweni esedlule ngoshintsho kumapharamitha we-Excel. Inketho esebenzisa i-macro yenza umqondo ukuthi ufake isicelo kuphela uma ngesizathu esithile ungakwazi ukusebenzisa indlela ejwayelekile. Isibonelo, ngenxa yohlobo oluthile lokwehluleka. Vele, ungasebenzisa le nketho ngenhloso yokuhlolwa ukumane ubone ukuthi uhlobo lolu shintsho lusebenza kanjani.