Cov txheej txheem:

Kuv yuav tsim ib lub thawv xaiv hauv Excel li cas?
Kuv yuav tsim ib lub thawv xaiv hauv Excel li cas?

Video: Kuv yuav tsim ib lub thawv xaiv hauv Excel li cas?

Video: Kuv yuav tsim ib lub thawv xaiv hauv Excel li cas?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Kaum ib hlis
Anonim

Video

  1. Hauv daim ntawv ua haujlwm tshiab, ntaus cov ntawv koj xav kom tshwm hauv koj daim ntawv teev npe.
  2. Xaiv lub xovtooj ntawm daim ntawv ua haujlwm uas koj xav tau daim ntawv teev npe.
  3. Mus rau Cov Ntaub Ntawv tab ntawm Ribbon, tom qab ntawd Cov Ntaub Ntawv Validation.
  4. Ntawm qhov chaw tab, hauv Allow lub thawv , nyem List.
  5. Nyem rau ntawm qhov chaw lub thawv , ces xaiv koj lis.

Tsuas yog li ntawd, kuv yuav ua li cas los tsim ib daim ntawv teev npe hauv Excel 2016?

Txhawm rau tsim koj tus kheej cov npe poob rau qee lub xov tooj, ua cov hauv qab no:

  1. Nkag mus rau cov npe ntawm cov khoom hauv ib thaj tsam.
  2. Xaiv lub xov tooj ntawm tes uas yuav muaj cov npe poob qis (cell B2, hauv qhov piv txwv no).
  3. Ntawm Cov Ntaub Ntawv tab, hauv Cov Ntaub Ntawv Pab Pawg, nyem DataValidation:
  4. Nyob rau hauv cov ntaub ntawv Validation dialog box, ntawm qhov chaw tab:
  5. Nyem OK.
  6. Nco tseg:

Qhov thib ob, Kuv yuav ua li cas thiaj tsim tau lub combobox hauv Excel? Txhawm rau ntxiv lossis hloov kho Combobox, ua raws cov kauj ruam no:

  1. Ntawm Ribbon, nyem qhov Developer tab.
  2. Nyem qhov Tsim hom hais kom ua.
  3. Nyem Insert, thiab nyob rau hauv ActiveX Controls, nyem rau ntawm Combobox khawm, kom qhib lub cuab yeej ntawd.
  4. Nyem rau ntawm qhov chaw khoob ntawm daim ntawv ua haujlwm, ntxiv ib lub combobox.

Hauv qhov no, kuv yuav ua li cas thiaj nrhiav tau lub hauv paus ntawm daim ntawv teev npe hauv Excel?

Ntawm qhov chaw tab, nyem rau hauv Qhov chaw lub thawv , thiab tom qab ntawd rau ntawm daim ntawv ua haujlwm uas muaj cov ntawv nkag rau koj poob - lis , Xaiv cov ntsiab lus ntawm tes hauv Excel muaj cov ntawv no. Koj yuav pom cov lis range hauv Qhov chaw hloov lub thawv raws li koj xaiv.

Yuav ua li cas los tsim ib daim ntawv teev npe hauv Excel nrog cov ntxaij lim dej?

Kom lim cov ntaub ntawv:

  1. Pib nrog ib daim ntawv ua haujlwm uas txheeb xyuas txhua kab uas siv kab ua ntej.
  2. Xaiv cov ntaub ntawv tab, tom qab ntawd nrhiav Sort & Filtergroup.
  3. Nyem qhov Filter hais kom ua.
  4. Drop-down xub yuav tshwm nyob rau hauv header ntawm txhua kab.
  5. Nyem rau qhov drop-down xub rau kem koj xav kom lim.
  6. Lub Filter menu tshwm.

Pom zoo: