Izihloko nezinyawo ziyizinkambu ezisezingeni eliphezulu nangaphansi kwe-Excel sheet. Amanothi alotshiwe kanye neminye imininingwane ngokuqonda komsebenzisi. Ngesikhathi esifanayo, ukubhaliswa kuzodlula, okuwukuthi, uma uqopha ekhasini elilodwa, lizoboniswa kwamanye amakhasi omadokhumenti endaweni efanayo. Kodwa, ngezinye izikhathi abasebenzisi bahlangana nenkinga uma bengakwazi ukukhubaza noma ukususa ngokuphelele unhlokweni nonyawo. Ngokuvamile lokhu kwenzeka uma befaka iphutha. Ake sithole ukuthi singasusa kanjani izihloko nezinyawo kwi-Excel.
Izindlela zokususa izihloko nezinyawo
Kunezindlela eziningana zokususa izihloko nezinyawo. Zingahlukaniswa ngamaqembu amabili: zifihla izinyawo kanye nokususwa kwazo okuphelele.
Indlela 1: Fihla Amanqina
Uma ufihla izinyawo kanye nokuqukethwe kwazo ngendlela yamanothi empeleni uhlala kudokhumenti, kodwa akubonakali nje kwesikrini sokuqapha. Kuhlale kunokwenzeka ukuwavula uma kunesidingo.
Ukuze ufihle izinhlokweni nezinyawo, kwanele ukushintsha i-Excel kusukela ekusebenzeni kwimodi yokuhlela ikhasi kunoma iyiphi enye imodi ebhasini lesimo. Ukuze wenze lokhu, chofoza isithonjana kubha yesimo "Okuvamile" noma "Ikhasi".
Emva kwalokho izinhloko nezinyawo zizofihlwa.
Indlela 2: ukususwa okubhaliwe kwezihloko nezinyawo
Njengoba kushiwo ngenhla, usebenzisa indlela yangaphambilini, izihloko nezinyawo akususwanga, kodwa zifihliwe kuphela. Ukuze ususe ngokuphelele unhlokweni kanye nonyawo nawo wonke amanothi namanothi atholakala lapho, udinga ukwenza ngendlela ehlukile.
- Iya kuthebhu "Faka".
- Chofoza inkinobho "Izinyawo"okuyinto efakwe kwi-tape ebhodini lamathuluzi "Umbhalo".
- Susa konke okufakwayo emahlokweni nasezinyaweni ekhasini ngalinye leledokhumenti ngesandla usebenzisa inkinobho Susa kwikhibhodi.
- Ngemuva kokuthi yonke idatha isusiwe, cisha ukubonisa kwezinhloko nezinyathelo ngendlela echazwe ngaphambili ebhasini lesimo.
Kumele kuqashelwe ukuthi amanothi akhishwe ngale ndlela ezinyaweni azosuswa phakade, futhi ngeke kwenzeke ukuvula umbukiso wabo. Kuzodingeka wenze kabusha ukurekhoda.
Indlela 3: susa ngokuzenzakalelayo izinhlokweni nezinyawo
Uma idokhumenti encane, indlela echazwe ngasenhla yokukhipha izinhloko nezinyawo akuthathi isikhathi esiningi. Kodwa yini okufanele uyenze uma le ncwadi iqukethe amakhasi amaningi, ngoba kulokhu, kungathatha amahora ukuhlanza? Kulesi simo, kunengqondo ukusebenzisa indlela evumela ukuthi ukhiphe izingqikithi nezinyawo ngezinto ngokuzenzakalelayo kusuka kuwo wonke amashidi.
- Khetha amakhasi ofuna ukususa izihloko nezinyawo. Bese, iya kuthebhu "Ukumaketha".
- On the tape ebhodini amathuluzi "Izilungiselelo zekhasi" Chofoza kusithonjana esincane ngesimo somcibisholo oblique esisekhoneni elingezansi elingakwesokudla sale block.
- Ewindini lezilungiselelo zekhasi ezivula, iya kuthebhu "Izinyawo".
- Kwimingcele "Isihloko" futhi Ngama-footer ngenye indlela shayela uhlu oludonsela phansi. Kuloluhlu, khetha into "(Cha)". Chofoza inkinobho "Kulungile".
Njengoba ubona, ngemuva kwalokhu, konke okufakwe ezinyaweni zamakhasi akhethiwe kwasulwa. Manje, njengesikhathi sokugcina, udinga ukuvala imodi yokuhamba ngezinyawo ngesithonjana kubha yomumo.
Manje izinhloko nezinyawo zikhishwa ngokuphelele, okungukuthi, ngeke ziboniswe kuphela esikrinini sokuqapha, kodwa zizosuswa kusukela kwimemori yefayela.
Njengoba ungabona, uma wazi ezinye ze-nuances zokwenza uhlelo lwe-Excel, ukususa izinyawo ukusuka emsebenzini omude nokujwayelekile kungaba inqubo esheshayo. Kodwa-ke, uma lo mbhalo unamakhasi ambalwa kuphela, ungasebenzisa ukususwa okubhaliwe. Into esemqoka ukunquma ukuthi yini ofuna ukuyenza: ususe ngokuphelele izinyawo noma uzifihle okwesikhashana.
