Yuav ua li cas tswj tau AutoComplete hauv Excel
Kev xaiv AutoComplete hauv Microsoft Excel yuav cia li sau cov ntaub ntawv raws li koj hom, tiam sis nws tsis yog ib qho tseem ceeb hauv txhua qhov teeb meem.
Tsi zoo, koj tuaj yeem lov tes taw lossis tso cai rau AutoComplete thaum twg koj nyiam.
Thaum Koj Yuav Tsum Tau Thiab Yuav Tsum Tau Siv Tawm AutoComplete
Qhov no yog ib qho zoo thaum nkag mus rau hauv cov ntawv ua haujlwm uas muaj ntau ntau qhov sib npaug. Nrog AutoComplete rau, Thaum twg koj pib typing, nws yuav pib-sau tus so ntawm cov ntaub ntawv los ntawm cov ntsiab lus teb ncig, kom ceev cov ntaub ntawv nkag teb chaws heev. Cov ntaub ntawv tuaj yeem xa tuaj rau koj raws li qhov tau sau cia ua ntej nws.
Hom kev lag luam no zoo heev thaum koj nkag mus rau tib lub npe, chaw nyob, lossis lwm yam ntaub ntawv rau hauv ntau lub hlwb. Tsis tau AutoComplete, koj yuav tsum tau xa cov ntaub ntawv uas koj xav kom tau duplicated, los sis luam thiab paste nws thiab dhau, uas yuav siv sij hawm ntev heev nyob rau qee qhov kev tawm tsam.
Piv txwv li, yog tias koj ntaus "Mary Washington" hauv thawj lub xov tooj ntawm tes thiab tom qab ntawd ntau ntau yam hauv qab no, xws li "George" thiab "Harry," koj tuaj yeem sau "Mary Washington" dua sai dua li "M" thiab tom qab ntawd nias sau kom Excel yuav pib hom lub npe tag nrho.
Qhov no tuaj yeem ua rau txhua qhov ntawm cov ntawv sau hauv cov xovtooj ntawm txhua lub sijhawm, txhais tau hais tias koj tuaj yeem sau "H" rau hauv qab kom Excel sau "Harry," thiab tom qab ntawd "M" dua yog tias koj xav tau ntawd npe ua tiav. Tsis muaj taw tes koj yuav tsum luam los yog paste tej ntaub ntawv.
Txawm li cas los, AutoComplete tsis yog koj tus phooj ywg. Yog hais tias koj tsis tas yuav thiav dab tsi, nws yuav tseem pib-qhia nws txhua lub sij hawm koj pib typing ib yam dab tsi uas ua rau tib thawj tsab ntawv raws li cov ntaub ntawv yav dhau los, uas muaj peev xwm feem ntau yog ntau ntawm ib tug bother tshaj ib qho kev pab.
Enable / lov tes taw AutoComplete hauv Excel
Cov kauj ruam rau kev ua hauj lwm los yog kev tu ncua Kev AutoComplete hauv Microsoft Excel txawv me ntsis nyob ntawm version koj nyob nraum siv:
Excel 2016, 2013, thiab 2010
- Next rau cov ntaub ntawv > Cov ntawv qhia zaub mov.
- Hauv Xaiv Qhov Ncua Excel , qhib Tshaj Lij rau sab laug.
- Nyob rau hauv Editing Options seem, toggle Enable AutoComplete rau qhov tseem ceeb ntawm xov tooj ntawm los yog tawm nyob ntawm seb koj puas xav hloov no feature rau los yog lov tes taw nws.
- Nias los yog coj mus rhaub OK kom txuag tau qhov kev hloov thiab txuas ntxiv mus siv Excel.
Excel 2007
- Nias lub khawm Office .
- Xaiv Excel Options coj mus rau Excel xaiv dialog box.
- Xaiv Kev Tshaj Lij hauv cov pane mus rau sab laug.
- Nyem ntawm lub thawv ntawm qhov Enable AutoComplete rau qhov tseem ceeb ntawm kev xaiv ntawm lub xov tooj qhib qhov feature no los yog tawm.
- Xaiv OK kom kaw lub npov thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
Excel 2003
- Next rau cov cuab yeej > Options los ntawm cov ntawv qhia zaub mov qhib lub dialog box.
- Xaiv qhov hloov kho tab.
- Toggle AutoComplete rau / tawm nrog lub checkmark box tom ntej ntawm Pab kom AutoComplete rau qhov kev xaiv ntawm tes.
- Nyem OK kom txuag tau qhov hloov thiab xa rov mus rau hauv daim ntawv ua haujlwm.