Shintsha amagama wekholamu kusuka kunombolo kuya ku-alfabhethi

Kuyaziwa ukuthi esimweni esejwayelekile, izihloko zamakholamu ku-Excel zikhonjiswa ngezinhlamvu zamagama zesiLatini. Kepha, ngesinye isikhathi, umsebenzisi angathola ukuthi amakholomu manje akhonjiswa ngezinombolo. Lokhu kungenzeka ngezizathu ezahlukahlukene: izinhlobo ezahlukahlukene zokungasebenzi kahle kohlelo, okwakho ukwenza okungafanele, ukushintshwa kombukiso ngamabomu ngomunye umsebenzisi, njll. Kepha, noma ngabe yiziphi izizathu, uma kwenzeka kunesimo esifanayo, impikiswano yokubuyisa ukukhonjiswa kwamagama ekholamu ezweni elijwayelekile iyafaneleka. Ake sibheke ukuthi zingaguqulwa kanjani izinombolo eziya ezinhlamvwini ezise-Excel.

Izinketho zokushintsha zokubonisa

Kunezinketho ezimbili zokuletha iphaneli yokuhlanganisa kwifomu layo elijwayelekile. Enye yazo yenziwa ngesibonisi se-Excel, kanti esesibili sihlanganisa ukufaka i-oda ngesandla sisebenzisa ikhodi. Ake sibheke zombili lezi zindlela ngemininingwane eminingi.

Indlela 1: sebenzisa isikhombimsebenzisi sohlelo

Indlela elula yokushintsha imephu yamagama ekholamu ukusuka ezinombolweni kuye ezinhlotsheni ukusebenzisa i-toolkit eqondile yohlelo.

1. Senza ushintsho kuthebhu Ifayela.



2. Siqhubekela esigabeni "Izinketho".



3. Ewindini elivulayo, izilungiselelo zohlelo ziya esigatshaneni Amafomula.



4. Ngemuva koshintsho enkabeni yewindi, sifuna ibhulokhi yezilungiselelo "Ukusebenzisana namafomula". Eduze kwepharamitha "Isitayela sesixhumanisi se-R1C1" ungahloli. Chofoza inkinobho "Kulungile" phansi kwewindi.

Manje igama lamakholamu kwiphaneli yokuhlanganisa lizothatha ifomu elijwayelekile kithi, okungukuthi, lizokhonjiswa ngezinhlamvu.

Indlela 2: sebenzisa i-macro

Inketho yesibili njengesixazululo senkinga ifaka ukusetshenziswa kwe-macro.

1. Senza isebenze imodi kanjiniyela ethepheni, uma icishiwe. Ukuze wenze lokhu, iya kuthebhu Ifayela. Okulandelayo, chofoza okubhaliwe "Izinketho".



2. Ewindini elivulayo, khetha Ukusethwa kweRibbon. Engxenyeni engakwesokudla yewindi, hlola ibhokisi eliseduze "Unjiniyela". Chofoza inkinobho "Kulungile". Ngakho-ke, imodi yonjiniyela icushiwe.



3. Iya kuthebhu "kanjiniyela". Chofoza inkinobho "Okubonakalayo okuyisisekelo"etholakala onqenqemeni lwesobunxele impela lwebanga kwibhulokhi yezilungiselelo "Ikhodi". Awukwazi ukwenza lezi zenzo kwetheyiphu, kodwa mane uthayiphe isinqamuleli sekhibhodi kukhibhodi I-Alt + F11.



4. Umhleli we-VBA uyavula. Cindezela isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + G. Ewindini elivulayo, faka ikhodi:

   Isicelo.RefcerStyle = xlA1

   Chofoza inkinobho Ngena.

Ngemuva kwalezi zenzo, ukuvela kwezinhlamvu zamagama wekholamu kweshidi kuzobuya, kuguqule inketho yenombolo.

Njengoba ukwazi ukubona, ushintsho olungalindelekanga egameni lekholomu luxhumanisa ukusuka ku-alfabhethi luya kunombolo akufanele luphazamise umsebenzisi. Yonke into kalula kalula ingabuyiselwa esimweni sayo sangaphambilini ngokushintsha izilungiselelo ze-Excel. Inketho yokusebenzisa i-macro inengqondo ukusebenzisa kuphela uma, ngasizathu simbe, ungakwazi ukusebenzisa indlela ejwayelekile. Isibonelo, ngenxa yohlobo oluthile lokwehluleka. Yebo, ungasebenzisa le ndlela ngezinhloso zokuhlola, ukubona nje ukuthi lolu hlobo lokushintsha lusebenza kanjani.