Nws yooj yim heev rau kev ua haujlwm nrog ntau lub rooj rau kev suav hauv Microsoft Excel. Ntawm lawv lub hauv paus, koj tuaj yeem tsim cov ntawv tshaj tawm, tsim cov duab kos ntawm ntau hom thiab duab. Thaum ua haujlwm nrog cov ntaub ntawv, ib qho ntawm cov ntu pabcuam hauv Excel yog daim ntawv teev npe cia. Nrog kev pabcuam ntawm cov khoom siv no, tus neeg siv tuaj yeem xaiv tus nqi hauv ib daim teb los ntawm tus lej ntawm cov kev cai teev tseg, cov ntaub ntawv tsis sib xws. Daim ntawv teev nco-pom tau nruab nrog siv cov cuab yeej hauv Excel. Koj tuaj yeem tsim daim ntawv teev cia los ntawm kev muab hom tshwj xeeb rau cov ntaub ntawv ntau lossis siv ib qho kev tswj hwm.
Cov Lus Qhia
Kauj ruam 1
Hauv kab ntawv lossis kab ntawv, xaiv cov kab ntawv nrog cov ntaub ntawv uas koj xav tso rau hauv daim ntawv teev cia. Hauv cov ntawv qhia zaub mov, xaiv "Ntxig" - "Npe" - "Tee Npe". Tom ntej no, hauv daim teb uas tau thov, sau lub npe rau xaiv ntau thiab nyem "OK".
Kauj ruam 2
Hauv qhov chaw xav tau ntawm daim ntawv, xaiv lub xov tooj ntawm lub xov tooj kom qhia cov ntawv teev npe. Hauv cov ntawv qhia zaub mov, qhib cov khoom "Cov Ntaub Ntawv" - "Tshawb". Tom qab ntawd mus rau "Kab Txwv" tab nyob rau hauv lub qhov rai tshiab thiab teeb "Sau" kab hauv "Cov hom ntaub ntawv" teb uas qhib. Hauv qhov no, qhov chaw "Source" yuav tshwm nyob rau hauv tib lub qhov rais. Nkag mus rau lub cim "=" hauv nws thiab lub npe ntawm cov kab lus xaiv uas tau muab rau lub hlwb nrog cov ntaub ntawv. Nias "Sau" lossis "Ok" los siv qhov ntsuas. Qhov no yog qhov sib txawv ntawm qhov yooj yim poob qis tshaj plaws.
Kauj ruam 3
Hauv qhov no, qhov chaw "Source" yuav tshwm nyob rau hauv tib lub qhov rais. Nkag mus rau lub cim "=" hauv nws thiab lub npe ntawm cov kab lus xaiv uas tau muab rau lub hlwb nrog cov ntaub ntawv. Txhawm rau siv cov kev teeb tsa, nias "Nkag mus" lossis "Ok". Qhov no yog qhov sib txawv ntawm qhov yooj yim poob qis tshaj plaws.
Kauj ruam 4
Excel muaj lub peev xwm los txhais kom yooj yim tshaj tawm cov ntawv teev npe cia. Txhawm rau ua qhov no, siv ib qho kev tswj hwm hu ua "combo box" ntxig rau hauv Daim Ntawv Excel. Txhawm rau nruab nws, qhib cov ntawv qhia zaub mov "Saib", tom qab ntawd "Toolbars" thiab cov khoom ncua "Cov ntawv".
Kauj ruam 5
Xaiv lub "combo box" icon rau ntawm lub tswj vaj huam sib luag uas qhib - qhov no yog daim ntawv teev xa khoom. Kos lub thawv muaj lub thawv duab plaub nrog nas. Xaiv cov npe kos nrog txoj khawm nas thiab xaiv xaiv "Hom phiaj …" hais kom ua.
Kauj Ruam 6
Hauv lub npov xov tooj uas tau tshwm sim, hauv "Tsim kom muaj npe los ntawm ntau yam" teb, qhia kom meej cov yam xav ntawm cov hlwb. Txhawm rau ua qhov no, siv tus nas xaiv lub hlwb uas yuav tsum suav nrog hauv daim ntawv nco no hauv Excel. Hauv kab ntawv "Txuas rau ntawm tes", teeb tus xov tooj ntawm tes los tso saib cov xov tooj ntawm cov khoom xaiv hauv kab. Qhia cov naj npawb uas yuav tsum muaj ntawm kab rau daim ntawv tsim. Lub pob "Ok" yuav thov tag nrho cov teeb tsa cov qauv, thiab cov npe tau npaj los siv.
