Nzira Yokugadzira / Bvisa Drop Down List mu Excel

Drop-down list kana menus anogona kugadzirwa muExcel kuti ape ruzivo rwemashoko anogona kupinda mune imwe sero kune imwe chinyorwa chekutanga chinyorwa. Zvakanakira kushandisa dhesi-pasi rwekugadzirisa deta zvinosanganisira:

• kuita kuti kuwedzerwa kwepa data kuve nyore;
• kudzivirira zvikanganiso zvekupinda kwemashoko;
• kudzivirira nhamba yezvinyorwa zvekupinza deta.

Tsvaga uye Dzimba Dzvimbo

Dhiyabhorosi inowedzerwa kuhotera-pasi inogona kuwanikwa pa:

1. iro rakafanana pepaji sezvinonyorwa.
2. pane rimwe pepaji rebasa iri mubhuku rimwechete reExpcel .
3. mune rimwe bhuku re Excel rakasiyana.

Nhanho dzekuumba Drop Down List

Nhanho dzinoshandiswa kugadzira dhesiro-rutsoka rwakaratidzwa muchitokisi B3 (maokie eki) mumufananidzo uri pamusoro apa:

1. Dzvanyira pane sero B3 kuti riite iro rinoshanda sero ;
2. Dzvanya paData rebhu rebhoni ;
3. Dzvanya kuDhiviso reDain kuti uzarure mhando yekunyorera yemagetsi yekugadzirisa;
4. Mune menyu, chengeta kuDhiviso yeDhiyabhorosi kuti uuye neDhiyabvumirano yeDhiyabvumirano yebhokisi ;
5. Dzvanya pane Zvirongwa tab mubhokisi rebhokisi;
6. Dzvanya paVabvumira sarudzo mubhokisi rebhokisi kuti uzarure imenyu inodonha-hutengo huripo chero hunokosha;
7. Mune menyu, chengetedza Rheinesi ;
8. Dzvanya paIndaneti mutsara mubhokisi rebhokisi;
9. Simbisai masero E3 - E10 mubasa rekushandisa kuti uwedzere deta iri mumakero emasero kune urongwa;
10. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
11. Miseve iri pasi inofanira kuve iripo pedyo nesero B3 inoratidza kuvepo kwekuderedza-pasi urongwa;
12. Kana iwe ukanyora pamusoro pemuseve dhesi-rutsoka ruchazarura kuti ratidza mazita masere ekukoti;

Cherechedza: Miseve iri pasi inoratidza kuti kuvapo kwebhokisi rezasi-kunoratidzika apo iyo sero inoshandiswa sero rinoshanda.

Bvisa Drop Down List mu Excel

Pane imwechete kupedza nehotera-pasi urongwa inogona kubviswa nyore nyore kubva kune imwe sero rekushanda rinoshandisa dhiyabvumirano dialog box sezvinoratidzwa mumufananidzo uri pamusoro.

Cherechedza : Kana uchifambisa urongwa hwekuderedza-pasi kana dhiyabhorosi yedhaini kune imwe nzvimbo panzvimbo imwe chete yepaji, hazvidiwi kuvhara nekugadzirisazve urongwa hwekuderedza pasi seExcel huchashandura huwandu hwemashoko akashandiswa pakurongwa .

Kuchenesa dhesi-pasi:

1. Dzvanya pane sero rine rine dhesi-rusiro rwandinofanira kubviswa;
2. Dzvanya Dhiyabhorosi tab yebhoni ;
3. Dzvanya Chiratidzo Chekugadzirisa Dhiyabhorosi paibhoni kuti uzarure mhando inodonha;
4. Dzvanya Kushandura Kwekugadzirisa Data pane menyu kuti uzarure Dhiyabvumirano yeDhiyabvumirano yebhokisi;
5. Mubhokisi rebhokisi, chengetai pane Zvirongwa tab - kana zvichidikanwa;
6. Dzvanya Bhodhi Bvisa Yose kuti ubvise rondedzero yakarongwa sezvinoratidzwa mumufananidzo uri pamusoro;
7. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda .

Iyo yakasarudzwa inoderera pasi inofanira kunge yava kubviswa kubva kuseri yakasarudzwa, asi chero ipi zvayo inopinda muchitokisi chisati chaiswa runyoro chichasimbiswa uye chinofanira kubviswa pane imwechete.

Kuchenesa Drop Down List pane Pepa Rokushanda

Kubvisa zvose zvinyorwa pasi zvinowanika pahwheji rimwechete pane imwe nguva:

1. Tora nhanho imwe kusvika kune shanu mumitemo iri pamusoro;
2. Chengetedza Shandisa iyi shanduko kune mamwe masero eine imwechete yebhokisi bhokisi pane Zvirongwa tab ye dialog box;
3. Dzvanya paChinese Bese Bvisa kuti ubvise zvinyorwa zvose pasi pepaji rekushanda.
4. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.