Lub drop-down daim ntawv teev nyob rau hauv Excel

Niaj hnub no computer tau ua ib qho tseem ceeb ib feem ntawm peb lub neej. Ntau yam kev pab cuam no thiaj li piv cov hauj lwm uas koj tsis tau ua tsis tau lawv txawm inexperienced novice neeg siv. Ib tug ntawm lawv yog cov Excel kev pab cuam - ib tug yooj yim, yooj yim thiab heev zoo. Tsaug rau nws cov heev heev nta, nws yuav siv tau raws li ib lub tsev computer, thiab chav ua hauj lwm. Rau ib txhia nws tau ua tsuas indispensable.

Ntawm cov hoob kawm, yuav pib ua hauj lwm nrog Excel yog heev yooj yim, tab sis, nrog lub sij hawm, to taub nws cov kev khiav dej num, nws yuav yooj yim dua. Novice neeg siv yog tej zaum nws nyuaj to taub tag nrho cov nuances ntawm kev ua hauj lwm, yog li cov tsab xov xwm no yuav tham txog ib qho kev teeb meem, uas yog ib yam uas txaus siab rau ntau yam: "Yuav ua li cas yuav ua rau ib tug nco-down daim ntawv teev nyob rau hauv Excel». Sim kom to taub.

Ua ntej ntawm tag nrho cov, peb yuav tsum to taub hais tias qhov no nco-down daim ntawv teev nyob rau hauv Excel. Heev feem ntau, ua hauj lwm ntawm Excel-cov ntaub ntawv, cov neeg siv yuav qhov yuav tsum tau mus rau hauv lub tib cov ntaub ntawv mus rau hauv ntau yam hlwb. Cov ntaub ntawv yog puab thiab ruaj. Nyob rau hauv thiaj li yuav sov ua licas piv cov txheej txheem, yuav tsum paub txog tej kev khiav dej num ntawm daim ntawv thov, raws li ib tug nco-down npe. Qhov no yog ib tug heev muab rau tshaj plaws, thiab ua ib daim ntawv teev ntawm ib tug ntau yam ntawm txoj kev.

Yog li, lub nco-down daim ntawv teev nyob rau hauv Excel yuav txheej txheem siv rau tus txheej txheem txoj kev thiab siv software ntawm lwm yam uas. Cov thawj cov ntaub ntawv yog tsim rau beginners raws li cov kev ua phem los ntawm tib lub rau tag nrho cov hom ntawm kev khiav hauj lwm systems. Yuav pib, xaiv tag nrho cov kev kawm hlwb nrog cov ntaub ntawv, uas yuav tsum tau ua nyob rau hauv txoj kev nco-down daim ntawv teev. Ces ua rau nkag mus rau cov zaub mov, thiab cov nram qab ib theem zuj zus ntawm kev ua: "Insert" - "Lub npe" - "Muab".

Sau lub npe rau lub ntau yam xaiv (nws yuav ua tau ib yam, lub ntsiab mob - nws yuav tsum tsis txhob muaj tej qhov chaw). Tej yam ua yuav ua kev pom los ntawm nias lub "OK". Tam sim no nws yog tsim nyog los nco ntsoov rau hauv lub cell nyob rau hauv uas daim ntawv yuav poob. Koj yuav tau qhia ntau tshaj ib tug. Dua qhib cov zaub mov thiab xaiv qhov hais kom ua "Cov ntaub ntawv" - "Xyuas". Ces "Options" tab. Ntawm tag nrho cov kev thov cov ntaub ntawv hom "Sau" yuav tsum tau xaiv. Nyob rau hauv lub "Tau qhov twg los" sau kos npe rau "sib npaug zos" thiab hais tias nyob rau hauv lub pib lub npe ntawm daim ntawv teev cov uas tsis muaj tej qhov chaw. Ua li cas. Excel hlauv daim ntawv teev los tsim ib txoj kev txheem.

Nyob rau hauv lub luag hauj lwm ntawm cov ntaub ntawv qhov chaw yuav ua dynamically npe ntau yam, piv txwv li, cov nqe lus hauv daim ntawv teev. Yog hais tias koj xav tau ntxiv cov ntaub ntawv mus rau lub ntsiab daim ntawv, lawv yog ntxiv rau txoj kev nco cia daim ntawv teev nyob rau hauv Excel. Muaj kuj yog ib tug muaj nuj nqi ntawm txuas npe. Qhov no txhais tau tias yog koj hloov mus rau ib, lawv yeej hloov nyob rau hauv lwm yam.

Qhov thib ob cov ntaub ntawv yuav lub creation ntawm ib tug nco-down daim ntawv teev rau siv ntawm lwm yam uas. Nyob rau hauv lub version ntawm Excel 2007-2010 nyob rau hauv lub toolbar qhib lub tab "tsim tawm" (yog ib tug laus pab cuam uas yuav qhib "Cov ntaub ntawv" tab). Ntawm no, nyob rau hauv lub saum toj no seev, nws yog tsim nyog los nrhiav tau cov icon poob-down daim ntawv teev, xaiv nws thiab kos tus duab plaub. Qhov no yuav tsum yog tus tom ntej no nco-down daim ntawv teev nyob rau hauv Excel.

Siv txoj cai nas khawm, xaiv "Format Nruas". Nyob rau hauv lub resulting dialog box, nqa tawm qhov kev txiav txim ntawm cov hauv qab no commands: "mus tsim ib daim ntawv teev qhab" (xaiv cov neeg hlwb uas yuav tsum tau nyob rau daim ntawv), "Cell link" (qhia kom meej rau ntawm tes nyob rau hauv uas yuav tau sau npe yam khoom tooj), thiab lub xeem - " tus nab npawb ntawm kab daim ntawv teev "(nkag mus rau qhov kev kawm tooj ntawm kab ntawm cov yav tom ntej daim ntawv teev). Txhua qhov txhia chaw paub meej tias qhov kev txiav txim los ntawm nias lub "OK". Lub drop-down daim ntawv teev yog tsim, koj muaj peev xwm pib ua hauj lwm.

Ib tug heev yooj yim txoj kev uas yuav tsim nco-down npe, uas yog haum txawm rau cov neeg uas muaj me ntsis kev nkag siab ntawm computers yog raws li nram no. ob los yog peb qhov tseem ceeb nkag mus rau hauv kem (ntau li ntau tau). Nyob rau ib tug ntawm lawv yuj lub cursor thiab nias lub tseem ceeb ua ke nrog keyboard Alt + Down xub los yog siv txoj cai nas khawm xaiv lub "Xaiv los ntawm cov dropdown list."