Izindlela ezikhoyo zokufihla iikholomu kwi-Excel

Xa usebenza neprogram evela kwi-Microsoft Office Excel, ngamanye amaxesha kuyimfuneko ukufihla ezinye iikholomu okanye imigqa. Isizathu salokhu sinokuphucula ukufundwa komqulu okanye nje umnqweno wokufihla ezinye izibalo okanye idatha. Kule nxu lumene, abasebenzisi beprosoftware banombuzo othi: "njani ukufihla iikholomu kwi-Excel kunye nendlela yokubuyisela ukubukeka kwabo?".

Iindlela zokufihla iikholomu

Ukuphucula ukulungiswa kokusetyenziswa kwi-Excel, le nkqubo iqukethe imisebenzi evumela ukuba ufihle uluhlu oluthile lweeseli. Akunandaba nokuba ezinye iinkcukacha zigcinwe kuzo, okanye zizinanto. Ukuze ufezekise ukufihla kweminye okanye iikholam ezininzi, kufuneka wenze enye yezi zinto ezilandelayo ezilandelayo.

• Khetha iiseli zale kholamu ofuna ukuzifihla ngokugqithisa kwibala elikhethiweyo - iintloko zekholomu ziza kutshintsha kumbala omnyama kunye neqhosha lokunene. Kwimenyu evuliwe yomxholo khetha umyalelo othi "Fihla".
• Emva kokuba ukhethe iikholomu eziyimfuneko ngokubanzi, cinezela iqhosha le "Imenyu" kwibhobhobhodi, eya kubangela ukuvulwa okufanayo kwimenyu yomongo, emva koko ukhethe umyalelo othi "Fihla".
• Ukukhetha enye okanye iiseli ezininzi kwiikholamu ezikhethiweyo, qhubeka nale miyalelo elandelayo. Kwibar ye-Quick Access, khetha "Ikhaya", ngoko ufumane "iiselingi" kwibar yomhla wendawo apho ucofa iqhosha "Fomati". Kuluhlu oluhla-phantsi, funda isihloko esithi "Ukubonakala", equlethe into ethi "Fihla okanye ibonise", apho ukhetha umyalelo "Fihla imigqa".
• Ukuze ufezekise umphumo wokukhawuleza, i-Excel inesethi yokutshisa ongayisebenzisa ukufihla iikholomu ngokucinezela ezimbini iifowuni kwikhibhodi. Ukukhetha iiseli zamakholomu ofuna ukuzifihla, kufuneka ucine iqhosha elibalulekileyo: "Ctrl" + "0".

Njengoko ubona, ukuba ufuna ukuqonda indlela yokufihla iikholomu kwi-Excel, unokufunda oku lula.

Buyela ukubonakala kwiikholam

Emva kokufihla iikholam, kukho umbuzo malunga nendlela yokuvula iikholuni ezifihliweyo kwi-Excel. Ukubuya kweeseli ezifihliweyo kulula kakhulu - ngokukhetha uluhlu lweeseli ezinemiqolo emibini phakathi kwezinto ezifihliweyo zamakholomu, ukwenza izenzo ezifanayo, kunye nokuzifihla, ngokukhetha umyalelo othi "Bonisa imikholomu" ekugqibeleni. Kwimeko yokusebenzisa i-hotkeys, cindezela udibaniso: "Ctrl" + "Shift" + "0".

Yintoni enye ongayifihla?

Ukongeza kwiikholam, i-Excel inikezela umsebenzisi ukufihla imigca kunye kunye namaphepha onke. Ukufihla okanye ukubonisa imigqa, kufuneka wenze ngendlela efanayo nendlela yokufihla nendlela yokubonisa iikholomu ezifihliweyo kwi-Excel. Uhlobo olulodwa lukhethiweyo kumhlathi wokugqibela womyalelo othi "Fihla imigqa" kunye ne "Bonisa imigqa" kunye nokudibanisa okutshintshiweyo kwezitshixo: "Ctrl" + "9" ukufihla kunye ne "Ctrl" + "Shift" + "9" ukubonisa imigca.

Xa usebenza ngeeshicilelo, inkqubo ibukeka eyahlukileyo, ngokuthelekiswa nendlela yokufihla iikholomu kwi-Excel. Ungafihla okanye ubonise ishidi usebenzisa ithebhu "Fomati", ngokukhetha "Fihla iphepha" ukusuka kwi-Hide okanye Show menu, ngelixa kwiphepha elifunekayo ukufihla iphepha. Ukuze ubuyeke ukubonakala, kwanele ukwenza inkqubo efanayo ngokukhetha "Bonisa ishidi" ngokukhetha amaphepha efunekayo kwifestile evula. Unokwenza oku ngokuchofoza ngokuchanekileyo kwiphaneli equkethe uluhlu lwamashidi apho unokukhetha ukucasha okanye ukubonisa into.

Ukuchaneka kweeseli ezifihliweyo

Emva kokuqonda indlela yokufihla imigca kunye nendlela yokufihla iikholomu kwi-Excel, unokwenza lula umsebenzi wakho. Ubuncedo beeseli ezifihliweyo kukungabikho kokushicilela-ukuze ungabandakanyi kwimveliso evela kwiphepha elingenasiphelo, ngelixa ungahlaziyi uxwebhu ngokwalo. Enye inzuzo kukunyusa ukufundwa kwedatha - kulo mzekelo, ngokufihla iikholomu ezingadingekile, unokufumana idatha ebalulekileyo ngokubhekelana nomnye.