Lapho usebenza e-Excel, kwesinye isikhathi ufuna ukufihla amakholomu. Ngemuva kwalokho, izinto ezikhonjisiwe ziyeka ukukhonjiswa ephepheni. Kepha ukuthi wenzeni uma udinga ukuvula ukukhombisa kwawo futhi? Ake sibheke lolu daba.
Khombisa amakholomu afihliwe
Ngaphambi kokuvumela ukuboniswa kwezinsika ezifihliwe, udinga ukuthola ukuthi zitholakala kuphi. Lokhu kulula ukukwenza. Onke amakholomu aku-Excel amakwe ngezinhlamvu zamagama zesiLatin ngokulandelana. Endaweni lapho lo mthetho wephulwa khona, ovezwa kungabikho ncwadi, kuthi kufakwe into ecashile.
Izindlela ezithile zokuqalisa kabusha ukubonisa amaseli afihliwe zincike ekutheni iyiphi indlela esetshenziselwe ukuwafihla.
Indlela yoku-1: hambisa imingcele ngesandla
Uma ufihla amaseli ngokuhambisa imingcele, ungazama ukukhombisa umugqa ngokuwuyisa endaweni yawo yangempela. Ukuze wenze lokhu, udinga ukufika emngceleni futhi ulinde ukuvela komcibisholo oqondile wezindlela ezimbili. Bese uqhafaza inkinobho yegundane kwesobunxele bese udonsela umcibisholo ohlangothini.
Ngemuva kwale nqubo, amaseli azokhonjiswa ngendlela eyandisiwe, njengoba ayenjalo ngaphambili.
Kuliqiniso, kumele kubhekwe ukuthi uma imingcele ihanjiswa ngokuqinile lapho icashe, khona-ke “ukuzikopela” ngale ndlela kuzoba nzima, uma kungenakwenzeka. Ngakho-ke, abasebenzisi abaningi bathanda ukuxazulula le nkinga ngokusebenzisa ezinye izinketho.
Indlela 2: imenyu yokuqukethwe
Indlela yokuvumela ukubonisa kwezinto ezifihliwe ngemenyu yokuqukethwe yindawo yonke futhi kufanelekile kuzo zonke izimo, akunandaba ukuthi ngabe ifihlwe yiphi indlela.
- Khetha imikhakha esondelene ngezinhlamvu kupaneli yokuqondisa evundlile, ephakathi kwekholomu efihliwe.
- Qhafaza kwesokudla ezintweni ezikhethiwe. Kumenyu yokuqukethwe, khetha Khombisa.
Manje amakholomu afihliwe azoqala ukubonisa futhi.
Indlela 3: Inkinobho YeRibbon
Kusetshenziswa inkinobho "Ifomathi" kwetheyiphu, njengohlobo lwangaphambilini, ilungele wonke amacala okuxazulula inkinga.
- Hambisa kuthebhu "Ikhaya"uma sikuthebhu ehlukile. Khetha noma yimaphi amaseli angomakhelwane phakathi lapho kukhona into efihlekile. Kubambo olubekwe ebhokisini lamathuluzi "Amaseli" chofoza inkinobho "Ifomathi". Imenyu iyavula. Ebhokisini lamathuluzi "Ukubonakala" hambisa uyokhomba Fihla noma ubonise. Kuluhlu olubonakala, khetha okufakiwe Khombisa Amakholamu.
- Ngemuva kwalezi zenzo, izinto ezihambisanayo zizophinda zibonakale.
Isifundo: Ungawafihla kanjani amakholamu e-Excel
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokuvumela ukubonisa kwamakholomu afihliwe. Ngasikhathi sinye, kufanele kuqashelwe ukuthi inketho yokuqala yokunyakaza kwemingcele kufanelekile kuphela uma amangqamuzana ayefihliwe ngendlela efanayo, futhi imingcele yawo ingahanjiswa ngokuqinile. Noma kunjalo, le ndlela ethile ibonakala kakhulu kumsebenzisi ongalungiselelwe. Kepha ezinye izindlela ezimbili usebenzisa imenyu yokuqukethwe nezinkinobho kubambo kufanelekile ukuxazulula le nkinga cishe kunoma yisiphi isimo, okungukuthi, zisemhlabeni wonke.
