I-Microsoft Excel isofthiwe yesipredishithi evumela abasebenzisi ukuthi bahlele, bafomethe, futhi babale idatha ngamafomula besebenzisa uhlelo lwamaseli ahlukaniswe ngemigqa namakholomu.
Qonda umqondo wohlu lokudonsela phansi ku-Excel
Ngaphambi kokungena emininingwaneni yokuthi ulwakha kanjani uhlu lokudonsela phansi ku-Excel, okokuqala sidinga ukuqonda kahle ukuthi luyini uhlu olwehliswayo ku-Excel. Uhlu lokudonsela phansi, olwaziwa nangokuthi ibhokisi lokuhlola imenyu yokukhetha noma eyehlayo, isici se-Excel esivumela abasebenzisi ukuthi bakhethe inani ohlwini oluchazwe ngaphambilini.
Lokhu kuwusizo ezimweni eziningana. Isibonelo, uma ufaka idatha mathupha futhi kukhona amanani athile ajwayelekile futhi aphindaphindwa kaningi, ungakha uhlu oluya phansi lwalawo manani ukusheshisa inqubo yokufaka idatha.
Ilungiselela idatha yohlu lokudonsela phansi
Isinyathelo sokuqala sokwenza uhlu lokudonsela phansi ku-Excel ukulungisa idatha ofuna ivele ohlwini. Lolu hlu lungabandakanya noma yini evela kuhlu lwamagama, amadolobha, izinombolo, nanoma yini enye oyidingayo.
Nazi izinyathelo zokulungiselela idatha yohlu olwehliswayo:
- Vula i-Excel bese udala isipredishithi esisha noma usebenzise esikhona kakade.
- Kukholomu engenalutho noma umugqa, thayipha idatha ofuna ivele ohlwini lokudonsela phansi. Ukufakwa ngakunye kufanele kube kuseli elihlukile.
Ngemva kokufaka yonke idatha, ungayikhetha futhi uyinikeze igama ngebhokisi legama ekhoneni eliphezulu kwesokunxele.
Ukudala uhlu lokudonsela phansi
Uma usulungisile eyakho idatha futhi ubanike a inombolo, singakwazi ukuqala inqubo yokudala uhlu lokudonsela phansi:
- Khetha iseli lapho ofuna ukuba khona nohlu olwehliswayo.
- Chofoza kuthebhu 'Idatha' kubha yemenyu enkulu.
- Eqenjini elithi 'Amathuluzi Edatha', chofoza 'Ukuqinisekisa Idatha'.
Manje uzokwethulwa ngewindi 'lokuqinisekisa idatha' lapho ungamisa khona imithetho yeseli ekhethiwe.
Ilungiselela imithetho yokuqinisekisa idatha
Isinyathelo sokugcina sokwenza uhlu lokudonsela phansi ku-Excel ukulungisa imithetho yokuqinisekisa idatha:
- Ewindini elithi 'Ukuqinisekiswa Kwedatha', chofoza ithebhu 'Izilungiselelo'.
- Ngaphansi kwesihloko esithi 'Vumela', khetha u-'List' kokwehlayo.
- Enkambini ethi 'Origin', thayipha igama olinikeze idatha yakho bese uchofoza u-'KULUNGILE'.
Kuleli qophelo, kufanele ube ne-a uhlu olwehlayo luhamba phambili okubonisa idatha efakiwe. Ungayihlola ngokukhetha iseli olungise kulo uhlu lokudonsela phansi bese uchofoza umcibisholo.
Ukusebenzisa nokuguqula uhlu lwakho lokudonsela phansi
Ngohlu lwakho lokudonsela phansi oseluvele lwenziwe, ungalusebenzisa ngokumane ukhethe noma iyiphi iseli enohlu bese ukhetha okufakiwe. Ukuze ulungise uhlu noma uguqule idatha yokuqinisekisa, vele uphinde izinyathelo zangaphambilini.
Khumbula ukuthi uhlu lokudonsela phansi ku-Excel luyithuluzi lokonga isikhathi elenza ngcono ukusebenza kahle nokunemba kokufakwa kwedatha. Kuyikhono elibalulekile okufanele bonke abasebenzisi be-Excel balazi.
