Yuav ua li cas ua ib daim ntawv teev npe hauv Excel. Los ntawm cov ntawv qhia zaub mov thiab cov cuab yeej tsim tawm

Ntau tus neeg siv Excel, uas feem ntau siv qhov program no, ua haujlwm nrog ntau cov ntaub ntawv uas tas li yuav tsum tau nkag mus rau ntau lub sijhawm. Ib daim ntawv teev npe poob yuav pab txhawb txoj haujlwm, uas yuav tshem tawm qhov xav tau ntawm cov ntaub ntawv nkag mus tas li.

Tsim ib daim ntawv teev npe uas siv cov ntawv qhia zaub mov

Txoj kev no yog qhov yooj yim thiab tom qab nyeem cov lus qhia nws yuav pom tseeb txawm tias tus neeg pib tshiab.

1. Ua ntej koj yuav tsum tsim ib daim ntawv cais nyob rau hauv ib cheeb tsam ntawm uXNUMXbuXNUMXbthe daim ntawv. Los yog, yog tias koj tsis xav muab cov ntaub ntawv pov tseg kom koj tuaj yeem hloov kho nws tom qab, tsim ib daim ntawv teev npe ntawm ib daim ntawv cais.
2. Thaum txiav txim siab txog thaj tsam ntawm lub rooj ib ntus, peb sau cov npe ntawm cov khoom lag luam rau hauv nws. Txhua lub cell yuav tsum muaj ib lub npe xwb. Yog li ntawd, koj yuav tsum tau txais ib daim ntawv teev npe ua tiav hauv ib kab.
3. Tom qab xaiv lub rooj pab cuam, right-click rau nws. Hauv cov ntawv qhia zaub mov uas qhib, nqes mus, nrhiav cov khoom "Tshem npe ..." thiab nyem rau ntawm nws.

4. Lub qhov rais yuav tsum tshwm sim qhov twg, tawm tsam cov khoom "Npe", koj yuav tsum sau lub npe ntawm cov npe tsim. Thaum lub npe nkag, nyem lub pob "OK".

Tseem ceeb! Thaum tsim ib lub npe rau ib daim ntawv teev npe, koj yuav tsum coj mus rau hauv tus account ntau qhov yuav tsum tau ua: lub npe yuav tsum pib nrog ib tsab ntawv (qhov chaw, cim lossis tus lej tsis raug tso cai); Yog hais tias ob peb lo lus siv nyob rau hauv lub npe, ces yuav tsum tsis txhob muaj qhov chaw ntawm lawv (raws li txoj cai, ib tug underscore yog siv). Qee qhov xwm txheej, txhawm rau pab txhawb kev tshawb nrhiav tom ntej rau cov npe uas xav tau, cov neeg siv tso cov ntawv sau tseg hauv cov khoom "Note".

5. Xaiv cov npe koj xav hloov. Nyob rau sab saum toj ntawm lub toolbar nyob rau hauv "Ua hauj lwm nrog cov ntaub ntawv", nyem rau ntawm "Data Validation" khoom.
6. Hauv cov ntawv qhia zaub mov uas qhib, hauv "Cov ntaub ntawv hom", nyem rau ntawm "Tsev". Peb nqes mus thiab nkag mus rau "=" kos npe thiab lub npe tau muab ua ntej rau peb daim ntawv pabcuam ("Cov Khoom"). Koj tuaj yeem pom zoo los ntawm nias lub pob "OK".

5. Kev ua haujlwm tuaj yeem suav tias ua tiav. Tom qab txhaj rau ntawm txhua lub hlwb, ib lub cim tshwj xeeb yuav tsum tshwm sim ntawm sab laug nrog ib daim duab peb sab kos, ib lub ces kaum ntawm qhov uas ntsia mus. Qhov no yog ib qho kev sib tham sib khawm uas, thaum nias, qhib cov npe ntawm cov khoom uas tau muab tso ua ke yav dhau los. Nws tseem tsuas yog nyem qhib cov npe thiab sau npe hauv lub xov tooj ntawm tes.

Cov kws tshaj lij tawm tswv yim! Ua tsaug rau txoj kev no, koj tuaj yeem tsim tag nrho cov npe ntawm cov khoom muaj nyob hauv lub tsev khaws khoom thiab txuag nws. Yog tias tsim nyog, nws tsuas yog tsim lub rooj tshiab uas koj yuav tsum tau nkag mus rau cov npe uas tam sim no xav tau suav nrog lossis hloov kho.

Tsim ib daim ntawv teev npe siv cov cuab yeej tsim tawm

Txoj kev piav qhia saum toj no yog deb ntawm tib txoj kev los tsim ib daim ntawv teev npe. Koj tuaj yeem tig mus rau kev pab ntawm cov cuab yeej tsim tawm kom ua tiav txoj haujlwm no. Tsis zoo li yav dhau los, txoj kev no yog qhov nyuaj dua, uas yog vim li cas nws tsis tshua muaj neeg nyiam, txawm hais tias qee zaum nws suav tias yog ib qho kev pabcuam tseem ceeb ntawm tus accountant.

Txhawm rau tsim ib daim ntawv teev npe nyob rau hauv txoj kev no, koj yuav tsum tau ntsib cov cuab yeej loj thiab ua ntau yam haujlwm. Txawm hais tias qhov kawg tshwm sim yog qhov zoo tshaj plaws: nws tuaj yeem hloov kho qhov tsos, tsim kom muaj pes tsawg lub hlwb thiab siv lwm yam tseem ceeb. Cia peb pib:

1. Ua ntej koj yuav tsum txuas cov cuab yeej tsim tawm, vim lawv yuav tsis ua haujlwm los ntawm lub neej ntawd.
2. Txhawm rau ua qhov no, qhib "Cov Ntaub Ntawv" thiab xaiv "Options".

3. Lub qhov rais yuav qhib, qhov twg hauv daim ntawv teev npe sab laug peb nrhiav "Customize Ribbon". Nyem thiab qhib cov ntawv qhia zaub mov.
4. Hauv kab ntawv sab xis, koj yuav tsum nrhiav cov khoom "Developer" thiab muab lub cim kos rau pem hauv ntej ntawm nws, yog tias tsis muaj. Tom qab ntawd, cov cuab yeej yuav tsum tau muab tso rau hauv lub vaj huam sib luag.

5. Txhawm rau txuag cov chaw, nyem rau ntawm lub pob "OK".
6. Nrog rau qhov tshwm sim ntawm lub tab tshiab hauv Excel, muaj ntau yam tshiab. Tag nrho cov hauj lwm ntxiv yuav ua tau siv cov cuab yeej no.
7. Tom ntej no, peb tsim ib daim ntawv teev npe nrog cov npe ntawm cov khoom lag luam uas yuav tshwm sim yog tias koj xav tau hloov lub rooj tshiab thiab sau cov ntaub ntawv rau hauv nws.

8. Qhib cov cuab yeej tsim tawm. Nrhiav "Controls" thiab nyem rau ntawm "Paste". Ib daim ntawv teev cov cim yuav qhib, hovering tshaj lawv yuav tso saib cov haujlwm uas lawv ua. Peb pom "Combo Box", nws nyob hauv "ActiveX Controls" thaiv, thiab nyem rau ntawm lub cim. Qhov "Designer Mode" yuav tsum qhib.

9. Tom qab xaiv lub xovtooj sab saum toj hauv lub rooj npaj, nyob rau hauv uas cov npe yuav muab tso, peb qhib nws los ntawm txhaj LMB. Teem nws ciam teb.
10. Cov npe xaiv qhib qhib "Design Mode". Nyob ze koj tuaj yeem pom "Properties" khawm. Nws yuav tsum tau enabled mus txuas ntxiv customizing daim ntawv.
11. Cov kev xaiv yuav qhib. Peb pom cov kab "ListFillRange" thiab nkag mus rau qhov chaw nyob ntawm cov npe pabcuam.
12. RMB nyem rau ntawm lub xov tooj ntawm tes, hauv cov ntawv qhia zaub mov uas qhib, mus rau "ComboBox Object" thiab xaiv "Kho kom raug".

9. Lub hom phiaj tiav.

Lus Cim! Txhawm rau kom cov npe tso saib ntau lub hlwb nrog cov npe poob qis, nws yog qhov tsim nyog tias thaj chaw nyob ze ntawm sab laug ntug, qhov chaw xaiv qhov cim nyob, nyob twj ywm qhib. Tsuas yog nyob rau hauv rooj plaub no nws tuaj yeem ntes tus cim.

Tsim ib daim ntawv txuas

Koj tseem tuaj yeem tsim cov npe txuas los ua kom koj txoj haujlwm yooj yim dua hauv Excel. Cia peb xam seb nws yog dab tsi thiab yuav ua li cas ua rau lawv nyob rau hauv txoj kev yooj yim tshaj plaws.

1. Peb tsim ib lub rooj nrog cov npe ntawm cov khoom lag luam thiab lawv cov ntsuas ntsuas (ob txoj kev xaiv). Txhawm rau ua qhov no, koj yuav tsum ua kom tsawg kawg 3 kab.

2. Tom ntej no, koj yuav tsum khaws cov npe nrog cov npe ntawm cov khoom thiab muab nws lub npe. Txhawm rau ua qhov no, xaiv kab "Npe", right-click thiab nyem "Tshem npe." Hauv peb cov ntaub ntawv, nws yuav yog "Food_Products".
3. Ib yam li ntawd, koj yuav tsum tsim cov npe ntawm cov ntsuas ntsuas rau txhua lub npe ntawm txhua yam khoom. Peb ua tiav tag nrho cov npe.

4. Qhib lub xov tooj saum toj kawg nkaus ntawm cov npe yav tom ntej hauv kab "Npe".
5. Los ntawm kev ua haujlwm nrog cov ntaub ntawv, nyem rau ntawm cov ntaub ntawv pov thawj. Nyob rau hauv lub qhov rais drop-down, xaiv "Tsev" thiab hauv qab no peb sau lub npe rau lub "Npe".
6. Nyob rau hauv tib txoj kev, nyem rau ntawm lub xovtooj sab saum toj hauv cov ntsuas ntsuas thiab qhib qhov "Cuaj Xyuas Cov Nqis Nqis". Hauv kab lus "Qhov Chaw" peb sau cov qauv: =INDIRECT(A2).
7. Tom ntej no, koj yuav tsum siv lub autocomplete token.
8. Npaj txhij! Koj tuaj yeem pib sau rau hauv lub rooj.

xaus

Cov npe poob hauv Excel yog txoj hauv kev zoo los ua haujlwm nrog cov ntaub ntawv yooj yim dua. Thawj tus neeg paub txog cov txheej txheem ntawm kev tsim cov npe poob qis yuav qhia txog qhov nyuaj ntawm cov txheej txheem ua, tab sis qhov no tsis yog li ntawd. Qhov no tsuas yog ib qho illusion uas yooj yim kov yeej tom qab ob peb hnub ntawm kev xyaum raws li cov lus qhia saum toj no.