Ngokuhamba kwesikhathi, ibhuku lakho le-Excel linemigqa eminingi yedatha eba nzima nakakhulu ukusebenza ngayo. Ngakho-ke, kunesidingo esiphuthumayo sokufihla eminye yemigqa egcwalisiwe bese ukhulula ishidi lokusebenza. Imigqa efihliwe ku-Excel ayihlanganisi ishidi ngolwazi olungadingekile futhi ngesikhathi esifanayo iqhaza kuzo zonke izibalo. Kulesi sifundo, uzofunda ukuthi ungafihla kanjani futhi ubonise imigqa namakholomu afihliwe, kanye nokuwahambisa uma kunesidingo.
Hambisa imigqa namakholomu ku-Excel
Kwesinye isikhathi kuba kudingekile ukuhambisa ikholomu noma umugqa ukuhlela kabusha ishidi. Esibonelweni esilandelayo, sizofunda indlela yokuhambisa ikholomu, kodwa ungakwazi ukuhambisa umugqa ngendlela efanayo.
- Khetha ikholomu ofuna ukuyihambisa ngokuchofoza unhlokweni wayo. Bese ucindezela umyalo othi Sika kuthebhu ethi Ikhaya noma isinqamuleli sekhibhodi u-Ctrl+X.
- Khetha ikholomu kwesokudla sephoyinti lokufaka elihlosiwe. Isibonelo, uma ufuna ukubeka ikholomu entantayo phakathi kwamakholomu B no-C, khetha ikholomu C.
- Kuthebhu ethi Ikhaya, kumenyu yokudonsela phansi yomyalo othi Namathisela, khetha Namathisela Amaseli Okusika.
- Ikholomu izohanjiswa endaweni ekhethiwe.
Ungasebenzisa imiyalo ethi Sika futhi Namathisela ngokuchofoza kwesokudla nokukhetha imiyalo edingekayo kumenyu yokuqukethwe.
Ifihla imigqa namakholomu ku-Excel
Ngezinye izikhathi kuba nesidingo ukufihla imigqa noma amakholomu athile, isibonelo, ukuwaqhathanisa uma aqhelelene nomunye. I-Excel ikuvumela ukuthi ufihle imigqa namakholomu njengoba kudingeka. Esibonelweni esilandelayo, sizofihla amakholomu C no-D ukuze siqhathanise u-A, B no-E. Ungakwazi ukufihla imigqa ngendlela efanayo.
- Khetha amakholomu ofuna ukuwafihla. Bese uchofoza kwesokudla ebangeni elikhethiwe bese ukhetha okuthi Fihla kumenyu yokuqukethwe.
- Amakholomu akhethiwe azofihlwa. Umugqa oluhlaza ubonisa indawo yamakholomu afihliwe.
- Ukuze ubonise amakholomu afihliwe, khetha amakholomu kwesokunxele nakwesokudla kwalawo afihliwe (ngamanye amazwi, nhlangothi zombili zalawo afihliwe). Esibonelweni sethu, lawa amakholomu B no-E.
- Chofoza kwesokudla ebangeni elikhethiwe, bese ukhetha okuthi Bonisa kumenyu yokuqukethwe. Amakholomu afihliwe azophinde avele esikrinini.