Indlela yokudala / Ukukhupha uluhlu lokuLahla phantsi kwi-Excel

Izintlu zokungena phantsi okanye amamenyu angadalwa kwi-Excel ukukhawulela idatha engangeniswa kwisisele esithile kwisithuba esilungisiweyo sokungena. Iintlobo zokusebenzisa uluhlu lokuhlahlayo ukuqinisekiswa kwedatha ziquka:

• ukwenza lula ukungena kwedatha;
• ukuthintela iziphoso zokungena kwedatha;
• ukukhawulela inani leendawo zokufaka idatha.

Uluhlu kunye neeNdawo zoLwazi

Idatha eyongezwa kwoluhlu lokuhla-mali lungafumaneka kwi:

1. kwiphepha elifanayo lomsebenzi njengoluhlu.
2. kwiphepha elisebenzayo leencwadi kwiincwadi ezifanayo ze-Excel .
3. kwincwadi eyahlukeneyo ye-Excel.

Amanyathelo okudala uLuhlu lokuLahla

Amanyathelo asetyenziswayo ukwakha uluhlu lokuhlahlayo luboniswe kwiseli B3 (iintlobo zekhukhi) kumfanekiso ongentla apha:

1. Cofa kwifowuni B3 ukwenza iseli esebenzayo ;
2. Cofa kwiTebhu yedatha yedrbhoni ;
3. Cofa kwiNgcaciso yeDatha ukuvula imenyu ehlayo yokukhetha;
4. Kwimenyu, nqakraza ukuqinisekiswa kweDatha ukukhupha ibhokisi yencoko yokubambisa iData;
5. Cofa kwiZetyu zoLungiselelo kwibhokisi yencoko;
6. Cofa kwi- Vumela inketho kwibhokisi yencoko yababini ukuvula imenyu ehlayo-xabiso elizenzekelayo nayiphi na ixabiso;
7. Kule menu, nqakraza uludwe ;
8. Cofa kuMgca woMthombo kwibhokisi yencoko;
9. Gqamisa iiseli E3-E10 kwiphepha lokusebenzela ukuze ungeze idatha kuloluhlu lweeseli kuluhlu;
10. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela;
11. Umcolo ophantsi kufuneka ube khona ecaleni kweseli B3 ebonisa ubukho belohlu lokuhlahla;
12. Xa ucofa kwitolo, uluhlu lokuhlahla luya kuvula ukubonisa amagama anesibhozo ze-cookie;

Qaphela: Utolo oluphantsi olubonisa ukuba kukho uluhlu lokuhlahla luyabonakala kuphela xa iseli lenziwe iseli esebenzayo.

Susa uLuhlu lokuLawula phantsi kwi-Excel

Emva kokugqiba uludwe oluhla-phantsi ungasuswa kalula kwisitoreji somsebenzi usebenzisa ibhokisi yencoko yokubambisa idatha njengoko kuboniswe kumfanekiso ongentla.

Qaphela : Ukuba uhambisa uluhlu oluhla-phantsi okanye idatha yendalo kwindawo entsha kwiphepha elifanayo, akusoloko kuyimfuneko ukucima nokudala kwakhona uluhlu lokuhlahlaya njengoko i-Excel iya kuhlaziya ngokutsha uluhlu lweenkcukacha ezisetyenziselwa uluhlu .

Ukususa uluhlu lokuhlahla:

1. Cofa kwieseli equlethe uluhlu lokuhlahlahlayo oluya kususwa;
2. Cofa kwiTebhu yedatha yedbhoni ;
3. Cofa kwi-icon yokuqinisekisa iDatha kwi-Ribbon ukuvula imenyu yokuhlahla;
4. Cofa uVimba lokuQinisekiswa kweDatha kwimenyu ukuvula ibhokisi yencoko yoQinisekiso lweDatha;
5. Kwibhokisi yencoko, nqakraza kwiTebhsti zeSetingi - ukuba kuyimfuneko;
6. Cofa iqhosha lonke Cima yonke into ukususa uluhlu lokuhlahlaya njengoko kuboniswe kumfanekiso ongentla;
7. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela .

Uluhlu olukhethiweyo olukhethiweyo kufuneka lukhutshwe kwikhefu ekhethiweyo, kodwa nayiphi na idatha efakwe kwiseli phambi kokuba uluhlu lukhutshwe luya kuhlala kwaye lumele lucatshulwe ngokwahlukileyo.

Ukucima yonke i-Drop Down List kwi-Worksheet

Ukususa zonke uluhlu lokuhlahlela olufumaneka kwiphepha elifanayo lomsebenzi ngexesha elinye:

1. Yenza amanyathelo ukuya kweyesihlanu kwimiyalelo engentla;
2. Khangela Faka isicelo solu tshintsho kuzo zonke iiseli ezinebhokisi yesethingi esifanayo kwisithuba seTebhokisi kwibhokisi yencoko;
3. Cofa kwiComputer All Clear ukususa zonke izintlu ezantsi phantsi kwiphepha lokusebenzela.
4. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.