Indlela yokudala uluhlu lweDrop Down kwi-Excel

Izinketho zokuqinisekiswa kwedatha ye-Excel ziquka ukudala uluhlu oluphahlayo olukhawulela idatha engangeniswa kwisisele esithile kwisicwangciso sokuqala sokufakwa kwamangenelo.

Xa uluhlu lwehla-phantsi lufakwa kwiseli, umcibisholo uboniswa eceleni kwayo. Ucofa kwitolo uzakuvula uluhlu uze uvumele ukuba ukhethe enye yezinto eziluhlu ukungena kwiseli.

Idatha esetyenziswe kwoluhlu ingafumaneka:

• kwiphepha elifanayo lomsebenzi njengoluhlu
• kwiphepha elisebenzayo leencwadi kwiincwadi ezifanayo
• kwincwadi eyahlukileyo

I-Tutorial: Ukusebenzisa iDatha egcinwe kwiNcwadi eSebenzi eyahlukileyo

Kule tutorial, siza kudala uluhlu lokuhla-lwahlula usebenzisa uluhlu lwezinto ezifakwe kwiincwadi ezahlukeneyo.

Inzuzo yokusebenzisa uluhlu lwezinto ezifakwe kwiincwadi ezahlukeneyo zibandakanya ukupakisha idatha yoluhlu xa isetyenziswe ngabasebenzisi abaninzi kwaye ikhusela idatha ukusuka ekutshintshweni ngengozi okanye ngokuzikhethela.

Qaphela: Xa uludwe lweenkcukacha lugcinwe kwincwadi yokusebenzela eyahlukileyo zombini iincwadi zokusebenzela mazivulekele ukuze uludwe lusebenze.

Ukulandela amanyathelo kwimixholo yokufundisa engezantsi kukuhamba ngokudala, ukusebenzisa, nokutshintsha uluhlu lokuhlahlela olufana nomboniso ongentla.

Le miyalelo yokufundisa, nangona kunjalo, akubandakanyi amanyathelo okufomatha amaphepha.

Oku akuyi kuphazamisana nokugqiba uqeqesho. Iphepha lakho lomsebenzi liya kubonakala lihlukile kunomzekelo kwiphepha 1, kodwa uluhlu lokuhlahla luya kukunika imiphumela efanayo.

Izihloko zeTutorial

• Ukuvula iiFayile kunye nokuLondoloza idatha yeTutorial
• Ukudala iiRanges ezimbini
• Ukuvula iBhokisi yoLwazi lweNgcaciso yeDatha
• Ukufaka uMthombo weDatha nokugqiba uLuhlu lokuLahla
• Ukutshintsha izinto zoLuhlu
• Izinketho zokuKhusela uLuhlu lokuLahla

01 ngo-06

Ukufaka i-Tutorial Data

Ukuvula iiWindows Work Excel

Njengoko kubonisiwe, kule tutorial idatha yohlu lwehla-phantsi iya kufumaneka kwincwadi yokusebenzela eyahlukileyo ukusuka kuluhlu lokuhlahla.

Kule khokelo landela la manyathelo:

1. Vula ezimbini zeencwadi zokusebenzela ze-Excel
2. Gcina enye incwadi yokusebenzela enegama- data-source.xlsx- le ncwadi ibandakanya iinkcukacha zoluhlu lokuhlahla
3. Gcina incwadi yesibini kunye negama lokuhla-down-list.xlsx - le ncwadi ibandakanya uluhlu lokuhlahla
4. Shiya zombini iincwadi zokusebenzela emva kokulondoloza.

Ukufaka i-Tutorial Data

1. Faka idatha engezantsi kwiiseli ezi-A1 ukuya kwi-A4 kwincwadi yokusebenzela yedatha-source.xlsx njengoko kuboniswe kumfanekiso ongentla.
2. I-A1 - I-Gingerbread A2 - i-Lemon A3 - i-Oatmeal Raisin A4 - i-Chocolate Chip
3. Gcina ibhuku kwaye uyishiye evulekile
4. Faka idatha engezantsi kwiiseli B1 kwincwadi yokusebenzela yehla-down-list.xlsx .
5. B1 - Uhlobo lwe Cookie:
6. Gcina ibhuku kwaye uyishiye evulekile
7. Uluhlu lokuhlahla luya kudibaniswa kwiseli C1 yale ncwadi yokusebenzela

02 we-06

Ukudala iiRanges ezimbini

Ukudala iiRanges ezimbini

Uluhlu olukhethiweyo lukuvumela ukuba ubhekisele kwiqela elithile leeseli kwiincwadi ze-Excel.

Amanqanaba anegama aninzi asetyenziswayo kwi-Excel kuquka ukuwasebenzisa kwiifomula nakwindlela yokudala amashadi.

Kuzo zonke iimeko, uluhlu olukhankanyiweyo lusetyenziselwa endaweni yeendidi ezibhekiselele kubonisa indawo yendawo kwiphepha lokusebenzela.

Xa lisetyenziswe kwinqwelo lokuhlahla elisezantsi kwincwadi yomsebenzi, iindawo ezimbini ezichongiweyo kufuneka zisetyenziswe.

• Omnye udalwe kwizinto eziluhlu kwincwadi yokusebenzela apho idatha ikhona khona
• Iyesibini yenziwe kwincwadi yokusebenzela apho uluhlu lokuhlahla lukhona. Olu hlobo lwesibini lubizwa ngokuba luhlu olubhekiselele kwibanga elikhankanyiweyo kwincwadi yokuqala yokusebenzela

Iimfundiso zeTutorial

Uhlobo lo kuqala

1. Khetha iiseli A1 - A4 yencwadi yokusebenzela yedatha-source.xlsx ukuyibala
2. Cofa kwiBhokisi legama elisezantsi kwekholam A
3. Thayipha "ikhukhi" (akukho zicaphulo) kwiBhokisi legama
4. Cinezela i- ENTER iqhosha kwikhibhodi
5. Iiselingi A1 ukuya ku-A4 yencwadi yedatha-source.xlsx ngoku inegama lomgama weCokuki
6. Gcina incwadi yo msebenzi

Uhlobo lwe sibini

Olu hlobo lwesibini olubizwa ngokuba lusetyenziso lusetyenziso lweefestile kwi-work-down-list.xlsx .

Kunoko, kuya kuthi, njengoko kuchaziwe, qhagamshelana negama legama le -cookies kwincwadi yokusebenzela yedatha-source.xlsx .

Oku kuyimfuneko kuba i-Excel ayiyi kwamkeli iiferensi zeeselfowuni ukusuka kwincwadi eyahlukileyo yebala elinegama. Kodwa, ngaphandle koko, ngaphandle kwelinye igama legama.

Ukudala uluhlu lwesibini olukhankanyiweyo, ngoko ke, alukwenziwanga usebenzisa iBhokisi legama kodwa ngokusebenzisa iCandelo loMphathi wegama elikhoyo kwiThebhu yefomula yerbhoni.

1. Cofa kwifowuni C1 kwincwadi yokusebenzela yehla-down-list.xlsx
2. Cofa kwiifomula> Umphathi wegama kwi-Ribbon ukuvula ibhokisi yencoko yencoko yegama
3. Cofa kwiqhosha elitsha ukuvula ibhokisi yencoko yegama elitsha
4. Kwigama lomgca wegama: Iinkcukacha
5. Kulo mzekelo Uhlobo lomgca: = 'idatha-source.xlsx'! Ikhukhi
6. Cofa u-OK ugcwalise uluhlu olukhethiweyo kwaye ubuyele kwibhokisi yencoko yencoko yegama
7. Cofa Vala ukuze uvale ibhokisi yencoko yencoko yegama
8. Gcina incwadi yo msebenzi

03 we-06

Ukuvula iBhokisi yoLwazi lweNgcaciso yeDatha

Ukuvula iBhokisi yoLwazi lweNgcaciso yeDatha

Zonke iinketho zokuqinisekiswa kwedatha kwi-Excel, kubandakanywa uluhlu lokuhlalisa, lubekwe kusetyenziswa ibhokisi yencoko yebhokisi yencoko.

Ukongezelela ukongeza uluhlu lwezintlu kwi-worksheet, ukuqinisekiswa kwedatha kwi-Excel kungasetyenziselwa ukulawula okanye ukunciphisa uhlobo lweedatha ezingeniswa kwiiseli ezithile kwiphepha lokusebenzela.

Iimfundiso zeTutorial

1. Cofa kwifowuni C1 yencwadi yokuhlahla-uluhlu.xlsx ukwenza i- cell esebenzayo -yilapho uluhlu lokuhlahla luya kubakho
2. Cofa kwiTebhu yedata ye menu yebhondi ngaphezulu kwiphepha lokusebenzela
3. Cofa kwi icon ye- Data Validation kwi-Ribbon ukuvula imenyu ehlayo
4. Cofa kwiKhowudi yokuQiniseka kweDatha kwimenyu ukuvula ibhokisi yencoko yababini yokuqinisekisa
5. Shiya ibhokisi yencoko evulekileyo kwisinyathelo esilandelayo kwisifundo

04 we-06

Ukusebenzisa uLuhlu lokuVunywa kweDatha

Ukukhetha Uluhlu lweNgcaciso yeDatha

Njengoko kuthethwe kukho kukho inani leenketho zokuqinisekiswa kwedatha kwi-Excel ukongeza kwoluhlu lokuhlahla.

Kulo nyathelo siya kukhetha ukhetho lwoluhlu njengoko uhlobo lokuqinisekiswa kwedatha oluya kusetyenziswa iseli D1 kwiphepha lokusebenzela.

Iimfundiso zeTutorial

1. Cofa kwiZetyuli zebhokisi kwibhokisi yencoko
2. Cofa kwitolo elihlayo ekupheleni komgca wokuvumela ukuvula imenyu ehlayo
3. Cofa kuluhlu ukhetha uluhlu lokuhla kweedatha ukuqinisekiswa kwiseli C1 kwaye usebenzise umgca woMthombo kwibhokisi yencoko

Ukufaka uMthombo weDatha nokugqiba uLuhlu lokuLahla

Ekubeni umthombo wedatha lohlu lokuhlahla lufumaneka kwincwadi yokusebenzela eyahlukileyo, udidi lwesibini oluthiwa igama elidalwe ngaphaya luya kufakwa kuMgca woMthombo kwibhokisi yencoko.

Iimfundiso zeTutorial

1. Cofa kuMgca woMthombo
2. Uhlobo "= Idata" (akukho zicaphulo) kuMgca woMthombo
3. Cofa Kulungile ukuqedela uluhlu lokuhlalisa kwaye uvale ibhokisi yencoko yoqinisekiso yokuDatha
4. Icandelo elincinci lokucima ibhokisi elisezantsi kwicala C1
5. Ucofa kwitolo eliphantsi kufuneka livule uluhlu lokuhlahla oluqulethwe ngamagama amane ecookie angena kwiiseli A1 ukuya ku-A4 ye- data-source.xlsx
6. Ukuqakraza kwelinye lamagama kufuneka ufake elo gama kwiseli C1

05 ka 06

Ukutshintsha uLuhlu lokuLahla

Ukutshintsha izinto zoLuhlu

Ukugcina uluhlu lokuhla kwexesha ukuza kutshintsha kunye neenguqu kwi data yethu, kunokufuneka ukuba uguqule ngokukhawuleza ukhetho oluluhlu.

Ekubeni sasebenzisa uluhlu olukhankanywe njengoluhlobo lwezinto zethu zohlulo kunokuba luhlu lwamagama ahlukileyo, ukuguqula amagama ekhukhi kwibala elikhankanyiweyo elikhoyo kwiiseli A1 ukuya kwi-A4 yencwadi yedatha-source.xlsx ngokukhawuleza utshintshe amagama ekuhla uludwe.

Ukuba idatha ingeniswa ngqo kwibhokisi yencoko, ukwenza utshintsho kuloluhlu kubandakanya ukubuyela kwibhokisi yencoko kwaye uhlele umthombo wendawo.

Kule nyathelo siya kutshintsha iLim kwi -Shortbread kwoluhlu lokuhlahla ngokutshintsha idatha kwiseli A2 yoluhlu olukhankanyiweyo kwincwadi yokusebenzela yedatha-source.xlsx .

Iimfundiso zeTutorial

1. Cofa kwi-cell A2 kwincwadi yokusebenzela yedatha-source.xlsx (iLimu) ukwenzela ukuba ibe yiseli esebenzayo
2. Thayipha i- shortbread ibe yiseli ye-A2 kwaye ucinezela ukhiye wokungena kwikhibhodi
3. Cofa kwitolo lokuhla kwelohlwayo phantsi kweseli C1 yencwadi yokulahla-list.xlsx ukuvula uluhlu
4. Inqaku 2 kuluhlu kufuneka ngoku ngokufunda i- shortbread endaweni yeLim

06 we-06

Izinketho zokuKhusela uLuhlu lokuLahla

Izinketho zokuKhusela uLuhlu lokuLahla

Ekubeni idatha yethu isebenza kwiphepha elihlukileyo lomsebenzi ukusuka kwiindlela ezikhethiweyo zoluhlu olufumanekayo ekukhuseleni uluhlu lweenkcukacha zibandakanya:

• Khusela iphepha lokusebenzela elibandakanya ukuvalela iiseli A1 ukuya ku-A4 kwiphepha 2
• Ukufuna iphasiwedi ukuguqula incwadi yokusebenzela
• Ukuba nencwadi yokuvula ivuliwe njenge- Read-only