Tsawg tus neeg yuav nyiam sau cov ntaub ntawv qub lossis zoo sib xws hauv lub rooj rau ib lub sijhawm ntev thiab monotonously. Nov yog ib txoj haujlwm tsis dhuav, siv sijhawm ntau. Excel muaj qhov peev xwm automate tawm tswv yim ntawm cov ntaub ntawv no. Rau qhov no, ua tiav autocomplete ntawm lub hlwb yog muab. Saib seb nws ua haujlwm li cas.
Autofill hauj lwm hauv Excel
Kev kawm tiav hauv Microsoft Excel yog ua tiav siv cov cim sau cim tshwj xeeb. Txhawm rau hu qhov cuab yeej no, koj yuav tsum tau yuj nws qes dua sab ntug ntawm txhua qhov chaw ntawm tes. Tus ntoo khaub lig dub me me yuav tshwm sim. Nov yog tus cim kos cim. Koj tsuas yog yuav tsum tuav lub pob nyem lawm thiab cab mus rau ib sab ntawm daim ntawv uas koj xav sau lub hlwb.
Yuav ua li cas cov hlwb yuav tau populated twb nyob ntawm hom ntawm cov ntaub ntawv uas yog nyob rau hauv thawj cell. Piv txwv li, yog tias muaj cov ntawv sau yooj yim hauv daim ntawv ntawm cov lus, tom qab ntawd thaum koj rub siv lub cim sau, nws theej rau lwm lub hlwb hauv daim ntawv.
Lub hlwb ua kom tiav nrog cov lej
Feem ntau, autocomplete yog siv los nkag rau coob ntawm cov xov tooj uas ua raws li hauv kev txiav txim. Piv txwv, hauv qee lub cell muaj tus lej 1, thiab peb yuav tsum muaj cov lej ntawm 1 txog 100.
- Peb qhib lub cim sau thiab kos nws nqes mus rau cov naj npawb ntawm cov xov tooj uas yuav tsum muaj.
- Tab sis, raws li peb pom, tsuas yog ib qho tau theej tau txhua lub hlwb. Peb nyem rau ntawm lub cim, uas nyob rau hauv qab sab laug ntawm thaj chaw thiab hu ua "Autocomplete Xaiv".
- Hauv cov npe uas qhib, teeb tsa tus tes hloov mus Sau.
Raws li koj tuaj yeem pom, tom qab ntawd, tag nrho cov kev xav tau tau puv nrog cov lej hauv kev txiav txim.
Tab sis koj tuaj yeem ua rau nws yooj yim dua. Koj yuav tsis tas yuav hu rau cov kev xaiv uas ua tiav. Ua li no, thaum koj rub lub cim sau cia, ntxiv rau sab laug nas khawm, koj yuav tsum tau tuav dua lwm lub pob Xuas ntawm cov keyboard. Tom qab ntawd, sau cov hlwb nrog cov lej nyob rau hauv kev txiav txim tshwm sim sai.
Kuj tseem muaj txoj hauv kev ua kom tiav autocom tiav hauv cov kev kawm nce qib.
- Peb coj mus rau hauv cov cell nyob sib ze thawj ob tus lej ntawm qhov muaj mob.
- Xaiv lawv. Siv tus cim sau cim, peb sau cov ntaub ntawv mus rau hauv lwm lub hlwb.
- Raws li koj tuaj yeem pom, ib ntu ntawm cov lej yog tsim nrog cov kauj ruam uas muab.
Sau cov twj
Excel kuj muaj ib qho cuab yeej sib txawv hu ua SauCov. Nws nyob rau ntawm cov xov hauv cov ntawv sau "Tsev" hauv lub thawv "Editing".
- Peb nkag mus rau cov ntaub ntawv hauv ib qho ntawm tes, thiab tom qab ntawd xaiv nws thiab qhov ntau ntawm cov hlwb uas peb yuav sau.
- Nyem rau feem khawm SauCov. Hauv cov npe uas tshwm sim, xaiv cov kev taw qhia uas lub hlwb yuav tsum tau sau.
- Raws li koj tuaj yeem pom, tom qab cov yeeb yam no, cov ntaub ntawv los ntawm ib lub xov tooj tau theej theej rau tag nrho lwm tus.
Siv cov cuab yeej no, koj tuaj yeem sau cov hlwb nrog qhov muaj mob.
- Nkag mus rau tus naj npawb hauv lub cell thiab xaiv qhov ntau ntawm cov hlwb uas yuav sau nrog cov ntaub ntawv. Nyem rau "Sau" khawm, thiab hauv cov npe uas tshwm, xaiv "Kev vam meej".
- Cov txheej txheem ua tau qhib lub qhov rai qhib. Ntawm no koj yuav tsum ua kom muaj kev sib kho:
- xaiv qhov chaw ntawm qhov muaj mob (hauv kab lossis hauv kab);
- ntaus ntawv (geometric, xam, hnub tim, pib tiav-tiav);
- teeb cov kauj ruam (los ntawm neej ntawd hais nws yog 1);
- teeb tus nqi tus nqi txwv (tsis xav ua lwm tus).
Ib qho ntxiv, qee qhov xwm txheej, teeb tsa chav teeb tsa.
Thaum txhim kho txhua lub sijhawm, nyem rau ntawm lub pob "OK".
- Raws li koj tuaj yeem pom, tom qab ntawd xaiv tag nrho ntawm cov hlwb raug sau raws li cov cai ntawm kev nce qib uas tsim los ntawm koj.
AutoFill Cov Qauv
Ib qho ntawm cov cuab yeej tseem ceeb ntawm Excel yog cov qauv. Yog tias muaj coob leej ntawm cov qauv hauv lub rooj, koj tuaj yeem siv lub autofill muaj nuj nqi. Cov ntsiab lus tsis hloov. Koj yuav tsum luam cov mis tawm mus rau lwm lub hlwb ntawm qhov sib xws nrog lub cim sau. Ntxiv mus, yog tias tus qauv muaj qhov txuas mus rau lwm lub hlwb, tom qab ntawd los ntawm lub sijhawm thaum luam tawm ntawm txoj kev no, lawv cov kev hloov pauv hloov mus raws li lub hauv paus ntsiab lus ntawm kev sib raug zoo. Yog li, cov ntawv sib txuas no hu ua txheeb ze.
Yog tias koj xav tau cov chaw nyob ua tsau thaum sau tiav, tom qab ntawd koj yuav tsum tso duas las rau hauv lub xov tooj qub nyob rau ntawm sab xub ntiag ntawm kab ke thiab kab ntawv. Cov kev sib txuas no hu ua tsis muaj tseeb. Tom qab ntawd, cov kev ua tiav autofill ib txwm ua tiav siv cov cim sau rau. Hauv txhua lub hlwb sau rau txoj kev no, tus qauv yuav hloov pauv tsis txawv kiag li.
Tshooj: Kev Tsis Txaus Siab thiab cov txheeb ze txuas hauv Excel
Autocomplete nrog rau lwm cov nqi
Ntxiv rau, Excel muab kev pib ua tiav nrog lwm cov nqi hauv qhov kev txiav txim. Piv txwv, yog tias koj sau hnub tim, thiab tom qab ntawd, siv lub cim sau, xaiv lwm lub hlwb, tom qab ntawd txhua kab lus xaiv yuav raug sau nrog cov hnub tim nyob rau hauv cov txheej txheem nruj.
Nyob rau hauv tib txoj kev, koj tuaj yeem autofill los ntawm hnub ntawm lub lim tiam (Monday, Tuesday, Wednesday ...) lossis los ntawm lub hli (Lub Ib Hlis, Lub Ob Hlis, Peb Hlis ...).
Ntxiv mus, yog tias muaj ib tus lej hauv cov ntawv, Excel yuav paub nws. Thaum siv tus cim sau, tus kab lus yuav muab theej nrog tus lej nce zuj zus. Piv txwv li, yog tias koj sau kab lus "4 lub tsev" hauv lub xovtooj ntawm, tom qab ntawd hauv lwm lub hlwb uas muaj tus cim sau, lub npe no yuav hloov mus ua "5 lub tsev", "6 lub tsev", "7 lub tsev", thiab lwm yam.
Ntxiv Koj Cov Ntawv Sau Npe
Cov yam ntxwv ntawm kev ua tiav ntawm tsis tiav hauv Excel tsis txwv rau qee cov algorithms lossis cov npe tau teev tseg, xws li, piv txwv, hnub ntawm lub limtiam. Yog tias xav tau, tus neeg siv tau nws tus kheej daim ntawv sau rau hauv qhov program. Tom qab ntawv, thaum sau ntawv mus rau lub cell ib lo lus los ntawm cov ntsiab lus uas muaj nyob rau hauv cov npe, tom qab thov daim cim cim sau tseg, cov npe no yuav sau tag nrho cov xaiv ntau ntawm cov hlwb. Txhawm rau ntxiv rau koj daim ntawv teev npe, koj yuav tsum ua kab ke ntawm no.
- Peb ua kev hloov pauv mus rau tab Cov ntaub ntawv.
- Mus rau ntu "Xaiv".
- Tom ntej no, tsiv mus rau seem "Tshaj".
- Hauv cov chaw thaiv "General" nyob rau hauv nruab nrab ib feem ntawm lub qhov rais nyem khawm "Hloov npe ...".
- Lub npe kem qhib. Nyob rau hauv nws cov seem yog twb muaj npe. Txhawm rau ntxiv rau ib daim ntawv teev npe tshiab, sau cov lus tsim nyog hauv daim teb Sau cov khoomCov. Txhua yam khoom yuav tsum tau pib ntawm txoj kab tshiab. Tom qab txhua lo lus yog sau, nyem rau ntawm lub pob Ntxiv.
- Tom qab ntawd, cov npe qhov rais kaw lawm, thiab thaum nws qhib dua, tus neeg siv yuav tuaj yeem pom cov ntsiab lus uas nws tau ntxiv rau hauv lub qhov rai ua haujlwm nquag.
- Tam sim no, tom qab koj ntxig lo lus rau hauv ib qho ntawm tes ntawm daim ntawv uas yog ib qho ntawm cov ntsiab lus ntawm daim ntawv teev npe ntxiv thiab siv cov cim sau, tus xaiv ntawm lub hlwb yuav tau sau nrog cov cim los ntawm cov ntawv sau.
Raws li koj tuaj yeem pom, Excel lub autocomplete yog qhov siv tau thiab siv tau yooj yim uas tuaj yeem txuag lub sijhawm ntawm ntxiv cov ntaub ntawv tib, cov ntawv theej tawm, thiab lwm yam. Qhov zoo ntawm lub cuab yeej no yog tias nws tuaj yeem tsim tau. Koj tuaj yeem ntxiv cov npe tshiab rau nws lossis hloov cov tshiab. Ib qho ntxiv, siv autocomplete, koj tuaj yeem muab cov hlwb nrawm nrog ntau hom kev kawm ntawm kev ua lej.
