Intengo yokubuka amavidiyo ku-YouTube

Kuyaziwa ukuthi esimweni esivamile, izihloko zekholomu ku-Excel zichazwe ngezinhlamvu zesiLatini. Kodwa, ngesinye isikhathi, umsebenzisi angathola ukuthi amakholomu manje amakwe ngezinombolo. Lokhu kungenzeka ngezizathu eziningana: izinhlobo ezihlukene zokungasebenzi kahle kwaloluhlelo, izenzo zalo ezingenasenzo, ukushintshwa ngamabomu kwesiboniso ngomunye umsebenzisi, njll. Kodwa, noma ngabe yiziphi izizathu, uma kwenzeka isimo esinjalo, umbuzo wokubuyisela ukuboniswa kwamagama ekholomu kumbuso ojwayelekile uba ophuthumayo. Ake sithole ukuthi singashintsha kanjani izinombolo ezincwadini ze-Excel.

Izinketho zokushintsha ukubonisa

Kunezinketho ezimbili zokuletha iphaneli lezixhumanisi kwifomu evamile. Enye yazo iqhutshwa ngokusebenzisa i-Excel interface, kanti okwesibili kuhilela ukufaka umyalo ngesandla usebenzisa ikhodi. Ake sicabangele ngokuningiliziwe ngezindlela zombili.

Indlela 1: sebenzisa isikhombikubona sohlelo

Indlela elula yokushintsha ukuboniswa kwamagama ekholomu kusuka ezinombeni kuya ezincwadini ukusebenzisa i-toolkit eqondile yohlelo.

1. Ukwenza ushintsho kuthebhu "Ifayela".



2. Ukuhambisa kusigaba "Izinketho".



3. Esikhathini sefasitela lezilungiselelo zohlelo oluvula, iya esigatshaneni "Amafomula".



4. Ngemva kokushintshela engxenyeni ephakathi kwewindi, sibheka ibhokisi lezilungiselelo. "Ukusebenza namafomula". Mayelana nepharamitha "I-Link Style R1C1" uncheck. Sicindezela inkinobho "Kulungile" phansi kwefasitela.

Manje igama lamakholomu kuphaneli yokuxhumanisa izothatha ifomu evamile, okungukuthi, lizochazwa ngezinhlamvu.

Indlela 2: Sebenzisa i-Macro

Ukhetho lwesibili njengesisombululo senkinga kuhilela ukusetshenziswa kwe-macro.

1. Yenza imodi yonjiniyela isebenze uma itholakala ukuthi ikhutshaziwe. Ukwenza lokhu, thuthela kuthebhu "Ifayela". Okulandelayo, chofoza okubhalwe phansi "Izinketho".



2. Ewindini evula, khetha into Ukusethwa kweRibhoni. Ngesokudla ngakwesokudla kwewindi, hlola ibhokisi "Unjiniyela". Sicindezela inkinobho "Kulungile". Ngakho, imodi yonjiniyela ivuliwe.



3. Iya kuthebhu "Developer". Sicindezela inkinobho "Visual Basic"elitholakala engxenyeni engakwesokunxele kwebhebhoni ebhokisini lesethingi "Ikhodi". Awukwazi ukwenza lezi zenzo ku-tape, kodwa mane uthayiphe isinqamuleli sekhibhodi I-Alt + F11.



4. Umhleli we-VBA uvula. Hitha isinqamuleli sekhibhodi Ctrl + G. Faka ikhodi efasiteleni evuliwe:

   Isicelo.IferenceStyle = xlA1

   Sicindezela inkinobho Ngena.

Emva kwalezi zenzo, ukuboniswa kwezinhlamvu zamagama ekholomu wephepha kuzobuya, esikhundleni senguqulo yezinombolo.

Njengoba ungabona, ukuguqulwa okungalindelekile egameni lamakholomu ekholomu kusuka ku-alfabhethi kuya kuzinombolo akufanele ukudibanisa umsebenzisi. Konke kulula kakhulu ukubuyela esimweni esidlule ngokushintsha imingcele ye-Excel. Kunengqondo ukusebenzisa inketho enkulu kuphela uma kungenxa yezizathu ezithile awukwazi ukusebenzisa indlela ejwayelekile. Isibonelo, ngenxa yohlobo oluthile lokuhluleka. Ngempela, ungasebenzisa le nketho ukuze uzame, ukuze ubone ukuthi lolu hlobo lokushintsha lusebenza kanjani.