Ntxiv lub npov nco cia rau hauv koj daim ntawv Excel 2007 tuaj yeem nrawm cov ntaub ntawv nkag los ntawm muab cov neeg siv cov npe khoom los xaiv los ntawm qhov tsis tas yuav ntaus cov ntaub ntawv txhua lub sijhawm. Thaum koj muab lub thawv tso rau hauv daim ntawv nthuav tawm ntawm tes, lub xovtooj ntawm tes qhia tus xub. Koj nkag mus cov ntaub ntawv los ntawm txhaj lub xub thiab tom qab ntawd xaiv qhov nkag nkag. Koj tuaj yeem teeb tsa lub npov nco hauv ob peb feeb, thiab txhim kho koj cov ntaub ntawv nkag nrawm.
Cov kauj ruam
Kauj Ruam 1. Qhib daim ntawv nthuav qhia uas koj xav ntxiv lub npov nco (es)
Kauj Ruam 2. Tsim daim ntawv teev cov khoom kom tshwm rau hauv daim ntawv teev npe
Ntaus cov ntaub ntawv hauv qhov kev txiav txim nws yuav tshwm rau hauv cov npe. Cov ntawv nkag yuav tsum raug ntaus nyob rau hauv ib kab lossis kab thiab yuav tsum tsis txhob muaj cov xovtooj khoob.
Txhawm rau tsim cov npe ntawm cov khoom xav tau ntawm daim ntawv cais, nyem rau ntawm lub tab ntawm daim ntawv uas yuav nkag mus rau cov ntaub ntawv. Ntaus thiab tom qab ntawd nthuav qhia cov ntaub ntawv kom tshwm rau hauv cov npe. Txoj cai-nias ntawm qhov tseem ceeb ntawm cov cell thiab nyem "Lub Npe Ntau" los ntawm cov npe uas tshwm. Ntaus lub npe rau thaj tsam hauv "Npe" lub thawv thiab nyem "OK". Koj tuaj yeem tiv thaiv lossis nkaum daim ntawv ua haujlwm txhawm rau tiv thaiv lwm tus neeg siv los ntawm kev hloov pauv hauv cov npe
Kauj Ruam 3. Nyem rau ntawm tes uas koj xav muab lub npov tso rau hauv
Kauj Ruam 4. Nyem rau "Data" tab ntawm Microsoft Excel 2007 ribbon
Kauj Ruam 5. Nyem rau qhov "Cov Ntaub Ntawv Pov Thawj" los ntawm pab pawg "Cov Ntaub Ntawv Cov Ntaub Ntawv"
Lub thawv "Cov Ntawv Pov Thawj Cov Ntaub Ntawv" tshwm.
Kauj Ruam 6. Nyem rau "Chaw" tab thiab tom qab ntawd nyem "Sau" los ntawm "Allow" drop-down list box
Kauj Ruam 7. Nyem rau khawm toggle kawg ntawm lub npov "Source"
Xaiv cov npe ntawm cov khoom koj xav kom muaj hauv koj lub npov nco-down.
Yog tias koj tsim ntau lub npe, hauv "Qhov Chaw" lub thawv, ntaus ib qho kos npe sib npaug thiab tom qab ntawd ntaus lub npe ntawm thaj tsam
Kauj Ruam 8. Xaiv lossis tshem lub npov "Tsis quav ntsej", nyob ntawm seb koj puas tso cai rau lub xov tooj ntawm tes uas muaj lub npov tso rau sab laug
Ua kom paub tseeb lub thawv "Hauv-cell dropdown" tau xaiv.
Kauj Ruam 9. Nyem rau "Input Message" tab kom tso saib lub npov xov tooj thaum lub xovtooj ntawm lub npov xa ntawv raug nyem
Ua kom ntseeg tau tias "Qhia cov lus nkag thaum lub xov tooj tau xaiv" lub npov raug xaiv thiab tom qab ntawd ntaus "Title:" thiab "Cov lus tawm tswv yim:" uas yuav tshwm nyob rau hauv lub thawv ntawv.
Kauj Ruam 10. Nyem rau qhov "Error Alert" tab kom pom cov lus yuam kev yog tias cov ntaub ntawv tsis raug nkag mus rau hauv lub npov ntawm tes
Ua kom ntseeg tau tias "Qhia yuam kev ceeb toom tom qab nkag mus tsis raug cov ntaub ntawv" lub npov raug xaiv. Txhawm rau tso lus ceeb toom lossis cov ntaub ntawv tab sis tsis tiv thaiv cov ntaub ntawv tsis raug los ntawm kev nkag mus, xaiv ib qho "Ceeb Toom" lossis "Cov Ntaub Ntawv" los ntawm "Style" drop-down list box. Txhawm rau tso cov lus thiab tiv thaiv cov ntaub ntawv tsis raug los ntawm kev nkag mus, xaiv "Nres" los ntawm "Style" cov npe teev cia. Ntaus "Title:" thiab "Error message:" uas koj xav pom.
Kauj Ruam 11. Nyem rau "OK" txhawm rau txuag cov txheej txheem kev lees paub thiab tsim lub thawv nco-down
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Yog tias daim ntawv teev npe nkag nkag ntev dua li cov xovtooj uas muaj lub npov sau rau hauv lub npov, hloov lub xovtooj dav los qhia tag nrho cov ntawv.
- Txhawm rau tshem tawm lub thawv nco-down, nyem lub cell uas muaj lub npov. Txhawm rau tshem tawm ib daim ntawv teev npe, xaiv lub xov tooj ntawm tes nrog cov npe. Nyem rau "Cov Ntaub Ntawv" tab ntawm Microsoft Excel 2007 ribbon. Nyem rau "Cov Ntawv Pov Thawj Cov Ntaub Ntawv" los ntawm pab pawg "Cov Ntaub Ntawv". Nyem rau "Chaw" tab, nyem rau "Clear All" khawm, thiab tom qab ntawv nyem "OK".
