Izindlela okusemandleni ukuze bafihle amakholomu Excel

Ukusebenza kohlelo kusuka e-Microsoft Office Excel kwesinye isikhathi kuqakathekile ukuze ufihle abanye amakhalamu noma imigqa. Isizathu salokhu zingaba ukuthuthukisa readability idokhumenti noma nje isifiso ukufihla kokusebenzisa izibalo idatha. Kule ndaba, abasebenzisa amathuluzi isofthiwe umbuzo: "Indlela ukufihla amakholomu Excel nokuthi ukuze ubuyele ukubonakala kwazo?".

Izindlela ukufihla amakholomu

Ukuze kube lula ukusebenza Excel hlelo luqukethe imisebenzi ukufihla uhla ethile amaseli. Akunandaba ukuthi baqhubeka olunye ulwazi noma kuyizinto ezingezona ezingokoqobo. Ukuze kuzuzwe esikhoselweni eyodwa noma ngaphezulu izinsika, kufanele wenze omunye algorithm ezine ezilandelayo.

• Khetha iseli kwekholomu ufuna ukufihla, hambisa isikhombisi igundane on esikhethiwe - izihloko ikholomu uzobe ababethi umbala mnyama, futhi wenze ukuchofoza ngakwesokudla. Esikhathini imenyu yengqikithi ukhethe "Fihla".
• Ukunikeza amakholomu kunesidingo iyonke, ukukhiqiza cindezela ku ikhibhodi inkinobho "Imenyu", okuyoholela ukudalulwa efanayo kwimenyu yokuqukethwe, bese futhi wenze "Fihla" Ukukhetha umyalo.
• Ukukhetha amaseli eyodwa noma ngaphezulu ku amakholomu akhethiwe, landela imiyalo ezilandelayo. I iThulibha Yongeno Olusheshayo, khetha "Ekhaya", tfola yamathuluzi "Amaseli", lapho uchofoza "Ifomethi" isithonjana. Esikhathini uhlu olwehlayo ukuthola isihloko "ukubonakala", equkethe "Fihla noma ukubonisa" lapho ukhetha "Fihla umugqa."
• Ukuze kuzuzwe imiphumela esheshayo Excel banikwa iqoqo hotkey, lapho ufuna ukufihla amakholomu ngokucindezela izinkinobho ezimbili ikhibhodi. Ukukhetha kukholomu kuseli ufuna ukufihla, cindezela izinqamuleli zekhibhodi: "Ctrl" + "0".

Njengoba ubona, uma kunesidingo, ukuze uqonde ukuthi ukufihla amakholomu Excel, ukufunda lokhu akunzima.

Buyelani amakholomu abonakalayo

Ngemva ukufihla amakholomu ngokuvamile kuphakama umbuzo mayelana nendlela ukuvula ekumakholomu afihliwe e-Excel. Ukubuya amaseli ezifihliwe okulula kakhulu - ukugqamisa ezinye ibanga lamaseli eliqukethe Izinsika zombili, phakathi lapho kukhona ezifihliwe, wenze izenzo efanayo zokucasha zabo by ekupheleni phuzu umyalo "Bonisa amakholomu". Endabeni usebenzisa inhlanganisela hotkey kwanele ucindezela: "Ctrl" + "Shift" + "0".

Yini enye eningayenza ukufihla?

Ngaphezu amakholomu, Excel abashukumisela umsebenzisi ukufihla imigqa kakhudlwana futhi, kanye lonke ikhasi. Ukukhombisa noma ukufihla umugqa, kubalulekile ukwenza ngendlela efanayo, kanjani ukufihla futhi indlela yokubonisa amakholomu afihlekile Excel. Umahluko owokuthi kukhethwa ekupheleni phuzu umyalo "Fihla Imigqa" futhi "Khombisa umugqa", futhi kancane Ushintshe sekhibhodi: "Ctrl" + "9" ukufihla futhi "Ctrl" + "Shift" + "9" ukubonisa emigqeni.

Lapho ukusebenza inqubo ishidi Kuthi ezahlukene, uma iqhathaniswa nayo indlela ukufihla amakholomu Excel. Fihla noma sibonise uhlu, ungasebenzisa ithebhu "Ifomethi" ngokukhetha "Fihla noma ukubonisa" command "fihla ishidi", kuyilapho ngesikhathi ishidi oyifunayo ukufihla. ngokwanele ukuba benze okufanayo ukubuya ukubonakala ngokukhetha "Bonisa ohlwini" ngokukhetha ewindini elivelayo amashidi kunesidingo. Lokhu kungabuye kwenziwe ngokuchofoza panel, equkethe uhlu uhlu lapho ukuze uveze iphuzu kukhethwa wafihla noma ukubonisa.

Ngokucacile kwamaseli ezifihliwe

Ngokuqonda kanjani ukufihla imigqa futhi kanjani ukufihla amakholomu Excel, ungakwazi kakhulu lula umsebenzi wakho. Buhle amaseli ezifihliwe Ukuntula kwabo ukuphrinta - ngaleyo ndlela kungenziwa ngaphandle kusukela idatha okukhipha ephepheni, okuyizinto engadingekile, ngaphandle ekuhleleni idokhumenti. Enye inzuzo ukuthi ukwandisa readability idatha - kulesi simo, ukufihla amakholomu ezingadingekile, kungenzeka ngokufanele idatha okunenjongo eduze komunye nomunye.