Amakholomu afihliwe ku-Excel. Izindlela Ezi-3 Zokubonisa Amakholomu Afihliwe ku-Excel

Ngokuvamile lapho usebenzisa umhleli wespredishithi, kuba nezikhathi lapho kudingeka khona ukuthi amakholomu athile ethebula afihlwe. Ngenxa yalezi zenzo, amakholomu adingekayo ayafihlwa, futhi awasabonakali kudokhumenti yesipredishithi. Nokho, kukhona nokusebenza okuphambene - amakholomu anwetshwayo. Esihlokweni, sizocubungula ngokuningiliziwe izindlela ezimbalwa zokwenza le nqubo kumhleli wespredishithi.

Ibonisa Amakholomu Afihliwe Kumhleli Wethebula

Ukufihla amakholomu kuyithuluzi eliwusizo elikuvumela ukuthi ubeke izinto ngendlela efanele endaweni yokusebenza yedokhumenti yesipredishithi. Lo msebenzi uvame ukusetshenziswa ezimweni ezilandelayo:

1. Umsebenzisi ufuna ukuqhathanisa amakholomu amabili ahlukaniswe amanye amakholomu. Isibonelo, udinga ukuqhathanisa ikholomu A nekholomu Z. Kulesi simo, kuzoba lula ukwenza inqubo yokufihla amakholomu aphazamisayo.
2. Umsebenzisi ufuna ukufihla inani lamakholomu asizayo engeziwe anezibalo namafomula amvimbela ekusebenzeni kahle ngolwazi olutholakala endaweni yokusebenza yedokhumenti yesipredishithi.
3. Umsebenzisi ufuna ukufihla amakholomu athile edokhumenti yesipredishithi ukuze angaphazamisi ukubukwa kolwazi lwethebula ngabanye abasebenzisi abazosebenza kule dokhumenti.

Manje ake sikhulume ngendlela yokuqalisa ukuvula amakholomu afihliwe kusihleli sespredishithi se-Excel.

Ekuqaleni, udinga ukuqinisekisa ukuthi kukhona amakholomu afihliwe epuleti, bese unquma indawo yawo. Le nqubo isetshenziswa kalula kusetshenziswa ibha yokuhlanganisa evundlile yomhleli wespredishithi. Kudingekile ukubheka ngokucophelela ukulandelana kwamagama, uma kuphulwa, khona-ke kule ndawo kukhona ikholomu efihliwe noma amakholomu amaningana.

Ngemuva kokuthi sithole ukuthi kunezingxenye ezifihliwe kudokhumenti yesipredishithi, kuyadingeka ukwenza inqubo yokudalulwa kwazo. Le nqubo ingenziwa ngezindlela eziningi.

Indlela yokuqala: ukuhambisa imingcele yamaseli

Imiyalelo enemininingwane yokuhambisa imingcele yeseli kudokhumenti yesipredishithi ibukeka kanje:

1. Hambisa isikhombisi emngceleni wekholomu. Ikhesa izoba sesimweni somugqa omncane omnyama ngemicibisholo ebheke ezinhlangothini eziphambene. Ngokucindezela inkinobho yegundane engakwesokunxele, sihudula imingcele ngendlela edingekayo.

2. Le nqubo elula ikuvumela ukuthi wenze ikholomu ebhalwe ukuthi “C” ibonakale. Ilungile!

Kubalulekile! Le ndlela ilula kakhulu ukuyisebenzisa, kodwa uma kunamakholomu amaningi kakhulu afihliwe kudokhumenti yesipredishithi, khona-ke le nqubo izodinga ukwenziwa izikhathi eziningi, okuyinto engalungile kakhulu, lapho kufaneleka kakhulu ukuyisebenzisa. izindlela esizoxoxa ngazo kamuva.

Indlela yesibili: ukusebenzisa imenyu yokuqukethwe ekhethekile

Le ndlela ivame kakhulu phakathi kwabasebenzisi bomhleli wespredishithi. Njengalena engenhla, ikuvumela ukuthi usebenzise ukudalulwa kwamakholomu afihliwe. Imiyalelo enemininingwane yokusebenzisa imenyu yokuqukethwe okukhethekile kudokhumenti yespredishithi ibukeka kanje:

1. Ngokucindezela inkinobho yegundane engakwesokunxele, sikhetha ububanzi bamakholomu kuphaneli yokuxhumanisa. Udinga ukukhetha lawo maseli lapho amakholomu afihliwe atholakala khona. Ungakhetha yonke indawo yokusebenza usebenzisa inhlanganisela yenkinobho ethi Ctrl + A.

2. Chofoza kwesokudla noma yikuphi ebangeni elikhethiwe. Uhlu olukhulu luvele esikrinini, olukuvumela ukuthi wenze izinguquko ezihlukahlukene endaweni ekhethiwe. Sithola isici esinegama elithi "Show", bese uchofoza kuso ngenkinobho yegundane kwesokunxele.

3. Ngenxa yalokho, wonke amakholomu afihliwe ebangeni elikhethiwe azovezwa kudokhumenti yesipredishithi. Ilungile!

Indlela yesithathu: ukusebenzisa izakhi kuribhoni elikhethekile

Le ndlela ihlanganisa ukusetshenziswa kweribhoni ekhethekile lapho amathuluzi omhleli wespredishithi atholakala khona. Imiyalelo enemininingwane yokusebenzisa amathuluzi akuribhoni ekhethekile yomhleli wespredishithi ibukeka kanje:

1. Ngokucindezela inkinobho yegundane engakwesokunxele, sikhetha ububanzi bamakholomu kuphaneli yokuxhumanisa. Udinga ukukhetha lawo maseli lapho amakholomu afihliwe atholakala khona.
2. Ungakhetha yonke indawo yokusebenza usebenzisa inhlanganisela ye-Ctrl + A.
3. Sidlulela esigatshaneni esithi "Ekhaya", sithola ibhulokhi ethi "Amaseli" lapho, bese uchofoza inkinobho yegundane kwesokunxele kokuthi "Fometha". Uhlu oluncane luvuliwe, lapho udinga ukukhetha into ethi "Fihla noma ubonise", etholakala ku-block "Ukubonakala". Ohlwini olulandelayo, khetha into ethi “Bonisa amakholomu” ngenkinobho yegundane kwesokunxele.

4. Ilungile! Amakholomu afihliwe ayavezwa futhi endaweni yokusebenza yesipredishithi.

Isiphetho neziphetho mayelana nokuvezwa kwamakholomu afihliwe kusihleli sespredishithi

Ukufihla amakholomu kuyisici esiwusizo esikuvumela ukuthi ufihle okwesikhashana ulwazi oluthile endaweni yokusebenza yedokhumenti yesipredishithi. Le nqubo ikuvumela ukuthi wenze idokhumenti yesipredishithi ibe lula futhi ikhululeke ukuyisebenzisa, ikakhulukazi ezimeni lapho idokhumenti iqukethe inani elikhulu lolwazi. Nokho, akuwona wonke umuntu owazi ukuthi isetshenziswa kanjani inqubo yokuveza amakholomu afihliwe kudokhumenti yesipredishithi. Sihlole ngokuningiliziwe izindlela ezintathu zokuqalisa ukuboniswa kwezinto ezifihliwe zendawo yokusebenza yedokhumenti yesipredishithi, ukuze umsebenzisi ngamunye azikhethele indlela ekahle kakhulu.