Ukuqamba kabusha amashidi ku-Excel

Lapho sakha idokhumenti entsha ku-Excel, singaqaphela ithebhu eyodwa noma ngaphezulu ngezansi, abizwa ngokuthi amashidi ezincwadi. Ngesikhathi somsebenzi, singashintsha phakathi kwawo, sakhe amasha, sisuse ezingadingekile, njll. Uhlelo lunikeza ngokuzenzakalelayo amagama esifanekiso anezinombolo ezilandelanayo kumashidi: “Ishidi1”, “Ishidi2”, “Ishidi3”, njll. Uma kukhona zimbalwa zazo, akubalulekile kangako. Kodwa uma kufanele usebenze ngenani elikhulu lamashidi, ukuze kube lula ukuhamba kuwo, ungawaqamba kabusha. Ake sibone ukuthi lokhu kwenziwa kanjani ku-Excel.

Ukuqamba kabusha ishidi

Igama leshidi alikwazi ukuqukatha izinhlamvu ezingaphezu kwezingu-31, kodwa futhi akumele lingabi nalutho. Ingasebenzisa izinhlamvu zanoma yiluphi ulimi, izinombolo, izikhala, nezimpawu, ngaphandle kwalokhu okulandelayo: “?”, “/”, “”, “:”, “*”, “[]”.

Uma ngesizathu esithile igama lingafaneleki, i-Excel ngeke ikuvumele ukuthi uqedele inqubo yokuqamba kabusha.

Manje ake siye ngqo ezindleleni ongazisebenzisa ukuqamba kabusha amashidi.

Indlela 1: Ukusebenzisa Imenyu Yokuqukethwe

Le ndlela ingenye ethandwa kakhulu phakathi kwabasebenzisi. Kwenziwa kanje:

1. Chofoza kwesokudla kulebula yeshidi, bese kumenyu yokuqukethwe evulayo, khetha umyalo "Qamba kabusha".
2. Imodi yokuhlela igama leshidi yenziwe yasebenza.
3. Faka igama olifunayo bese uchofoza Fakalokho kulondoloza.

Indlela yesi-2: chofoza kabili kulebula yeshidi

Nakuba indlela echazwe ngenhla ilula kakhulu, kukhona inketho elula futhi esheshayo.

1. Chofoza kabili kulebula yeshidi ngenkinobho yegundane engakwesokunxele.
2. Igama lizoqala ukusebenza futhi singaqala ukulihlela.

Indlela yesi-3: Ukusebenzisa Ithuluzi Leribhoni

Le nketho isetshenziswa kancane kakhulu kunezimbili zokuqala.

1. Ngokukhetha ishidi olifunayo kuthebhu "Ikhaya" chofoza inkinobho "Ifomethi" (ibhulokhi yamathuluzi “Amaseli”).
2. Ohlwini oluvulayo, khetha umyalo “Qamba Kabusha Ishidi”.
3. Okulandelayo, faka igama elisha bese uligcina.

Qaphela: Uma udinga ukuqamba kabusha hhayi elilodwa, kodwa inombolo enkulu yamashidi ngesikhathi esisodwa, ungasebenzisa ama-macros akhethekile nezengezo ezibhalwe ngabathuthukisi bezinkampani zangaphandle. Kodwa njengoba lolu hlobo lokusebenza ludingeka ezimweni ezingavamile, ngeke sigxile kulo ngokuningiliziwe ngaphakathi kohlaka lwalolu shicilelo.

Isiphetho

Ngakho-ke, abathuthukisi bohlelo lwe-Excel banikeze izindlela ezimbalwa ngesikhathi esisodwa, ongazisebenzisa ukuqamba kabusha amashidi encwadini yokusebenzela. Zilula kakhulu, okusho ukuthi ukuze uziqonde futhi uzikhumbule, udinga ukwenza lezi zinyathelo izikhathi ezimbalwa kuphela.