Raws li nyob rau hauv "Eksele" tsis poob-down daim ntawv teev (kauj ruam yog kauj ruam cov lus qhia)

Ntxiv ib tug nco-down daim ntawv teev rau ib tug Excel spreadsheet yuav ua cov ntaub ntawv nkag teb chaws sai, muab tus neeg siv ib daim ntawv teev cov khoom los ntawm kev uas mus xaiv cov kev kawm es tsis txhob mus ua cov ntaub ntawv nkag teb chaws txhua txhua lub sij hawm. Thaum koj muab tso no cov ntaub ntawv nyob rau hauv ib tug spreadsheet cell, nws pib tshwm rau hauv lub xub. Koj nkag mus rau cov ntaub ntawv los ntawm txhaj rau cov xub, thiab ces xaiv qhov kev kawm nkag. Koj yuav tau configure cov kev pab cuam "Excel" nco-down daim ntawv rau ib tug ob peb feeb, yog li zoo heev rau kev txhim kho cov kev ceev ntawm cov ntaub ntawv nkag teb chaws. Hauv qab no yog ib tug piav qhia ntawm tus txheej txheem no.

Coj rau Excel

Qhib lub rooj nyob rau hauv cov nplooj ntawv uas koj xav tau los ua ib tug nco-down daim ntawv teev. Tsim ib daim ntawv teev cov khoom uas yuav tsum tau muaj nyob rau hauv daim ntawv teev. Sau cov ntaub ntawv nyob rau hauv qhov kev txiav txim nyob rau hauv uas lawv yuav tom qab tau muab qhib. Recordings yuav tsum ua nyob rau hauv tib yam kab lossis kem, thiab yuav tsum tsis txhob muaj tas hlwb.

Yuav kom ua daim ntawv teev cov tsim nyog hais nyob rau hauv ib tug nyias muaj nyias ib daim ntawv, koj yuav tsum nias tus ntawv tab qhov twg koj xav mus nkag rau cov ntaub ntawv. Xaiv hom, thiab ces xaiv cov ntsiab lus uas zoo nkaus li nyob rau hauv daim ntawv teev. Right-click rau lub xaiv ntau yam ntawm lub hlwb, thiab ces ntaus ib lub npe rau lub ntau yam nyob rau hauv lub "npe" teb, ces nias «OK». Koj muaj peev xwm tiv thaiv los yog zais ib tug ntawv, yog li ntawd cov neeg yuav tsis hloov rau daim ntawv teev.

Cov qauv rau kev yuav ua li cas "Eksele" tsis poob-down daim ntawv teev

Nyem rau ntawm qhov cell uas koj twb xaiv tau lub hom phiaj no. Mus rau lub "Cov ntaub ntawv" tab nyob rau hauv lub Ribbon Microsoft Excel. Koj yuav pom ib tug dialog box hu ua "Cov ntaub ntawv Validation". Mus rau lub "chaw" tab thiab nias "Sau" ntawm lub "Cia" qhia zaub mov rau tus nco-down daim ntawv teev. Nyem rau ntawm qhov xov tooj cua khawm nyob rau hauv cov zaub mov "Tau qhov twg los". Xaiv lub daim ntawv teev cov khoom koj xav kom muaj xws li nyob rau hauv koj nco-down daim ntawv teev nyob rau hauv lub "Eksele".

Yog hais tias koj tau tsim ib tug ntau lub npe nyob rau hauv lub "Tau qhov twg los" icon, nkag mus rau kab zauv, thiab ces nkag mus rau lub npe ntawm tus qhab.

Cov tsim nyog nqis rau tsim

Xyuas los yog uncheck lub thawv nyob rau hauv "Las mees tas" nyob ntawm seb cov cell yuav muaj ib tug nco-down daim ntawv teev yuav tsum tau npliag.

Mus rau lub "Sau cov lus" mus tso saib ib cov lus lub thawv uas opens thaum koj nias tus nco-down daim ntawv teev. Xyuas kom tseeb tias daim tshev box tom ntej no mus rau cov zaub mov yam khoom "Qhia tswv yim lus thaum cell yog xaiv" yog teeb, thiab nkag mus rau hauv lub title. Yog li ntawd koj ua raws li tag nrho cov lus qhia nyob rau hauv yuav ua li cas "Eksele" tsis poob-down daim ntawv teev.

Nyem rau ntawm qhov "yuam kev Alert" mus tso saib ib cov lus yuam yog hais tias lawv nkag mus rau tsis yog cov ntaub ntawv. Nco ntsoov tias cov lus ceeb toom "zaub yuam kev" yog enabled los ntawm qhov chaw kawm rau qhov tsim nyog tus chij.

Nyem "OK" nyob rau hauv kev txiav txim tau mus xyuas cov kev tau txais kev cawmdim thiab teem lub nco-down daim ntawv teev.

Raws li nyob rau hauv "Eksele" tsis poob-down daim ntawv teev - pab sau ntawv

Yog hais tias koj yob nkag nyob rau hauv daim ntawv no ntau tshaj li qhov loj ntawm lub hlwb uas muaj daim ntawv no, koj yuav tau hloov lub dav ntawm lub cell saib tag nrho cov ntawv nyeem.

Yuav kom tshem tawm cov nco-down daim ntawv teev, xaiv lub cell uas muaj nws. Mus rau lub "Cov ntaub ntawv" tab nyob rau hauv lub Ribbon Microsoft Excel. Nias lub "Cov ntaub ntawv Validation" los ntawm cov pab pawg neeg "Ua hauj lwm nrog cov ntaub ntawv." Nyem qhov "chaw" tab, nias "Clear Tag nrho", ces - «OK».

Raws li koj tau saib daim ntawv qhia nyob rau hauv yuav ua li cas "Eksele" tsis poob-down daim ntawv teev yog heev yooj yim. Txoj kev qhia no tsis yuav tsum tau tej kev txawj ntse, tab sis koj yuav tsum nyob rau thawj theem yuav tsum tau mus ua hauj lwm nrog spreadsheets. Tsis tas li ntawd muaj nqis ntsoov teev yog tias nyob rau hauv sib txawv versions ntawm qhov kev pab cuam "Excel" ntawv qhia zaub mov khoom tej zaum yuav muaj ib co sib txawv nrog lub saum toj no, nws yuav tsum tau coj mus rau hauv tus account thaum ua hauj lwm.