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.
Dab tsi yog cov npe poob qis siv rau hauv Excel?
Ib daim ntawv teev npe hauv Excel yog cov ntaub ntawv siv tau ua haujlwm uas tso cai rau cov neeg siv xaiv qhov kev xaiv los ntawm cov npe xaiv. Nws tuaj yeem pab tau tshwj xeeb hauv kev ua qauv nyiaj txiag.
Koj ua li cas los tsim cov npe poob hauv Excel nrog ntau lub hlwb?
Right-click ib qho ntawm cov hlwb koj tseem ceeb thiab nyem "Muab tshuaj tshwj xeeb." Qhov Paste Special dialog box qhib thiab qhia ntau yam kev xaiv pasting. Nyem "Validation" ua raws li "OK." Excel luam cov npe poob rau hauv cov hlwb uas koj xaiv.
Yuav ua li cas koj tsim ib daim ntawv teev npe poob hauv nplooj ntawv?
Create a drop-down list
- Qhib daim ntawv nthuav dav hauv Google Sheets.
- Xaiv lub xovtooj lossis cov hlwb uas koj xav tsim cov npe poob.
- Click Data. …
- Next to "Criteria," xaiv qhov kev xaiv: …
- Lub hlwb yuav muaj tus xub nqes. …
- Yog tias koj nkag mus rau cov ntaub ntawv hauv lub xov tooj ntawm tes uas tsis phim ib yam khoom hauv daim ntawv, koj yuav pom cov lus ceeb toom. …
- Click Save.
HowKoj puas tsim ib daim ntawv teev npe hauv Excel?
Ntxiv ib lub npov lossis combo lub thawv rau ib daim ntawv ua haujlwm hauv Excel
- Tsim ib daim ntawv teev cov khoom uas koj xav kom tso rau hauv koj lub thawv npe zoo li hauv daim duab no.
- Click Developer > Insert. …
- Nyob rau hauv Daim Ntawv Tswj Xyuas, nyem lub npov Npe (Form Control).
- Nias lub xovtooj uas koj xav tsim lub thawv ntawv.
