Autocomplete cells hauv Excel

Autocomplete hlwb hauv Excel tso cai rau koj kom ceev cov ntaub ntawv nkag mus rau hauv daim ntawv ua haujlwm. Qee qhov kev ua hauv Microsoft Excel yuav tsum tau rov ua dua ob peb zaug, uas yuav siv sijhawm ntau heev. Nws yog los automate tej hauj lwm uas lub autocomplete muaj nuj nqi tsim. Hauv qhov kev qhia no, peb yuav saib ntau txoj hauv kev rau autofill: siv lub cim thiab flash sau, uas thawj zaug tshwm sim hauv Excel 2013.

Siv tus cim autofill hauv Excel

Qee zaum koj yuav tsum luam cov ntsiab lus rau ntau lub hlwb uas nyob ib sab ntawm ib daim ntawv ua haujlwm. Koj tuaj yeem luam thiab muab cov ntaub ntawv tso rau hauv txhua lub xov tooj ntawm tes, tab sis nws muaj txoj hauv kev yooj yim dua. Txhawm rau ua qhov no, koj yuav tsum siv lub autocomplete kov, uas tso cai rau koj kom luam tawm cov ntaub ntawv sai sai.

1. Xaiv lub cell uas nws cov ntaub ntawv koj xav kom duplicate. Ib tug me me square yuav tshwm nyob rau hauv sab xis ces kaum ntawm lub cell xaiv - qhov no yog lub autofill marker.
2. Nyem thiab tuav lub khawm laug nas thiab luag tus autofill kov kom txog rau thaum tag nrho cov hlwb xav tau tseem ceeb. Ib zaug, koj tuaj yeem sau rau hauv cov hlwb ntawm ib kab lossis kab.
3. Tso tus nas khawm kom sau rau hauv cov hlwb xaiv.

Autofill Sequential Data Series hauv Excel

Ib qho autocomplete token tuaj yeem siv thaum twg koj xav tau sau cov ntaub ntawv uas muaj qhov kev txiav txim ua ntu zus. Piv txwv li, ib ntu ntawm cov lej (1, 2, 3) lossis hnub (Monday, Tuesday, Wednesday). Feem ntau, koj yuav xav xaiv ntau lub hlwb ua ntej koj siv lub cim los pab Excel txiav txim siab cov kauj ruam ua ntu zus.

Cov piv txwv hauv qab no siv ib qho autocomplete token mus txuas ntxiv ib ntu ntawm cov hnub hauv ib kab.

Instant Sau hauv Excel

Excel 2013 muaj qhov kev xaiv tshiab Flash Sau uas tuaj yeem nkag tau cov ntaub ntawv rau hauv daim ntawv ua haujlwm, txuag koj lub sijhawm thiab kev siv zog. Ib yam li AutoComplete, qhov kev xaiv no tswj cov ntaub ntawv zoo li cas koj nkag rau hauv daim ntawv ua haujlwm.

Hauv qhov piv txwv hauv qab no, peb siv Flash Sau los tsim cov npe ntawm cov npe ntawm cov npe email chaw nyob uas twb muaj lawm.

1. Pib sau cov ntaub ntawv ntawm daim ntawv ua haujlwm. Thaum Flash Fill pom tus qauv, saib ua ntej ntawm cov kev xaiv tshwm hauv qab ntawm lub xov tooj tseem ceeb.
2. Nias Enter. Cov ntaub ntawv yuav muab ntxiv rau hauv daim ntawv.

Txhawm rau tshem tawm lossis hloov qhov tshwm sim ntawm Flash Fill qhov kev txiav txim, nyem rau ntawm lub cim ntse uas tshwm nyob ib sab ntawm cov nqi ntxiv tshiab.