Tsim Daim Ntawv Qhia Tawm Tsam Hauv Excel Los Ntawm Lwm Daim Ntawv Sau Npe

Tsim ib qho kev teev cia hauv Excel tso cai rau koj nkag mus rau cov ntaub ntawv rau hauv ib lub xovtooj ntawm ib daim ntawv los ntawm ib daim ntawv teev npe nkag.

Cov txiaj ntsim ntawm kev siv cov npe teev cia muaj xws li:

• Ua kom nkag tau yooj yim
• Tiv thaiv cov ntaub ntawv nkag teb chaws yuam kev
• Txwv cov naj npawb ntawm cov chaw khiav nkaum rau cov ntaub ntawv

Excel Drop-Down List Cov Kauj Ruam Ntawm Cov Kauj Ruam Kawm Ntawv

• Nkag mus rau hauv Cov Ntaub Ntawv Xov Xwm
• Tsim Muaj Ntau Lub Npe Rau Cov Lus Qhia
• Pib Tshaj Tawm Tseg
• Siv Daim Ntawv Teev Npe rau Cov Ntaub Ntawv Siv Tau
• Nkag mus rau hauv Cov Ntaub Ntawv Tau Los thiab Sau Ntawv Tawm Tseg
• Hloov cov Khoom Muag
• Cov Kev Xaiv rau Kev Tiv Thaiv Daim Ntawv Teev Tseg

Nkag mus rau hauv Cov Ntaub Ntawv Xov Xwm

Thawj kauj ruam los tsim ib qho kev teev npe hauv Excel yog sau cov ntaub ntawv .

Lus Cim: Cov lus qhia hauv qab no tsis yog muab tso ua ke rau cov ntawv ua haujlwm.

Qhov no yuav tsis cuam tshuam nrog ua kom tiav daim ntawv qhia. Koj daim ntawv khom nqi yuav txawv dua li qhov piv txwv ntawm nplooj 1, tab sis kev sau npe yuav muab rau koj tib yam kev tshwm sim.

Sau cov ntaub ntawv hauv qab no rau hauv lub hlwb uas tau sau rau ntawm nplooj ntawv ib thiab ob qho ntawm Excel phau ntawv.

Cov Kauj Ruam Tutorial

1. Nkag mus rau cov ntaub ntawv hauv qab no rau hauv cov lus tseeb ntawm daim ntawv 1 ntawm daim ntawv ua haujlwm: D1 - Kua nplaum uas hom:
2. Nias ntawm daim ntawv tab rau Ntawv Qhia 2.
   
3. Nkag mus rau cov ntaub ntawv hauv qab no rau hauv cov lus tseeb ntawm daim ntawv 2 ntawm daim ntawv ua haujlwm:
   A1 - Gingerbread A2 - Txiv qaub A3 - Oatmeal Raisin A4 - Chocolate Chip

Cov ntawv sau npe yuav muab ntxiv rau ntawm E1 ntawm daim ntawv 1.

Tsim Muaj Ntau Lub Npe Rau Daim Ntawv Sau Cov Lus Qhia

Ib lub npe tau tso cai rau koj xa koj mus rau ntau hom qe ntshav hauv ib phau ntawv Excel.

Npe cov npe tau siv ntau yam hauv Excel xws li siv lawv hauv cov qauv thiab thaum tsim cov kab kos.

Hauv tag nrho cov rooj sib hais, ib qho npe hu ua yog siv qhov chaw ntawm cov xov tooj ntawm tes hais txog qhov chaw nyob ntawm daim ntawv ua haujlwm.

Thaum siv nyob rau hauv ib qho kev teev npe cia, cov npe hu ua yog siv rau cov khoom teev npe.

Cov Kauj Ruam Tutorial

1. Tsav xaiv hlwb A1 - A4 ntawm Ntawv 2.
2. Nias ntawm lub Thawv Npe ntawm sab saud Kem A
3. Hom "ncuav qab zib" (tsis muaj quotes) hauv lub Thawv Npe
4. Nias tus yuam sij ENTER rau cov keyboard
5. Cov kab A1 rau A4 ntawm daim ntawv 2 tam sim no muaj ntau lub npe "ncuav qab zib"
6. Txuag koj daim ntawv khom nqi

Qhib Cov Ntaub Ntawv Sib Txuas Txuas Cov Cai

Tag nrho cov ntaub ntawv validation xaiv nyob rau hauv Excel, nrog rau kev nco npe, yog teem siv cov ntaub ntawv validation dialog box.

Cov ntaub ntawv validation dialog box yog nyob rau hauv cov ntaub ntawv tab ntawm txoj cai .

Cov Kauj Ruam Tutorial

1. Nias ntawm daim ntawv 1 tab rau hauv qab ntawm qhov screen hloov mus rau daim ntawv 1
2. Nias ntawm E1 ntawm nws los ua nws lub xovtooj ntawm tes - qhov no yog qhov chaw ntawm qhov kev sau npe cia
3. Nias rau ntawm cov ntaub ntawv ntawm txoj cai ntawm daim ntawv tais cai saum toj sau nplooj ntawv
4. Nias ntawm cov ntaub ntawv Validation icon ntawm qhov ribbon qhib lub tshuab raj nqes
5. Nias rau ntawm cov ntaub ntawv Validation nyob rau hauv lub tshuab raj qhib cov lus Validation dialog box

Siv Daim Ntawv Teev Npe rau Cov Ntaub Ntawv Siv Tau

Ntxiv nrog rau ntxiv kev sau npe rau ib daim ntawv ua haujlwm, cov ntaub ntawv validation hauv Excel tseem siv tau los tswj los sis txo cov hom ntaub ntawv uas nkag mus rau hauv ib lub hlwb .

Qee qhov kev siv ntau dua:

• Sau
• Cov hnub thiab / lossis lub sijhawm
• Tag nrho cov naj npawb
• Cov ntawv nyeem
• Cov qauv (teeb nyob rau hauv qhov kev xaiv Kev Cai )

Nyob rau hauv lub kauj ruam no, peb yuav xaiv qhov Kev Xaiv cov ntaub ntawv raws li hom ntawm cov ntaub ntawv validation uas siv rau ntawm E1 ntawm daim ntawv 1.

Cov kauj ruam

1. Nias ntawm nqis nqis hauv lub thawv ntawv sib tham
2. Nias ntawm qhov xub hauv qhov kawg ntawm qhov Cia mus qhib cov ntawv sau cia
3. Nias ntawm Daim Ntawv Xaiv los xaiv ib qho kev teev npe cia rau cov ntaub ntawv siv nyob rau hauv D1 ntawm tes thiab kom qhib qhov chaw nyob hauv lub thawv ntawv

Nkag mus rau hauv cov ntaub ntawv thiab Sau Ntawv Tawm Tseg

Txij li cov ntaub ntawv khaws tseg cia rau hauv daim ntawv teev npe nyob rau ntawm ib daim ntawv khom nqi sib txawv, lub npe hu ua ntau dhau los yuav raug sau rau hauv qhov chaw hauv kab ntawv hauv lub thawv .

Cov kauj ruam

1. Nias rau ntawm qhov chaw
2. Hom "= ncuav qab zib" (tsis muaj quotes) nyob rau hauv qhov chaw kab
3. Nias OK los ua kom tiav qhov sau npe thiab kaw cov ntaub ntawv Validation dialog box
4. Ib sab me me xub icon nyob rau ntawm sab xis ntawm E1
5. Txhawm rau ntawm lub xub hauv qab yuav tsum qhib lub npe cia nrog cov plaub cookie npe nkag hauv hlwb A1 rau A4 rau daim ntawv 2
6. Txhaj rau ntawm ib lub npe yuav tsum sau tias lub npe ntawd rau hauv E1

Txhim Kho Cov Ntawv Sau

Kom nco tau cov ntawv teev npe nrog cov kev hloov hauv koj cov ntaub ntawv, nws yuav tsim nyog rau kev hloov cov kev xaiv hauv cov npe.

Vim hais tias peb siv ntau lub npe los ua qhov chaw rau peb cov khoom sau npe tsis yog cov npe ntawm cov npe, hloov cov npe cookie rau hauv lub npe hu ua A1 rau A4 ntawm daim ntawv 2 tam sim ntawd hloov cov npe hauv kev teev npe cia.

Yog tias cov ntaub ntawv nkag ncaj qha mus rau hauv lub thawv dialog, kev hloov rau daim ntawv yuav rov qab mus rau hauv lub thawv tawm tswv yim thiab hloov cov kab qhov chaw.

Hauv cov kauj ruam no, peb yuav hloov Tsab Ntaw rau Oatmeal Raisin hauv kev sau npe los ntawm kev hloov cov ntaub ntawv hauv Cell A3 ntawm cov npe.

Cov kauj ruam

1. Nias ntawm A3 ntawm daim ntawv 2 (Shortbread) los ua kom nws lub zog ntawm tes
2. Hom Oatmeal Raisin rau hauv Cell A3 thiab nias lub Nkag Mus rau ntawm cov keyboard
3. Nias ntawm qhov xub cia rau cov ntawv teev npe ntawm E1 ntawm daim ntawv 1 kom qhib qhov npe
4. Yam 3 nyob rau hauv daim ntawv yuav tsum tam sim no nyeem Oatmeal Raisin siv Shortbread

Cov Kev Xaiv rau Kev Tiv Thaiv Daim Ntawv Teev Tseg

Vim tias peb cov ntaub ntawv muaj nyob rau ntawm ib daim ntawv los ntawm cov ntawv sau los ntawm qhov sau tseg ob qho kev xaiv muaj rau kev tiv thaiv cov ntaub ntawv teev npe yog:

• Zais cov ntawv ua haujlwm uas muaj cov ntaub ntawv (daim ntawv 2)
• Tiv thaiv cov ntawv ua haujlwm uas xauv lub hlwb A1 rau A4 ntawm daim ntawv 2

Yog tias kev ruaj ntseg tsis txhawj txog, khiav nkaum ntawm cov ntawv ua haujlwm uas muaj cov ntaub ntawv teev npe yog qhov kev xaiv zoo vim nws ua kom yooj yim los hloov cov npe thaum twg xav tau.

Yog qhov kev txhawj xeeb muaj kev txhawj xeeb rau ib lo lus zais ntxiv thaum tiv thaiv daim ntawv khom nqi los tiv thaiv kev hloov ntawm cov ntawv teev npe.

Tsim Kev Tawm Tsib Sau rau Daim Ntawv Xaiv Ua Ntiaj Teb

Ib daim ntawv teev npe cia tso cai rau koj nkag mus rau cov ntaub ntawv hauv Excel spreadsheet los ntawm ib daim ntawv teev npe nkag ntawm preset.

Tshooj 1 siv cov txheej txheem los tsim ib qho kev teev npe cia nrog cov ntaub ntawv rau tib daim ntawv teev npe.

Cov ntawv nyeem no qhia txog kev tsim kom muaj kev sau npe rau ib daim ntawv khom nqi.

Piv Txwv: Tsim ib qho kev teev npe cia nrog cov ntaub ntawv ntawm ib daim ntawv txawv

Sau cov ntaub ntawv nram qab no rau hauv cov ntawv tseeb ntawm Daim Ntawv Npe 1 ntawm daim ntawv ua haujlwm:
E1 - Cov Khw Muag Khoom Noj
D2 - Kua nplaum uas hom:
Nias ntawm daim ntawv tab rau Ntawv Qhia 2.
Sau cov ntaub ntawv nram qab no rau hauv cov lus tseeb ntawm daim ntawv 2 los yog ib daim ntawv ua haujlwm:
A1 - Gingerbread
A2 - Txiv qaub
A3 - Oatmeal Raisin
A4 - Chocolate nti
Highlight hlwb A1 - A4 ntawm Ntawv 2.
Hom "ncuav qab zib" (tsis muaj quotes) hauv lub Thawv Npe thiab nias lub Nkag Mus rau ntawm cov keyboard.
Nias ntawm daim ntawv tab rau Ntawv 1
Nias ntawm tes E2 - qhov chaw nyob qhov twg yuav tshwm sim
Nyem ntawm cov ntaub ntawv tab
Nias ntawm cov ntaub ntawv Validation xaiv los ntawm txoj hlua qhib lub tshuab raj
Nias ntawm Validation Cov Ntaub Ntawv hauv cov ntawv qhia zaub mov coj mus rau ntawm lub thawv ntawv sib txuas lus
Nias ntawm nqis nqis hauv lub thawv ntawv sib tham
Los ntawm Daim Ntawv Tso Cai Rau Cov Ntawv Tso Cai
Hom = ncuav qab zib rau ntawm qhov chaw nyob hauv lub thawv ntawv
Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
Ib sab xub yuav tsum tshwm sim ntawm tes E2
Thaum koj nias ntawm qhov xub tis npe sau yuav tsum qhib los tso saib plaub lub npe khoom qab zib