Yuav ua li cas rau Excel yuav ua rau nco-down npe: qhov nyuaj txoj kev

Muaj ntau cov neeg siv ntawm tus txheej txheem chaw ua hauj lwm suite ntawm Microsoft Excel spreadsheet obviously underestimate editor. Lub drop-down daim ntawv teev nyob rau hauv lub thawv, txuag lub sij hawm nws yuav siv sij hawm mus rau nkag mus los yog nrhiav cov ntaub ntawv, nws tsim ib tug ob peb lub vib nas this, raws li txwv mus rau Access, qhov twg ntawm txoj kev yog nyuab dua. Hauv qab no yog peb tej txoj kev mus rau tsim xws li npe, thiab ib co ntawm cov tseem ceeb tsis muaj kev tswj.

Yuav ua li cas yog nco-down npe?

Tsis npe ntawm no hom koom nrog ib tug ntau ntawm cov ntaub ntawv sau npe. Nyob rau hauv ib tes, koj yuav tau sau ntau tshaj ib lub ntsiab lus, raws li nws yog ua los ntawm neej ntawd hais, tab sis ob peb.

Tswv yim xaiv tej zaum yuav ob:

• Tsuas yog qhov tseem ceeb ntawm cov generated daim ntawv teev.
• Qhov tseem ceeb ntawm daim ntawv, thiab lwm yam ntaub ntawv.

Yog li, peb yuav pib ua hauj lwm nrog Excel. Tsim ib tug nco-down daim ntawv teev no yog heev yooj yim. Tiam sis ua ntej, koj yuav tsum tau ua ib co sij hawm luag ua rau nws thiaj li tag nrho cov txheej txheem yog txo rau cov kev xaiv ntawm kev nkag mus kawm qhov tsim nyog cov ntaub ntawv.

Yuav ua li cas rau Excel yuav ua rau nco-down npe: general txoj kev

Cov thawj zaug rau theem yuav nkag tau mus rau ib tug muaj nuj nqi, uas tso cai rau ua txoj kev ua no. Yuav ua li cas yuav ua rau ib tug Excel poob-down npe rau lub hauv paus ntawm tus txheej txheem nta ntawm qhov kev pab cuam? Heev yooj yim. Ua ntej, xaiv ib tug los yog ntau tshaj ntawm tes, uas yog npaj kom paub ib co ntau yam ntawm qhov tseem ceeb, thiab cov right-click ntsiab lus teb ntawv qhia zaub mov. Nyob rau hauv nws, thawj siv cov "Cov ntaub ntawv" seem, thiab ces - nias "Cov ntaub ntawv Validation". Thiab mus rau qhov chaw tab.

Nws muaj ib tug mob (test) kev xeem nrog ib tug hlua ntaub ntawv hom, thiab qhov chaw uas peb yuav xaiv "Sau". Nyob rau hauv hauv paus ntsiab lus, cov seem teb kom txog rau thaum koj muaj peev xwm nyob twj ywm unchanged. Nws yog nyob rau hauv qab no rau txoj kab nyob rau hauv uas qhov tseem ceeb yuav tsum muab. Ntawm no nws yog ib yam dab tsi peb xav.

Lub drop-down daim ntawv teev nyob rau hauv Excel 2007: Phau ntawv cov ntaub ntawv nkag teb chaws

Cia peb pib nrog phau ntawv nkag teb chaws ntawm qhov tseem ceeb. Yog hais tias peb tham txog yuav ua li cas yuav ua rau ib tug Excel nco-down npe nyob rau hauv no yav tas, cov tshuaj yog muab lub qhov tseem ceeb nyob rau hauv lub saum toj no teb ib leeg. Nws yuav tsum tau muab sau tseg hais tias koj yuav tsum sau qhov tseem ceeb sib cais los ntawm semicolons rau Lavxias teb sab localization. Hais txog Askiv ntus no tsuas tsis nco qab. Lub disadvantage ntawm no txoj kev yog cuab kev: nws yuav siv sij hawm ntau heev lub sij hawm.

Tau qhov twg los ntawm ntau yam

Nyob rau hauv lub thib ob cov ntaub ntawv, koj yuav tau siv ib tug ceev tshuaj. Piv txwv li, peb yuav tsum tau nkag mus rau tag nrho cov qhov tseem ceeb nyob rau hauv lub hlwb: los ntawm lub A2 thiab xaus nrog A4. Yog qhov yog hais txoj hlua, nws txo nws hwj lub cursor. Ces cias xaiv cov yam band. Qhov kev pab cuam nws tus kheej yuav muab vaj huam sib luag kos npe rau, tab sis yuav sau npe tus nqi yog tsis nyob rau hauv daim ntawv «(A2: A4)», raws li nws yog ua li cas nyob rau hauv cov coj kab ntawm cov qauv, thiab nyob rau hauv lub embodiment «= $ A $ 2: $ A $ 4".

Cov kev yog tiag tiag zoo rau nws ceev inserting qhov tseem ceeb. Tab sis raws li feem ntau ntawm cov ntsiab disadvantages yog lub cev tsis siv cell yog hom twg, uas yog nyob rau lwm yam los xij tsuas yog tam sim no kom nquag plias.

Muab npe yog hom twg (npe)

Thaum kawg, lwm txoj kev los daws tau qhov teeb meem ntawm yuav ua li cas rau Excel yuav ua rau nco-down npe. Ua ntej, nws tsim nws tus kheej li thiab muab ib tug coj lub npe. Thiab ces nyob rau hauv txoj kab qhov twg los yuav tsuas yuav tau mus nkag rau hauv lub npe, preceded los ntawm ib tug sib npaug zos kos npe rau. Cov txheej txheem no tso cai rau koj los mus tsim cov npe siv cov ntaub ntawv thiab qhov tseem ceeb uas muaj nyob rau ntawm txawv cov nplooj ntawv hauv phau ntawv. Thiab nws yog ib qhov kev xaiv no yog tsuas yog siv nyob rau hauv versions ntawm Excel 2007, lub editor thiab hauv qab no, raws li cov no hloov tsis paub yuav ua li cas mus ua hauj lwm nrog ib tug ntau yam nyob rau hauv uas lub teev cov ntaub ntawv los ntawm ntau los xij.

Nyob rau hauv tej chaw, Tswj

Nrog kev xav txog cov tswj npe nyob rau hauv Excel editor yog ib tug txheej ntawm tsim nyog zog. Tab sis feem ntau, tej zaum, nthuav - kis ntawm cov tsis rau lub tswv yim nrog rau cov tib tej yam kev mob. Nws siv nyob rau hauv tus neeg mob thaum nyob rau hauv ib nplooj muaj ntau ntau cov tshev mis thiab lawv tej yam kev mob yuav tsum tau hloov. Rau lub hom phiaj no, cov ntaub ntawv validation seem, uas twb tau muab siv nyob rau hauv tag nrho cov yav tas los txoj kev, tig mus rau tab "Messages nkag mus." Ntawm no koj yuav tau sau ib hint uas yog tso tawm thaum koj qhib lub cell. Cov lus yuav ua tau rau hauv thiab tawm los ntawm tsuas yog tshem tawm cov kos cim los ntawm tus taw tes ntawm nws qhia tau tias. Nyob rau yuam kev tab, koj yuav tau sau ib cov lus ceeb toom txog tsis yog cov ntaub ntawv cov tswv yim. Qhov no yog pab tau thaum muaj yog tsis muaj zog qhov tseem ceeb tswj tej yam kev mob los yog nyob rau hauv cov kev tshwm sim ntawm ib tug ib nrab hloov.

xaus

Raws li yuav pom los ntawm cov saum toj no, qhov teeb meem ntawm yuav ua li cas rau Excel yuav ua rau nco-down npe muaj cai tsis yog li ntawd tsis yooj yim. Cov lus nug no: uas txoj kev los siv? Yog hais tias cov ntaub ntawv no tsis ntau npaum li cas, qhov nyuaj version ntawm lub ce. Qhov thib ob hom yog ntau tus nais khu. Nruab nrab neeg siv nws yuav haum zoo tshaj plaws. Tab sis, yog hais tias qhov kev pab cuam kev txawj ntse los ntawm tus neeg siv tsis yog tag rau tsuas siv qhov nyuaj ntawm kev khiav dej num no yuav tsum yog los mus tsim pom npe npe thiab tom ntej tswv yim ntaub ntawv yog hom twg vim hais tias ntawm lawv. Txij li thaum qhov kev hloov nyob rau hauv lub npe hu daim ntawv teev yog ceev thiab yooj yim. Nyob rau hauv kev, xaiv cov yooj yim tshaj plaws txoj kev uas tau tsis muaj teeb meem.