Okuqukethwe
Ngenkathi usebenza ku-Excel, izimo zivame ukuvela lapho amakholomu athile etafula edinga ukufihlwa. Umphumela ucacile - amanye amakholomu afihliwe futhi awasaboniswa encwadini. Nokho, lesi senzo sinokuphambene - okungukuthi, ukudalulwa kwamakholomu. Futhi ngezansi sizobheka ukuthi ungavula kanjani isibonisi samakholomu afihliwe emuva.
Okuqukethwe
Okokuqala udinga ukuqonda uma kukhona amakholomu afihliwe etafuleni futhi unqume indawo yawo. Lo msebenzi kulula ukuwenza, futhi iphaneli yokuxhumanisa enezingqimba yohlelo, lapho amagama amakholomu aboniswa khona, izosisiza kulokhu. Sinaka ukuhleleka kwamagama, uma kungabonwa endaweni ethile, kusho ukuthi kule ndawo kukhona ikholomu efihliwe (amakholomu).
Manje njengoba sesinqume ngobukhona kanye nendawo yezinto ezifihliwe, singaqhubeka. Kunezindlela ezimbalwa zokwenza amakholomu abonakale futhi.
Indlela 1: I-Boundary Shift
Ungabonisa amakholomu afihliwe ngokwandisa imingcele noma ukuwabuyisela endaweni yawo yokuqala.
- Ukuze wenze lokhu, hambisa ikhesa phezu komngcele wekholomu, ngokushesha nje lapho isishintshela kumcibisholo onezinhlangothi ezimbili, cindezela inkinobho yegundane kwesokunxele bese uyihudulela lapho oyifunayo.
- Ngalesi senzo esilula, siphinde senza ikholomu “С” ebonakalayo.
Qaphela: Le ndlela ilula, nokho, abanye abasebenzisi bangase bangasithandi isikhathi lapho kufanele "baxhume" emugqeni omncane womngcele, bezama ukuwususa. Ngaphezu kwalokho, uma kuziwa kumakholomu amaningana afihliwe, le ndlela iba nzima kakhulu. Ngenhlanhla, zikhona ezinye izindlela, esizozibheka ngokulandelayo.
Indlela 2: Ukusebenzisa Imenyu Yokuqukethwe
Mhlawumbe lena yindlela ethandwa kakhulu evumela ukuthi ubonise amakholomu afihliwe.
- Kuphaneli yokuxhumanisa, sikhetha nganoma iyiphi indlela esilungele (isibonelo, sisebenzisa inkinobho yegundane engakwesokunxele) uhla lwamakholomu, ngaphakathi okunezici ezifihliwe.
- Chofoza kwesokudla noma yikuphi endaweni ekhethiwe. Ohlwini oluvulayo, chofoza umyalo “Bonisa”.
- Ngenxa yalokho, wonke amakholomu afihliwe kulobu bubanzi azoboniswa kuthebula futhi.
Indlela yesi-3: Amathuluzi eRibhoni
Kulokhu, i-Ribbon yamathuluzi ohlelo ngeke isize.
- Khetha kuphaneli yokuxhumanisa ububanzi bamakholomu lapho kunezinto ezifihliwe. Shintshela kuthebhu "Ikhaya". Esigabeni “Amaseli” chofoza inkinobho "Ifomethi". Ohlwini oluvelayo, chofoza entweni "Fihla noma ubonise" (isigatshana "Ukubonakala") bese “Bonisa amakholomu”.
- Amakholomu afihliwe azobonakala futhi.
Isiphetho
Amakholomu afihliwe isici esiwusizo esikuvumela ukuthi ukhiphe okwesikhashana ulwazi olungadingekile kusipredishithi se-Excel, okusenze kube lula ukusebenza ngaso futhi kube lula ukusiqonda. Nokho, akubona bonke abasebenzisi abakwaziyo ukubuyisela izinto ezifihliwe endaweni yazo. Lokhu kungenziwa ngezindlela ezintathu ezahlukene, okulula ukuzifunda.