Create a Google Sheets Drop-down List

Cov txheej txheem:

Create a Google Sheets Drop-down List
Create a Google Sheets Drop-down List
Anonim

Thaum tsim daim ntawv nthuav qhia nrog Google Sheets, koj yuav tsum tau tsim ib lossis ntau cov npe poob hauv nws lub hlwb. Cov ntawv qhia zaub mov yooj yim no ua rau tus neeg siv xaiv los ntawm cov npe ntawm cov khoom thiab hloov kho cov zis hauv lwm lub hlwb raws li lawv xaiv. Nov yog yuav ua li cas los tsim thiab hloov cov ntawv qhia zaub mov hauv Google Sheets.

Create a Drop-down List on a Computer

Ib daim ntawv teev npe poob lossis lwm txoj hauv kev siv tau cov ntaub ntawv tuaj yeem tsim thiab siv rau ib lossis ntau lub hlwb hauv Sheets spreadsheet ntawm feem ntau desktop thiab laptop web browsers. Txawm li cas los xij, Google Chrome tau pom zoo rau kev ua haujlwm zoo.

  1. Qhib ib daim ntawv tshiab lossis uas twb muaj lawm.
  2. Xaiv lub xovtooj lossis pab pawg ntawm cov hlwb uas koj xav tso cov npe poob.

    Image
    Image
  3. mus rau Data tab.

    Image
    Image
  4. Xaiv Data validation.

    Image
    Image
  5. The Data validation dialog box qhia, muaj ntau yam kev xaiv. Thawj, sau npe Cell range, qhia qhov chaw nyob qhov twg daim ntawv teev npe yuav nyob.

    Image
    Image
  6. The Criteria qhov chaw muaj cov ntawv qhia zaub mov uas muaj cov kev xaiv hauv qab no. Txhua qhov kev xaiv dictates cov ntaub ntawv tshwj xeeb uas tus neeg siv yuav tsum ua raws thaum nkag lossis xaiv ib yam khoom hauv lossis los ntawm lub xov tooj ntawm tes.

    • Lus los ntawm ntau yam: Thaum xaiv, cov npe poob qis uas muaj cov txiaj ntsig tau muab los ntawm cov xov tooj tshwj xeeb (los ntawm daim ntawv nquag lossis lwm daim ntawv hauv phau ntawv ua haujlwm tam sim no) tshwm.
    • Daim npe ntawm cov khoom: Thaum xaiv, cov npe poob qis uas muaj cov ntawv sau muaj txiaj ntsig nkag rau hauv daim teb nrog kho kom raug. Txhua yam khoom nkag yuav tsum tau muab cais los ntawm tus lej cim.
    • Number: Qhov no tsis nthuav tawm cov npe poob rau tus neeg siv. Hloov chaw, nws lees paub tias lawv qhov kev nkag tau poob rau hauv cov lej tshwj xeeb.
    • Text: Qhov no tsis nthuav tawm cov npe poob. Hloov chaw, nws lees paub tias qhov nkag muaj lossis tsis muaj cov kab ntawv tshwj xeeb, yog qhov chaw nyob email siv tau, lossis yog qhov tsim URL zoo.
    • Date: Qhov kev xaiv no tsis tsim ib daim ntawv teev npe poob. Nws validates seb ib hnub twg nkag rau hauv cov hlwb uas tau xaiv yog siv tau los yog poob rau hauv ib qho tshwj xeeb.
    • Cov qauv kev cai yog: Qhov no tso cai rau cov ntaub ntawv siv tau hauv cov hlwb uas tau xaiv los siv tus qauv qhia tus neeg siv.
    Image
    Image
  7. Yog tus nqi xaiv nyob rau hauv Criteria ntu tsim ib daim ntawv teev npe, tus Show drop-down list in cell check box kuj tshwm. Enabled los ntawm lub neej ntawd, tshem tawm cov kos cim dictates tias cov ntaub ntawv teev tseg validation yuav tshwm sim nyob rau hauv cov xaiv cell, tab sis tsis muaj drop-down daim ntawv teev. Qhov kev xaiv no tuaj yeem pab tau yog tias koj xav tau daim ntawv teev cov neeg siv kawg nkaus xwb kom muaj kev xaiv nkag mus rau cov ntaub ntawv manually, tsis yog xaiv los ntawm ib daim ntawv teev npe.

    Image
    Image
  8. Tus Ntawm cov ntaub ntawv tsis raug ntu tswj tau dab tsi tshwm sim thaum daim ntawv nthuav qhia tus neeg siv nkag mus rau qee yam rau hauv cov hlwb uas tau xaiv uas ua tsis tiav cov ntaub ntawv siv tau. Ob txoj kev xaiv muaj tso cai rau koj los qhia cov lus ceeb toom hauv qhov piv txwv no lossis tsis lees paub tus neeg siv cov lus nkag.

    Image
    Image
  9. The Tshwmsim teeb tsa dictates seb cov ntawv zoo li muab rau cov neeg siv kawg lub tswv yim zoo dua ntawm cov txiaj ntsig tau txais hauv cov xov tooj ntawm tes. Txhawm rau qhib qhov kev pabcuam virtual no, xaiv lub Show validation help text check box. Tom ntej no, nkag los yog hloov cov ntawv uas koj xav kom tso saib.

    Image
    Image
  10. Thaum koj txaus siab rau koj cov kev xaiv, xaiv Txuag.

    Image
    Image

Hloov kho lossis tshem tawm cov npe poob hauv lub vev xaib browser

Ua cov kauj ruam hauv qab no los hloov kho lossis tshem tawm cov npe poob lossis lwm cov ntaub ntawv siv tau los ntawm ib lub xov tooj tshwj xeeb.

  1. Xaiv cov hlwb uas muaj cov npe poob lossis lwm cov ntaub ntawv siv tau uas koj xav hloov lossis tshem tawm.
  2. mus rau Data tab.

    Image
    Image
  3. Xaiv Data validation.

    Image
    Image
  4. The Data validation dialog box qhia, muaj ntau yam kev xaiv. Txhawm rau hloov tus cwj pwm ntawm tes, ua qhov kev hloov pauv uas xav tau, tom qab ntawd xaiv Txuagtxhawm rau siv cov kev hloov tam sim. Txhawm rau tshem tawm cov npe poob lossis lwm yam kev lees paub, xaiv Tshem tawm qhov tseeb

    Image
    Image

Tsim ib Daim Ntawv Teev Npe ntawm ib qho khoom siv Android

Ib daim ntawv teev npe poob lossis lwm txoj hauv kev siv tau cov ntaub ntawv tuaj yeem tsim thiab siv rau ib lossis ntau lub hlwb hauv daim ntawv nthuav qhia ntawm koj lub xov tooj Android lossis ntsiav tshuaj siv Sheets app.

  1. Qhib ib daim ntawv tshiab lossis uas twb muaj lawm hauv daim ntawv thov.
  2. Xaiv lub xovtooj lossis pab pawg ntawm cov hlwb uas koj xav tso cov npe poob.
  3. Coj mus rhaub lub khawm zaub mov tseem ceeb, sawv cev los ntawm peb qhov sib xyaw ua ke, thiab nyob rau hauv kaum sab xis ntawm lub vijtsam. Thaum cov ntawv qhia zaub mov tshwm, xaiv Data Validation.
  4. The Data validation interface qhia thiab muaj ntau yam kev xaiv. Thawj, sau npe Cell range, qhia meej qhov chaw nyob qhov twg daim ntawv teev npe yuav nyob.
  5. The Criteria qhov chaw muaj cov ntawv qhia zaub mov uas muaj cov kev xaiv hauv qab no. Txhua qhov kev xaiv dictates cov ntaub ntawv tshwj xeeb uas tus neeg siv yuav tsum ua raws thaum nkag lossis xaiv ib yam khoom hauv lossis los ntawm lub xov tooj ntawm tes.

    • Daim npe ntawm cov khoom: Thaum xaiv, cov npe poob qis uas muaj cov ntawv sau tau nkag rau hauv daim teb nrog yuav tshwm rau tus neeg siv. Coj mus rhaub Ntxiv ua ntej nkag mus rau txhua daim ntawv teev npe.
    • Lus los ntawm ntau yam: Thaum xaiv, cov npe poob qis uas muaj cov txiaj ntsig tau muab los ntawm cov xov tooj tshwj xeeb (los ntawm daim ntawv nquag lossis lwm daim ntawv hauv phau ntawv ua haujlwm tam sim no) tshwm rau tus neeg siv. Ib qho piv txwv yog Sheet1!A2:D5.
    • Text muaj: Xyuas kom meej tias cov ntawv nkag los ntawm daim ntawv nthuav qhia tus neeg siv suav nrog ib txoj hlua tshwj xeeb.
    • Text tsis muaj: Qhov txawv ntawm qhov kev xaiv saum toj no. Nws lees paub tias cov ntawv sau tsis muaj ib txoj hlua tshwj xeeb.
    • Text raws nraim: Siv tau tias cov ntawv sau los ntawm tus neeg siv sib phim ib txoj hlua tshwj xeeb.
    • Is email siv tau: Ua kom pom tseeb tias tus neeg siv nkag mus rau qhov chaw nyob email kom raug.
    • Yuav siv tau URL: Xyuas kom tus neeg siv nkag mus rau qhov chaw nyob hauv lub vev xaib tag nrho.
    • Hnub siv tau: lees paub tias tus neeg siv nkag mus rau hnub tim tiag tiag hauv hom ntawv raug.
    • Hnub yog: Kev nkag yuav tsum phim ib hnub / hli / xyoo.
    • Hnub yog nruab nrab: Kev nkag yuav tsum yog hnub uas poob rau hauv ib qho tshwj xeeb.
    • Hnub tsis nyob nruab nrab: Kev nkag yuav tsum yog hnub uas tsis poob rau hauv ib qho tshwj xeeb.
    • Hnub yog nyob rau lossis ua ntej: Kev nkag yuav tsum phim ib hnub tshwj xeeb lossis yog hnub twg ua ntej nws.
    • Hnub yog nyob rau lossis tom qab: Kev nkag yuav tsum phim ib hnub tshwj xeeb lossis yog hnub twg tom qab nws.
    • Hnub yog tom qab: Kev nkag yuav tsum yog qee lub sijhawm tom qab hnub tau teev tseg.
    • Ntau dua: Kev nkag yuav tsum yog tus lej ntau dua qhov tau teev tseg.
    • Ntau dua lossis sib npaug: Kev nkag yuav tsum yog tus lej ntau dua lossis sib npaug ntawm qhov tau teev tseg.
    • Less than: Kev nkag yuav tsum yog tus lej tsawg dua qhov tau teev tseg.
    • Less dua lossis sib npaug: Kev nkag yuav tsum yog tus lej tsawg dua lossis sib piv rau qhov tau teev tseg.
    • Equal to: Kev nkag yuav tsum yog tus lej uas phim rau qhov tau teev tseg.
    • Tsis sib npaug: Kev nkag yuav tsum yog tus lej uas tsis sib xws.
    • Nruab nrab: Kev nkag yuav tsum yog tus lej hauv qhov kev teev tseg.
    • Tsis nyob nruab nrab: Kev nkag yuav tsum yog tus lej uas tsis poob hauv qhov kev teev tseg.
    • Cov qauv kev cai: Qhov no tso cai rau kev siv cov ntaub ntawv hauv cov hlwb uas tau xaiv los siv tus qauv qhia tus neeg siv.
  6. Yog tus nqi xaiv nyob rau hauv Criteria ntu tsim ib daim ntawv teev npe, ib qho kev xaiv sau Qhia cov npe poob hauv cell kuj muab. Qhov kev xaiv no tau qhib los ntawm lub neej ntawd. Disabling qhov kev xaiv no los ntawm kev xaiv nws nrog slider (tig nws los ntawm xiav mus rau grey) dictates tias cov ntaub ntawv teev validation yuav muaj nyob rau hauv cov xaiv cell, tab sis tsis muaj drop-down daim ntawv teev yuav tshwm sim. Qhov kev xaiv no tuaj yeem pab tau yog tias koj xav tau daim ntawv teev cov neeg siv kawg nkaus xwb kom muaj kev xaiv nkag mus rau cov ntaub ntawv manually, tsis yog xaiv los ntawm ib daim ntawv teev npe.
  7. The Tshwmsim qhov teeb tsa txiav txim siab seb cov ntawv nyeem puas tau pom los muab cov neeg siv kawg lub tswv yim zoo dua ntawm cov txiaj ntsig uas tau txais hauv cov xov tooj ntawm tes. Txhawm rau qhib qhov kev pabcuam virtual no, qhib lub Qhia kev siv tau cov ntawv nyeem toggle hloov. Tom ntej no, xaiv Edit thiab sau lossis hloov cov ntawv uas koj xav tso tawm.
  8. Tus Ntawm cov ntaub ntawv tsis raug ntu tswj tau dab tsi tshwm sim thaum daim ntawv nthuav qhia tus neeg siv nkag mus rau qee yam rau hauv cov hlwb uas tau xaiv uas ua tsis tiav cov ntaub ntawv txheeb xyuas. Ob txoj kev xaiv muaj tso cai rau koj los qhia cov lus ceeb toom hauv qhov piv txwv no lossis tsis lees paub tus neeg siv cov lus nkag.
  9. Thaum koj txaus siab rau koj cov kev xaiv, coj mus rhaub Txuag.

Hloov kho lossis tshem tawm cov npe poob rau ntawm lub cuab yeej Android

  1. Xaiv cov hlwb uas muaj cov npe poob lossis lwm cov ntaub ntawv siv tau uas koj xav hloov lossis tshem tawm.
  2. Coj mus rhaub lub khawm zaub mov tseem ceeb, sawv cev los ntawm peb qhov sib xyaw ua ke, thiab nyob rau hauv kaum sab xis ntawm lub vijtsam. Thaum cov ntawv qhia zaub mov tshwm, xaiv Data Validation.
  3. The Data validation interface qhia thiab muaj ntau yam kev xaiv. Txhawm rau hloov tus cwj pwm ntawm tes, ua qhov kev hloov pauv uas xav tau, thiab coj mus rhaub khawm Txuag txhawm rau siv qhov hloov pauv. Txhawm rau tshem tawm cov npe poob lossis lwm yam kev lees paub, coj mus rhaub Tshem tawm txoj cai

Pom zoo: