Indlela yoku-1: Ukucinezela umgca wemigca efihliweyo
Nangona imigca ayiboniswanga etafileni, zinokuqatshelwa kwiPlene yasekhohlo, apho amanani adwelisiweyo aboniswa khona. Uluhlu olufihliweyo lunexesha elincinci elinokutshitshiswa kabini ukubonisa yonke imigca kuyo.
Ziya kusuka ngoko nangoko, kwaye ukuba iziqulatho ngaphakathi unokubukela. Ukuba indlela enjalo ayifanelekanga ngenxa yokuba iintambo zisasazeke ecaleni kwetafile okanye icinezelekile azizange ziphelelwe, sebenzisa ezinye iindlela.
Indlela 2: Imenyu yeMxholo
Olu khetho luza kulungela abo basebenzisi abanemigca efihlakeleyo baqhubeka, kodwa kwangaxeshanye ucofe abakuncedisi okanye basebenzise ukhetho lwangaphambili kukungazithembi. Emva koko zama ukwenza amasimi abonakalayo kwimenyu yemeko.
- Ibalaselisa itafile yonke okanye kuphela imitya kuluhlu olufihliweyo.
- Cofa nawaphi na amanani emiqolo yeqhosha leqhosha lemouse lasekunene kwaye kwimenyu yemeko evelayo, khetha "bonisa".
- Imigca efihlakeleyo ngaphambili iya kuboniswa kwangoko kwitafile, oko kuthetha ukuba umsebenzi ugqityiwe ngempumelelo.
Indlela 3: Ikhibhodi yekhibhodi
Enye indlela ekhawulezayo yokubonisa imitya efihliweyo kukusebenzisa i-CTRL ye-CTRL + ye-9 ye-9, efumanekayo kwi-Excel ngokungagqibekanga. Ukwenza oku, akukho mfuneko yokuba ufunde indawo yamasimi okanye abele imiqolo ecaleni kwabo. Phumela nje le mdibaniso kwaye ngoko nangoko ubone iziphumo.
Indlela 4: Imenyu "Iiseli zefomathi"
Ngamanye amaxesha ukubonisa yonke imiqolo kwangoko ukuba inketho ifanelekileyo iba kukusetyenziswa komsebenzi kwenye imenyu ye-Excel.
- Ukuba kwithebhu yasekhaya, vula ibhloko "yeseli".
- Yandisa "ifomathi" yemenyu eyehlileyo.
- Kuyo, imouse ngaphezulu "Fihla okanye ibonise" isikhombisi, apho unokukhetha khona imigca.
- Ukubonakala kwemigca kuya kuhlala kugxininisiwe, ngenxa yoko abayi kuba nzima ukubafumana kuyo yonke itafile. Kwangelo xesha, eyona nto iphambili ayizukucofa kwindawo engenanto ukuze ngengozi ayisusi ukhetho xa ufuna ukukhangela.