Indlela Yokwakha / Susa uhlu lokudonsa phansi ku-Excel

Izinhla zokudonsa phansi noma amamenyu angadalwa ku-Excel ukukhawulela idatha engangena esitokisini esithile ohlwini lokufakwa ngaphambilini. Izinzuzo zokusebenzisa uhlu olwehlisiwe lokuqinisekiswa kwedatha zifaka:

• okwenza kube lula ukungena kwedatha;
• ukuvimbela amaphutha wokufaka idatha;
• ukukhawulela inombolo yezindawo zokufaka idatha.

Uhlu Nendawo Yedatha

Idatha eyongezwa ohlwini lokudonsa ingatholakala ku:

1. ikhasi elifanayo lomsebenzi njengoluhlu.
2. ekhasini lokusebenzela elihlukile kubhuku elifanayo le-Excel .
3. encwadini ehlukile ye-Excel.

Izinyathelo Zokudala Uhlu Lokudonsa

Izinyathelo ezisetshenziselwa ukwakha uhlu lokudonsa oluboniswe esitokisini B3 (izinhlobo zekhukhi) esithombeni ngenhla zingezansi:

1. Chofoza kuseli B3 ukuze wenze iseli esebenzayo ;
2. Chofoza kuthebhu yedata yedatha ;
3. Chofoza ku- Idatha yokuqinisekisa ukuze uvule imenyu yokudonsa yezinketho zokuqinisekisa;
4. Emenyu, chofoza ku- Idatha yokuqinisekisa ukuletha ibhokisi lemininingwane yokuqinisekisa yedatha;
5. Chofoza kuthebhu yezilungiselelo ebhokisini lengxoxo;
6. Chofoza ku- Vumela inketho ebhokisini lengxoxo ukuze uvule imenyu yokudonsa - inani elizenzakalelayo yinoma yiliphi inani;
7. Kule menyu, chofoza Uhlu ;
8. Chofoza emgqeni womthombo ebhokisini lengxoxo;
9. Gqamisa amaseli E3 - E10 kushidi lokusebenzela ukuze ungeze idatha kuloluhlu lwamaseli ohlwini;
10. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
11. Umcibisholo ophansi kufanele ube khona eduze kweseli B3 okubonisa ukuthi kukhona uhlu lokuhlaselwa;
12. Uma uchofoza umcibisholo uhlu oludonsa phansi luzovuleka ukuze lubonise amagama ayisishiyagalombili wekhukhi;

Qaphela: Umcibisholo ophansi okhombisa ukuba khona kohlu lokudonsa kubonakala kuphela uma lelo seli lenziwe iseli esebenzayo.

Susa uhlu lokudonsa phansi ku-Excel

Uma usuqedile uhlu olwehliswayo lungasuswa kalula kuseli leshidi lokusebenzela usebenzisa ibhokisi lebhokisi lokuqinisekisa idatha njengoba kuboniswe esithombeni ngenhla.

Qaphela : Uma uhambisa uhlu olwehlisiwe noma idatha yomthombo endaweni entsha ekhasini elifanayo lomsebenzi, ngokuvamile akudingekile ukususa nokudala kabusha uhlu lokudonsa njengoba i-Excel izovuselela ngokubanzi uhlu lwedatha olusetshenziselwa uhlu .

Ukususa uhlu lokudonsa phansi:

1. Chofoza kuseli eliqukethe uhlu lokudonsa olususwe;
2. Chofoza ithebhu yedata yedatha ;
3. Chofoza isithonjana sokuqinisekisa idatha ku-Ribbon ukuze uvule imenyu yokudonsa;
4. Chofoza inketho yokuqinisekiswa kwedatha kumenyu ukuze uvule ibhokisi lengxoxo ye-Data Validation;
5. Ebhokisini lengxoxo, chofoza kuthebhu yezilungiselelo - uma kunesidingo;
6. Chofoza inkinobho Ecacile Yonke ukuze ususe uhlu lokudonsa njengoba kuboniswe esithombeni ngenhla;
7. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela .

Uhlu olwehlisiwe olukhethiwe kufanele manje lususwe esitokisini esikhethiwe, kodwa noma iyiphi idatha efakwe eselini ngaphambi kokuthi uhlu lukhishwe luzohlala futhi luzosuswa ngokuhlukile.

Ukususa Uhlu Lwenqamula phansi kuHlelo Lokusebenza

Ukuze ususe zonke izinhla zokuhlaziya ezitholakala kufomu lokusebenzela elilodwa ngesikhathi esisodwa:

1. Yenza izinyathelo ezilodwa ukuya ezinhlanu kulezi zikhombisi ngenhla;
2. Hlola Faka isicelo lezi zinguquko kuwo wonke amanye amaseli anebhokisi lezilungiselelo ezifanayo kuthebhu yezilungiselelo zebhokisi lebhokisi;
3. Chofoza inkinobho Ecacile Yonke ukukhipha zonke izinhla zokudonsa phansi kwifomu lokusebenzela yamanje.
4. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.