Iindlela ezi-3 zokufihla iikholamu kwitafile ye-Excel

I-Excel yinkqubo eyahlukileyo, njengoko inamathuba amaninzi, uninzi lwawo lwenza ukuba lenze lula umsebenzi kunye neetafile. Eli nqaku liza kuthetha ngenye yeempawu ezikuvumela ukuba uzifihle iikholamu kwiplate. Enkosi kuye, iya kuba, umzekelo, ukufihla ukubala okubhaliweyo okuya kuphazamisa ingqalelo kwisiphumo sokugqibela. Okwangoku, iindlela ezininzi ziyafumaneka, nganye eza kuchazwa ngokweenkcukacha ngezantsi.

Indlela yoku-1: I-protinal yomda

Le ndlela ilula kangangoko inokwenzeka kwaye isebenza. Ukuba uqwalasela iintshukumo ngakumbi, kuya kufuneka wenze oku kulandelayo:

1. Ukuqala, nikela ingqalelo kumgca wokulungelelanisa, umzekelo, ephezulu. Ukuba uzisa isikhombisi kumda wekholam, uya kutshintsha kwaye uya kujongeka njengomgca omnyama oneentolo ezimbini emacaleni. Oku kuthetha ukuba unokuhambisa ngokukhuselekileyo umda.

Ke ujongeka ngathi sisikhombisi ngelixa sitshintsha umda wekholamu

1. Ukuba umda usondele kangangoko kunokwenzeka kumda ongummelwane, ikholamu ineenkolelo kangangokuba ayizukuphinda ibonwe.

Ke ujongeka ngathi ngumqolo ofihliweyo

Indlela 2: Imenyu yeMxholo

Le ndlela ithandwa kakhulu kwaye inyanzelekile kubo bonke abanye. Ukuphunyezwa kwayo, kuya kwanela ukwenza uluhlu lwezi zenzo zilandelayo:

1. Ukuqala, kuya kufuneka ucofe iqhosha lemouse lasekunene kwigama lekholamu.

Kwanele ukwaba enye yeekholamu

1. Imenyu yemeko iyavela, ekwanele ukufumana "Fihla".

Nantsi into oyifunayo kwimenyu yomxholo

1. Emva kwezenzo ezenziweyo, kuya kufihla ikholamu. Iya kushiywe kuphela ukuba izame ukuyibuyisela kwimeko yoqobo ukuze imeko yempazamo ibinokwenzeka ukuba uyilungise ngokukhawuleza.

Emva kokwenza izinto, kuya kufihlwa ikholamu

1. Akukho nto inzima koku, kwanele ukukhetha iikholamu ezimbini, phakathi kwekholamu yethu ephambili ifihlwe. Cofa kuzo ngeqhosha le mouse lasekunene kwaye ukhethe i "Veza". Emva koko, kuya kuvela ikholamu etafileni, kwaye inokusetyenziswa kwakhona.

Enkosi ngale ndlela, kuya kuba nako ukusebenzisa eli nqaku, longa ixesha kwaye ungakhathazeki ngemida yokuqinisa. Olu khetho lolona lula, ngenxa yoko, lubango phakathi kwabasebenzisi. Enye into enomdla yale ndlela kukuba yenza ukuba kwenzeke ukuba kufike iikholamu ezininzi kwangoko. Ukwenza oku, kuya kwanela ukwenza le nto ilandelayo:

1. Ukuqala, yabele zonke iikholamu ezifuna ukufihlwa. Ukwenza oku, i-clamp "Ctrl" kwaye ucofe iqhosha lemouse lasekhohlo kuzo zonke iikholamu.

Ukukhetha iikholamu ezininzi

1. Okulandelayo, kwanele ukucofa ngasekunene kunqakraza kwikholamu ekhethiweyo kwaye ukhethe "Fihla" kwimenyu eyehlayo.

Imenyu yokujonga umxholo kunye nomsebenzi uhlala ungaguqukanga

1. Emva kwezenzo ezenziweyo, zonke iikholamu ziyafihla.

Izazisi ezibonakalayo ziya kufihlwa ngokufanayo kwiimeko xa zifihla ikholamu enye

Ngenxa yethuba elinjalo, zonke iikholamu ezikhoyo zinokufihlwa kakhulu, ngelixa ichitha ixesha elincinci. Eyona nto iphambili kukukhumbula malunga nomyalelo wazo zonke iintshukumo kwaye uzame ukungakhawulezi ukukhusela impazamo.

Indlela 3: Izixhobo kwiRibbon

Kukho enye indlela esebenzayo eya kufezekisa iziphumo ezifunwayo. Ngeli xesha kubalulekile ukusebenzisa ibar yesixhobo ngaphezulu. Inyathelo lenyathelo lenyathelo ngolu hlobo lulandelayo:

1. Okokuqala, khetha iseli yekholamu oceba ukuyifihla.

Unokukhetha nayiphi na iseli kwikholamu efunwayo

1. Emva koko siphendukela kwi-Toolbar kwaye sisebenzise icandelo "lasekhaya" ukuya kwifomathi yefomathi.
2. Kwimenyu evuliweyo, kufuneka ukhethe "Fihla okanye ukubonisa" into, emva koko ukhethe "Fihla iikholamu".

Isenzo senyathelo ngenyathelo

Ukuba yonke into yenziwe ngokuchanekileyo, iikholamu ziya kuzifihla kwaye aziyi kuphinda ilayishe itafile. Le ndlela idlulisa zombini ukufihla ikholamu enye kunye nemizuzu eliqela. Ngokubhekisele kwiskena sabo esibuyileyo, imiyalelo eneenkcukacha yokusetyenziswa kwesenzo yaqwalaselwa ngaphezulu kwesi sixhobo, siyisebenzisa, unokuzityhila ngokulula zonke iikholamu ezifihliwe ngaphambili.

Ukuqukumbela

Ngoku unalo lonke ulwazi oluyimfuneko oluza kuqhubeka nokusebenzisa amandla okufihla iikholamu ezongeziweyo, ukwenza ukuba itafile ilungele ukusetyenziswa. Zonke iindlela ezintathu azinangxaki kwaye zifikeleleke kumsebenzisi ngamnye weProjekthi ye-Excel yeTheyibhile-zombini ezisandula ukufika kunye nengcali.

Umyalezo 3 wendlela, indlela yokufihla iikholamu kwitheyibhile ye-Excel kuqala yavela kwitekhnoloji yolwazi.