Nzira Yokugadzira Drop Down List mune Excel

Zvimwe zvinoshandiswa neCexcel zvekugadzirisa dambudziko zvinosanganisira kusika dhesi-rezasi runoshandura iyo inogadzirisa dheinhe inogona kupinda mune imwe sero kune imwe yekutanga yekuisa mazita.

Apo dhesi-pasi rwandu inowedzerwa kune kero, museve unoratidzwa pedyo nayo. Kushandura mumuseve kuchazarura urongwa uye kukubvumira kusarudza chimwe chezvinhu zvinongororwa kuti upinde muchitokisi.

Dhiyabhorosi inoshandiswa mumutsara inogona kuwanikwa:

• pahwheji rimwechete seyorongwa
• pane rimwe bhuku rakashandurwa mubhuku rimwechete rebhuku
• mune rimwe bhuku rebhuku

Tutori: Kushandisa Data Yakachengetwa Mubhuku Rakawanda Rokushanda

Muchidzidzo ichi, tichaita dhiriri-pasi uchishandisa urongwa hwezvinyorwa zviri mune rimwe bhuku rebhuku.

Kubatsirwa kwekushandisa urongwa hwezvinyorwa zviri mune rimwe bhuku rinobatanidza kushandiswa kwekutsvaga ruzivo rwemashoko kana runoshandiswa nevashandisi vakawanda nekuchengetedza dhiyabhorosi kubva pangozi kana kushanduka nemaune.

Cherechedza: Apo dheta deta iri kuchengetwa mubhuku rebhuku rakasiyana mabhuku ose ebasa anofanira kunge akazaruka kuitira kuti runyora rushande.

Kutevera matanho ari mumusoro wekudzidzisa mazano ari pasi apa anokufambisa kuburikidza nekusika, kushandisa, uye kuchinja urongwa hwekuderera pasi hwakafanana neyaona mumufananidzo pamusoro apa.

Izvi zvidzidzo mirayiridzo, zvisinei, hazvirevi maitiro ekufambisa mapeji emabasa.

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

Zvidzidzo Misoro

• Kuvhura Files nekuchengetedza Tutorial Data
• Kuumba mazita maviri anonzi Ranges
• Kuvhura Dhigiriro reDatai Bhokisi reDhialog
• Kupinda Data Dhesi uye Kuzadza Drop Down List
• Kuchinja Zvinhu Zvinyorwa
• Sarudzo dzekudzivirira Drop Down List

01 of 06

Kupinda Tutorial Data

Kuvhura Two Excel Workbook mabhuku

Sezvakataurwa, nokuda kwekudzidzisa iyi dheta rekuderedza pasi ruchave riri mune rimwe bhuku rebhuku kubva pakaderera pasi.

Nokuti izvi zvidzidzo zvinotevera matanho aya:

1. Vhura mabhuku maviri eExpcel asina mabhuku
2. Chengeta bhuku rimwe rebhuku rine zita -source.xlsx - bhuku rino rekushandisa richava nemashoko ekuderedza pasi
3. Chengetedza bhuku rechipiri rine zita re -drop-down-list.xlsx - bhuku rino rekushandisa richava nehotera-pasi
4. Siya mabhuku ose ebasa akazaruka mushure mekuponesa.

Kupinda Tutorial Data

1. Isa data iri pasi apa mumasero A1 kusvika kuA4 yebhuku re data-source.xlsx sezvinoonekwa mumufananidzo uri pamusoro.
2. A1 - Gingerbread A2 - Aimu A3 - Oatmeal Mukurumbira A4 - Chocolate Chip
3. Chengetedza bhuku rebhuku uye rinosiya rakazaruka
4. Isa data iri pasi apa mumasero B1 ebhuku rezasi-list.xlsx .
5. B1 - Cockie Type:
6. Chengetedza bhuku rebhuku uye rinosiya rakazaruka
7. Dhesi yezasi inonyorwa ichawedzerwa kune cell C1 yebhuku rino rekushandisa

02 of 06

Kuumba mazita maviri anonzi Ranges

Kuumba mazita maviri anonzi Ranges

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 ikashandiswa muburusa pasi rakanyorwa mubhuku rebhuku rakasiyana, mazita maviri akafanirwa anofanira kushandiswa.

• Imwe yakasikwa yezvinhu zvakanyora mubhuku rebhuku apo data iripo
• Chechipiri yakasikwa mubhuku rebhuku apo dhesi rakanyorwa riripo. Iyi yechipiri inonzi mazita akabatanidzwa kune iyo inonzi yakarongwa mubhuku rekutanga rebhuku

Tutorial Steps

Chokutanga Chinonzi Range

1. Sarudza masero A1 - A4 yebhuku -data-source.xlsx bhuku rekuita kuti rionekwe
2. Dzvanya paZita reBhokisi riri pamusoro pe column A
3. Tora "Cookies" (hapana zvinyorwa) muZita reBhokisi
4. Dhinda iri ENTER kiyi pane keyboard
5. Masero A1 kusvika kuA4 yebhuku re data-source.xlsx iye zvino ane zita rekutakura rekiki
6. Chengetedza bhuku rebhuku

Yechipiri inonzi Range

Uyu wechipiri anonzi range haashandisi zvinyorwa zvinyorwa kubva mubhuku rekuburusa-list.xlsx .

Pane kudaro, iyo ichaita, sezvinotaurwa, inonanidza neCookies zita rezita mubhuku rebhuku re data-source.xlsx .

Izvi zvinodikanwa nokuti Excel haigamuchiri zvinyorwa zvemasero kubva kune rimwe bhuku rebhuku rezita rakarongwa. Izvozvo, zvisinei, kunze kweimwe zita rezita.

Kuumba yechipiri inonzi zita rakakosha, saka, haisi kuitwa uchishandisa Bhokisi Razita asi nekushandisa Zita Mutungamiri sarudzo iri pane Formulas tab yebhoni.

1. Dzvanya pane cell C1 mubhuku rekuburusa-list-list.xlsx
2. Dzvanya pane Formmulas> Mutariri wezita pajibhoni kuti uzarure Mutungamiri Wezita rebhokisi rebhokisi
3. Dzvanya kuNew bouton kuti uzarure Zita Rokutanga rebhokisi
4. MuZita Rudzi rwemhando: Data
5. Muchirevo chekutsvaga mutsara wenyaya : = 'data-source.xlsx'! Cookies
6. Dzvanya OK kuti upedze mazita awakatarisa uye dzokera kuMutungamiri Wezita rebhokisi rebhokisi
7. Dzvanya Pedyo kuti uvhare zita reMeneja webhokisi rebhokisi
8. Chengetedza bhuku rebhuku

03 of 06

Kuvhura Dhigiriro reDatai Bhokisi reDhialog

Kuvhura Dhigiriro reDatai Bhokisi reDhialog

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

Mukuwedzera kune kuwedzera kuisa pasi pasi pane pepa rekushanda, kushandiswa kwemashoko kuExpcel kunogonawo kushandiswa kudzora kana kugadzirisa rudzi rwe data runogona kupinda mune mamwe masero mune pepa rekushanda.

Tutorial Steps

1. Dzvanya pachitokisi C1 chebhuku rinodonha-list-list.xlsx kuti riite iro rinoshandiswa seki - iyi ndiyo iyo rondedzero ruchave ruchawanikwa
2. Dzvanya paData Dhauriro yemadhoni yemenyu pane pepa pepaji
3. Dzvanya paDhiyabvumirano yeDhiyabvumirano paDabhoni kuti uzarure mhando yekunyorera
4. Dzvanya paIndesheni Yokugadzirisa Dhiyabhorosi mu menyu kuti uzarure Dhiyabvumirano reDhiyabvumirano reDhiyabhorosi
5. Siya ibhokisi rekuzarura rakazarurirwa kune danho rinotevera mune zvidzidzo

04 of 06

Kushandisa Kurongeka Kwekugadzirisa Dhiyabhorosi

Kusarudza Chinyorwa Chekugadzirisa Dhiyabhorosi

Sezvakataurwa apa pane zvimwe zvingasarudzwa zvekugadzirisa deta kuExcel mune zvekuderera pasi.

Munhanho iyi tichasarudza sarudzo yeChirangaridzo sekuti rudzi rwekugadzirisa dhesiza ruchashandiswa pane cell D1 yebasa.

Tutorial Steps

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 C1 uye kushandura Mutsara weNowanzo mubhokisi rebhokisi

Kupinda Data Dhesi uye Kuzadza Drop Down List

Sezvo deta inotora dhiriri pasi iri pane rimwe bhuku rebhuku, yechipiri inonzi zita yakasikwa yakagadzirwa kare ichapinda muIndaneti mubhokisi rebhokisi.

Tutorial Steps

1. Dzvanya paIndaneti
2. Tora "= Data" (hapana zvinyorwa) muIndaneti
3. Dzvanya OK kuti upedze rondedzero uye uvhare Dhiyabvumirano yeDhiyabhorosi yebhokisi
4. Chinhu chiduku chine museve chinowanikwa kuruboshwe rwema cell C1
5. Kushandura museve pasi unofanirwa kuzarura rondedzere runyora rine mazita mana emakoko akapinda mumasero A1 kusvika kuA4 yemabhuku e -data-source.xlsx
6. Kushanda pane rimwe remazita rinofanira kupinda iyo zita muchitokisi C1

05 of 06

Kuchinja Drop Down List

Kuchinja Zvinhu Zvinyorwa

Kuchengeta kudonha pasi kwemashoko kusvika pane zvishanduko munharaunda yedu, zvinogona kudikanwa kuti nguva nenguva ichinje sarudzo dziri muurongwa.

Kubvira patakashandisa mazita akanzi shanduko yezvinhu zvatakanyora pane zvinyorwa mazita, kushandura mazita ekoki muhutano hwakatumidzwa uri mumasero A1 kusvika kuA4 yedhizha re data-source.xlsx rinoshandura mazita ekuderera list.

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

Muchitsika ichi tichashandura Lemon kusvika Shortbread muburusa rezasi nekudarika deta iri muchitsetse A2 cheiyo inonzi yakatarwa mubhuku rebhuku re data-source.xlsx .

Tutorial Steps

1. Dzvanya pachitokisi A2 mubhuku rebhuku -data-source.xlsx (Lemon) kuti riite iro rinoshanda masero
2. Tumira Shortbread mu-cell A2 uye shandisai Enter key pane keyboard
3. Dzvanya pamusoroshe pasi pasi pakaderera pasi muchitsime C1 chebhuku rezasi-list -x.xlsx kuti uzarure urongwa
4. Chinyorwa 2 muchirongwa chinofanira kuverengwa iye zvino Chidimbu pane nzvimbo yeLimu

06 of 06

Sarudzo dzekudzivirira Drop Down List

Sarudzo dzekudzivirira Drop Down List

Sezvo deta yedu iri pane rimwe pepa pepaji rakasiyana kubva pakaderera pasi zvarudzo zvinowanikwa pakudzivirira deta data zvinosanganisira:

• Chengetedza pepa rekushanda rinobatanidza kuvhara masero A1 kusvika kuA4 pane peji 2
• Inoda kuti password ichinje bhuku
• Kuva nebhuku rebasa rakasununguka seRive -chete