Yuav Paub
- Excel 2019 txog 2010: Mus rau File > Options > Advanced. Hauv qab Editing Options, toggle Enable AutoComplete for cell values on or off.
- Excel 2007: Nyem qhov Chaw Haujlwm> Excel Options > Advanced. Xaiv los yog tsis xaiv Enable AutoComplete rau cell values.
- Excel 2003: Go to Tools > Options > Edit. Xaiv los yog tsis xaiv Enable AutoComplete rau cell values.
Kab lus no piav qhia yuav ua li cas thiaj li pab tau lossis lov tes taw kev xaiv AutoComplete hauv Microsoft Excel, uas yuav cia li sau cov ntaub ntawv thaum koj ntaus. Cov lus qhia npog Excel 2019, 2016, 2013, 2010, 2007, thiab 2003.
Enable/Disable AutoComplete in Excel
Cov kauj ruam rau kev ua kom tau lossis tsis ua haujlwm AutoComplete hauv Microsoft Excel yog qhov sib txawv nyob ntawm qhov koj siv:
In Excel 2019, 2016, 2013, thiab 2010
- Niag mus rau File> Options menu.
- In the Excel Options qhov rais, qhib Advanced ntawm sab laug.
-
Nyob rau hauv Editing Options, toggle Enable AutoComplete rau cell values rau lossis tawm nyob ntawm seb koj puas xav tig qhov no rau los yog lov tes taw nws.
Image - Click los yog coj mus rhaub OK txhawm rau txuag cov kev hloov pauv thiab txuas ntxiv siv Excel.
In Excel 2007
- Click the Office Button.
-
Xaiv Excel Options txhawm rau nqa lub Excel Options dialog box.
- Xaiv Advanced hauv pane mus rau sab laug.
- Nias lub npov nyob ib sab ntawm Enable AutoComplete rau cov txiaj ntsig ntawm tes xaiv lub thawv kom qhib lossis kaw qhov no.
- Xaiv OK txhawm rau kaw lub dialog thiab rov qab mus rau daim ntawv ua haujlwm.
In Excel 2003
- Navig rau Tools > Options los ntawm cov ntawv qhia zaub mov kom qhib lub Options dialog box.
- Xaiv lub Edit tab.
- Toggle AutoComplete on/off with the checkmark box next to the Enable AutoComplete for cell values kev xaiv.
- Click OK txhawm rau txuag cov kev hloov pauv thiab rov qab mus rau daim ntawv ua haujlwm.
Thaum Koj Yuav Tsum Tau thiab Tsis Txhob Siv AutoComplete
AutoComplete muaj txiaj ntsig zoo thaum nkag mus rau cov ntaub ntawv rau hauv daim ntawv ua haujlwm uas muaj ntau qhov sib npaug. Nrog AutoComplete rau, thaum koj pib ntaus ntawv, nws yuav pib sau tag nrho cov ntaub ntawv los ntawm cov ntsiab lus nyob ib puag ncig nws, kom ceev cov ntaub ntawv nkag.
Hais tias koj nkag mus rau tib lub npe, chaw nyob, lossis lwm yam ntaub ntawv rau hauv ntau lub hlwb. Yog tsis muaj AutoComplete, koj yuav tau rov ntaus cov ntaub ntawv los yog luam tawm thiab muab tshuaj txhuam nws dua, uas nkim sij hawm.
Piv txwv li, yog tias koj ntaus "Mary Washington" hauv thawj lub xov tooj thiab tom qab ntawd ntau lwm yam hauv qab no, xws li "George" thiab "Harry," koj tuaj yeem ntaus "Mary Washington" dua sai dua los ntawm tsuas yog ntaus "M" thiab nias Enter kom Excel yuav pib ntaus lub npe tag nrho.
Koj tuaj yeem ua qhov no nrog txhua tus lej ntawm cov ntawv nkag hauv ib lub xovtooj ntawm txhua lub xov tooj, txhais tau tias koj tuaj yeem ntaus "H" hauv qab kom Excel qhia "Harry," thiab ntaus "M" dua yog tias koj yuav tsum muaj lub npe ntawd pib ua kom tiav. Tsis tas yuav luam lossis muab cov ntaub ntawv.
Txawm li cas los xij, AutoComplete tsis yog koj tus phooj ywg ib txwm. Yog tias koj tsis tas yuav luam ib yam dab tsi, nws tseem yuav pib qhia nws txhua zaus koj pib ntaus ib yam dab tsi uas sib qhia thawj tsab ntawv raws li cov ntaub ntawv dhau los, uas feem ntau tuaj yeem cuam tshuam ntau dua li kev pab.
