Create a drop-down list
- Xaiv cov hlwb uas koj xav kom muaj cov npe.
- Nyob ntawm kab, nyem DATA > Cov ntaub ntawv Validation.
- Nyob rau hauv lub dialog, teem tso cai rau List.
- Nyem rau ntawm qhov chaw, ntaus cov ntawv lossis cov lej (sib cais los ntawm commas, rau daim ntawv teev npe-delimited) uas koj xav tau hauv koj daim ntawv teev npe, thiab nyem OK.
Tus yuam sij shortcut rau cov npe poob hauv Excel yog dab tsi?
Hauv koj phau ntawv ua haujlwm Excel, xaiv cov hlwb uas koj xav siv cov ntawv qhia zaub mov poob rau. Nyem rau ntawm cov ntaub ntawv validation ntawv qhia zaub mov (nyob rau hauv cov ntaub ntawv tab nyob rau hauv Excel Ribbon), los yog siv lub shortcut Alt-A-V-V. Hauv cov ntawv qhia "Allow:" dropdown menu, xaiv "List".
Kuv yuav ua li cas los tsim cov npe poob hauv Excel nrog ntau qhov kev xaiv?
To tsim cov npe poob:
- Xaiv lub xovtooj lossis lub hlwb uas koj xav kom cov npe poob qis tshwm hauv.
- Nyem rau ntawm cov ntaub ntawv tab ntawm Excel's ribbon.
- Nyem rau ntawm cov ntaub ntawv validation khawm nyob rau hauv cov ntaub ntawv cuab yeej pab pawg.
- Nyob rau hauv cov ntaub ntawv Validation dialog, nyob rau hauv lub tso cai: daim ntawv teev xaiv List.
- Click in the Source: box.
Kuv tuaj yeem tsim cov npe poob hauv Excel 2010 li cas?
Yuav ua li cas rau poob hauv Excel 2010
- Tsim cov npe rau qhov poob qis.
- Xaiv cov khoom, sau ib lub npe, ces nias Enter.
- Nias lub xovtooj uas qhov kev poob qis yuav tsum yog.
- Xaiv cov ntaub ntawv tab.
- Click Data Validation.
- Xaiv cov npe xaiv.
- Ntaus "=" kos npe, tom qab ntawd Lub Npe los ntawm kauj ruam 2.
- Click the OK.
Kuv yuav ntxiv qhov poob rau hauv pab pawg hauv Excel li cas?
Xaiv lub xovtooj uas koj xav tau daim ntawv teev npe poob. Nyem qhov DATA tab, thiab nyem Cov Ntaub Ntawv Validation. Nyob rau hauv cov ntaub ntawv Validation dialog, teem tso cai rau Sau; qhov no enables ib daim ntawv nyob rau hauv lub cell. Tawm hauv xov tooj poob qis xaiv; qhov no ua rau cov npe poob hauv lub cell.
