Ntxiv cov thawv ntawv xa mus rau Excel 2007 daim ntawv nthuav tawm tuaj yeem ua kom nrawm cov ntaub ntawv nkag los ntawm kev muab cov npe xaiv uas tsis tas yuav ntaus lawv ib qho ib qho. Thaum koj tso lub npov poob rau ntawm daim ntawv xov tooj ntawm tes, xub xub tshwm ntawm lub xovtooj. Cov ntaub ntawv tuaj yeem nkag los ntawm txhaj lub xub thiab tom qab ntawd xaiv qhov nkag nkag. Koj tuaj yeem teeb tsa lub npov hauv ob peb feeb thiab ua kom cov ntaub ntawv nkag tau nrawm dua.
Kauj ruam
Kauj Ruam 1. Qhib daim ntawv nthuav qhia kom ntxig lub npov uas nyob hauv
Kauj Ruam 2. Sau cov npe uas koj xav pom hauv qhov nco-down
Ntaus cov ntaub ntawv hauv qhov kev txiav txim koj xav kom nws nthuav tawm. Kev nkag yuav tsum tau nkag mus rau hauv ib kab lossis kab thiab yuav tsum tsis txhob muaj cov cell khoob.
Txhawm rau sau cov ntaub ntawv xav tau ntawm daim ntawv cais, nyem rau ntawm lub tab ntawm daim ntawv uas koj nkag mus rau cov ntaub ntawv. Ntaus thiab xaiv cov ntaub ntawv koj xav kom tshwm ntawm daim ntawv. Right-click qhov xaiv ntau thiab tom qab ntawv nyem "Npe a Range" los ntawm cov npe uas tshwm. Ntaus ib lub npe nyob hauv lub npov "Npe" thiab tom qab ntawv nyem "OK". Koj tuaj yeem tiv thaiv lossis zais daim ntawv ua haujlwm txhawm rau tiv thaiv nws cov ntsiab lus los ntawm kev hloov pauv los ntawm lwm tus neeg siv
Kauj Ruam 3. Nyem rau ntawm tes uas koj xav muab lub npov tso rau
Kauj Ruam 4. Nyem rau "Data" tab ntawm Microsoft Excel 2007 ribbon
Kauj Ruam 5. Nyem rau khawm "Cov Ntaub Ntawv Pov Thawj" hauv pab pawg "Cov Ntaub Ntawv Cov Ntaub Ntawv"
Lub thawv "Txheeb Xyuas Cov Ntaub Ntawv" yuav tshwm.
Kauj Ruam 6. Nyem rau "Settings" tab thiab tom qab ntawd nyem "List" los ntawm cov npe hauv qab "Allow" box
Kauj Ruam 7. Nyem lub pob ntawm qhov kawg ntawm lub npov "Source"
Xaiv cov npe uas koj xav nkag rau hauv lub thawv nco-down.
Yog tias koj twb tau tsim lub npe ntau yam, ntaus ib qho kos npe sib npaug ua raws los ntawm ntau lub npe hauv lub npov "Source"
Kauj Ruam 8. Xaiv lossis tshem lub npov "Tsis quav ntsej", nyob ntawm seb koj puas tso cai rau cov cell uas muaj lub npov tso rau sab laug
Nco ntsoov tias lub thawv "Hauv-cell dropdown" tau xaiv.
Kauj Ruam 9. Nyem rau "Input Message" tab kom tso saib lub npov lus thaum xaiv lub xovtooj ntawm tes
Xyuas kom tseeb tias "Qhia cov lus nkag thaum lub xov tooj tau xaiv" lub npov raug xaiv thiab ntaus cov lus koj xav pom hauv "Title:" thiab "Input message:" boxes.
Kauj Ruam 10. Nyem rau "Kev Ceeb Toom Yuam Kev" tab kom pom cov lus yuam kev yog tias cov ntaub ntawv nkag rau hauv lub npov nco-down tsis sib xws
Xyuas kom tseeb tias "Qhia yuam kev ceeb toom tom qab cov ntaub ntawv tsis raug nkag mus" lub npov raug xaiv. Txhawm rau qhia cov lus ceeb toom lossis cov ntaub ntawv tab sis tso cai cov ntaub ntawv tsis raug, xaiv "Lus Ceeb Toom" lossis "Cov Ntaub Ntawv" los ntawm lub thawv "Style" drop-down. Txhawm rau tso cov lus thiab tiv thaiv cov ntaub ntawv tsis raug los ntawm kev nkag mus, xaiv "Nres" los ntawm "Style" nco lub thawv. Ntaus cov lus koj xav pom hauv "Title:" thiab "Error message:" boxes.
Kauj Ruam 11. Nyem rau "OK" txhawm rau txuag cov txheej txheem kev lees paub thiab tsim lub thawv nco-down
Lub tswv yim
- Txhawm rau tshem lub npov nco-down, nyem lub cell uas muaj lub npov. Txhawm rau tshem tawm daim ntawv teev npe, xaiv lub cell uas muaj cov npe. Nyem rau "Cov Ntaub Ntawv" tab ntawm Microsoft Excel 2007 daim kab xev. Nyem rau "Chaw" tab ces nyem rau "Clear All" khawm ces nyem "OK."
- Yog tias nkag rau hauv daim ntawv teev npe qis dua qhov dav dua ntawm kab ntawv ntawm cov cell, hloov qhov dav ntawm kab ntawv ntawm cov cell los tso saib tag nrho cov ntawv.
