Gadzira Drop Down List mune Excel Kubva Pamwe Pepa Rokushanda

Kugadzira doro pasi pasi muExcel kunokutumira kuisa data mune imwe sero rebasa rinobva pakurongwa kwepaketani yezvinyorwa.

Zvakanakira kushandisa gorosi-pasi rinosanganisira:

• Kuita kuti kuwanikwa kwepa data kuve nyore
• Kuchengetedza kukanganisa kwekutsvaga kwepa data
• Kuchengetedza nhamba yezvimbo dzekupinda dheta

Excel Drop-Down Rongedzo Nhanho Nhanho Dzidzo Misoro

• Kupinda Tutorial Data
• Kugadzira Zita Rakataridzirwa Dhiyabhorosi
• Kutanga Drop-Down List
• Kushandisa Kurongeka Kwekugadzirisa Dhiyabhorosi
• Kupinda Data Dhesi uye Kuzadza Drop-Down List
• Kuchinja Zvinhu Zvinyorwa
• Sarudzo dzekudzivirira Drop Down List

Kupinda Tutorial Data

Nhanho yekutanga yekusika dhesi pasi mu Excel ndeyokuisa data .

Cherechedza: Zvidzidzo zvekudzidzisa hazvirevi kutora matanho epa pepaji.

Izvi hazvizovhiringidzi nekupedzisa tutori. Tsamba yako yebasa ichaita yakasiyana nemuenzaniso uri papeji 1, asi urongwa hwekuderera huchakupa mhinduro imwe chete.

Isa data iri pasi apa mumasero anoratidzwa pamashizha imwe uye mbiri yebhuku reExpcel.

Tutorial Steps

1. Isa data inotevera pane yakakodzera masero paSheti 1 yebhishopu: D1 - Cheokie Type:
2. Dzvanya paSheet tab yeSheeteri 2.
   
3. Isa data inotevera mumakamuri akakodzera paSheet 2 yebasa rekushanda:
   A1 - Gingerbread A2 - Aimu A3 - Oatmeal Mukurumbira A4 - Chocolate Chip

Dhesi rezasi richawedzerwa kune cell E1 pane peji 1.

Kugadzira Zita Rakataridzirwa Dhepfenyuro Dhepfenyuro

Zita rakatumidzwa rinokubvumira kuti utaure kune rimwe rutivi rwemasero mubhuku reku Excel.

Zita rakatumidzwa rine zvakawanda zvinoshandiswa muExcel kusanganisira kuzvishandura mumashonga uye pakuumba marati.

Muzviitiko zvose, zita rakarongedzwa rinoshandiswa panzvimbo yenzvimbo dzakasiyana-siyana dzezviratidzo zvinoratidza nzvimbo ye data mune pepa rekushanda.

Kana yakashandiswa muburusi pasi, urongwa hunozivikanwa runoshandiswa sechikonzero chezvinhu zvakanyorwa.

Tutorial Steps

1. Dragodza masero A1 - A4 pane Sheet 2.
2. Dzvanya paZita reBhokisi riri pamusoro pe column A
3. Nyora "cookies" (hapana zvinyorwa) muZita reBhokisi
4. Dhinda iri ENTER kiyi pane keyboard
5. Masero A1 kusvika kuA4 pane peji 2 iye zvino ane zita re "range"
6. Chengetedza shandi yako yebasa

Kuvhura Dhigiriro reDatai Bhokisi reDhialog

Zvose zvinoshandiswa pakugadzirisa dhidhiyo muExcel, kusanganisira kudonhora pasi, zvinoshandiswa uchishandisa dhiyabvumirano yebhokisi rebhokisi.

Dhiyabvumirano yekugadzirisa dialog box iri pasi pe data data yebhoni .

Tutorial Steps

1. Dzvanya paSheet 1 tab pasi pekona kuti uende kune peji 1
2. Dzvanyira pa cell E1 kuti iite iyo inoshandiswa seyero - iyi ndiyo iyo rondedzere runyoro ruchawanikwa
3. Dzvanya paData Dhauriro yemadhoni yemenyu pane pepa pepaji
4. Dzvanya paDhiyabvumirano yeDhiyabvumirano paDabhoni kuti uzarure mhando yekunyorera
5. Dzvanya paIndesheni Yokugadzirisa Dhiyabhorosi mu menyu kuti uzarure Dhiyabvumirano reDhiyabvumirano reDhiyabhorosi

Kushandisa Kurongeka Kwekugadzirisa Dhiyabhorosi

Mukuwedzera kune kuwedzera kudonha pasi kune mapepa ekushandura, kushandiswa kwemashoko kuExcel kunogonawo kushandiswa kudzora kana kugadzirisa rudzi rwe data runogona kupinda mune mamwe masero .

Zvimwe zvezvinhu zvinowanzoshandiswa:

• Rondedzera
• Mazuva uye / kana nguva
• Nhamba dzose
• Text
• Zvinyorwa (shandisa pasi peChirongwa chekodzero)

Mutsara uyu, tichasarudza sarudzo yeChirangaridzo sezvo rudzi rwekugadzirisa dhesizo kushandiswa se cell E1 pane peji 1.

Matanho

1. Dzvanya pane Zvirongwa tab mubhokisi rebhokisi
2. Dzvanya pamusana weveve museve kumucheto weAllin line kuti uzarure mhando yekunyorera
3. Dzvanya paZvitsa kuti uone dhesi pasi rekugadzirisa deta muchitokisi D1 uye kushandura Mutsara weNowanzo mubhokisi rebhokisi

Kupinda Data Dhesi uye Kuzadza Drop Down List

Sezvo deta inowanikwa pasi pezita iri iri pane rimwe pepaji rekushandura, iro rakanzi zita rakagadzirwa rakapfuura richapinda muIndaneti mubhokisi rebhokisi .

Matanho

1. Dzvanya paIndaneti
2. Tora "= cookies" (hapana zvinyorwa) muIndaneti
3. Dzvanya OK kuti upedze rondedzero uye uvhare Dhiyabvumirano yeDhiyabhorosi yebhokisi
4. Chinhu chiduku chine museve chinowanikwa kuruboshwe rwema cell E1
5. Kushandura museve pasi unofanirwa kuzarura rondedzero yezvinyorwa zvine mazita mana ekiki akapinda mumasero A1 kusvika kuA4 pane peji 2
6. Kushanda pane rimwe remazita rinofanira kupinda iyo zita muchitokisi E1

Kugadzirisa Izvo Zvinyorwa Zvinhu

Kuti uchengetedze rutsoka pasi kusvika pakuchinja mune data yako, zvingave zvakadikanwa kuti nguva nenguva uchinje kusarudzwa mune urongwa.

Kubva patakashandisa mazita akanzi shanduko yezvinhu zvatakanyora pane pane mazita mazita, kuchinja mazita ekoki muzita rakarongeka riri mumasero A1 kusvika kuA4 pane peji 2 rinokurumidza kushandura mazita muburusa rezasi.

Kana iyo data yakapinda zvakananga mubhokisi rebhokisi, kuita shanduko kune urongwa kunosanganisira kudzokera zvakare mubhokisi rebhokisi uye shandura mutsara wezvino.

Mutsara uyu, tichachinja Shortbread kusvika kuOatmeal Raisin mumusika wekuderedza nekunyora deta iri muchikamu cheA3 cheiyo inonzi yakarongwa.

Matanho

1. Dzvanya pachitokisi A3 pane peji 2 (Shortbread) kuti uite sero rinoshanda
2. Tora Oatmeal Raisin muchitsauko A3 uye tapindura muIndaniti paikhibhodi
3. Dzvanya pasi pasi pemuseve wekuburutsa pasi pane imwe nzvimbo E1 yemashizha 1 kuti uzarure urongwa
4. Chinyorwa 3 mune urongwa chinofanira kuverenga zvino Oatmeal Raisin pane Shortbread

Sarudzo dzekudzivirira Drop Down List

Sezvo data yedu iri pane rimwe pepaji rakasiyana rinobva pasi rezasi pane zvinyorwa zviviri zviripo zvekudzivirira dheta deta ndei:

• Vigira pepa repaji rine data (peji 2)
• Chengetedza pepa rekushanda rinobatanidza kuvhara masero A1 kusvika kuA4 pane peji 2

Kana kuchengeteka kusingakanganisi, kuvanza pepa rebhuku rine rine rondedzero yezvido ndiyo nzira yakanaka sezvo inoita kuti zvive nyore kuvandudza runyoro kana zvichidiwa.

Kana kuchengeteka kuri kunetseka kwepa password kunogona kuwedzerwa pakudzivirira pepa rekudzivirira kudzivirira kuchinja kune zvinyorwa zvinhu.

Kuumba Drop Down List pane Rimwe Rakashanda Pepa

A drop down list inokubvumira kuti uise dhamusi muExpcel spreadsheet kubva pane zvakatangira mahedheni.

Chikamu 1 chinoshandisa matanho ekugadzira dhesi rakanyora nedheta pane imwechete peji seyoronyora pasi.

Iyi tutori inosanganisira kugadzira dhesi pasi pane rimwe bhuku rakasiyana.

Muenzaniso: Kuumba dhesi pasi urongwa nemashoko pane rimwe pepa pepaji

Isa data inotevera pane yakakodzera masero paSheti 1 yepajiro remabasa:
E1 - The Cookie Shop
D2 - Cookie Type:
Dzvanya paSheet tab yeSheeteri 2.
Isa data inotevera pane yakakodzera masero paSheet 2 kana pepa rekushanda:
A1 - Gingerbread
A2 - murairo
A3 - Oatmeal Raisin
A4 - Chocolate Chip
Simbisai masero A1 - A4 pane Sheet 2.
Tora "cookies" (hapana zvinyorwa) muZita reBhokisi uye pinda muIndaniti pabhodi.
Dzvanya paTabheti yeTepa yeSheti 1
Dzvanya pane cell E2 - nzvimbo iyo migumisiro icharatidzwa
Dzvanya paData Data tab
Dzvanya paKutsvaga Kwekugadzirisa Data kubva kubhoni kuti uzarure menyu
Dzvanya paVhidhiyo Dhiyabhorosi mumenyu kuti uuye nebhokisi rebhokisi
Dzvanya pane Zvirongwa tab mubhokisi rebhokisi
Kubva Kubvumira menyu sarudza Zita
Tora = cookies paNowanzo mubhokisi rebhokisi
Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
Miseve iri pasi inofanira kuonekwa pedyo nechitokisi E2
Paunonyanya kuvhara museve inodonhedzwa inofanira kuzarura kuti ione mazita mana ekiki