AutoCorrect hauv Excel. Yuav ua li cas pab, lov tes taw thiab configure

Thaum siv daim ntawv nthuav dav, ntau tus neeg siv, ua haujlwm nrog ntau cov ntaub ntawv, ua ntau yam yuam kev hauv kev suav lossis ua typos. Tsis tas li ntawd, qee tus neeg tsis paub yuav ua li cas ntxiv cov cim tshwj xeeb thiab siv lwm cov cim uas tsis cuam tshuam nrog kev ua haujlwm. Qhov kev zov me nyuam muaj qhov tshwj xeeb hu ua "AutoCorrect", uas tso cai rau koj los kho cov ntaub ntawv nkag tsis raug.

Dab tsi yog "AutoCorrect"

Excel spreadsheet processor khw muag khoom hauv nws tus kheej lub cim xeeb ntau yam yuam kev los ntawm cov neeg siv thaum ua haujlwm nrog cov ntaub ntawv tabular. Yog tias tus neeg siv ua qhov yuam kev, qhov program yuav cia li kho nws kom raug qhov tseem ceeb. Tag nrho cov no tau ua tiav ua tsaug rau cov cuab yeej AutoCorrect. Lub auto-replacement feature kho cov kev ua yuam kev hauv qab no:

• yuam kev vim yog suav nrog Caps Lock;
• pib nkag mus rau ib kab lus tshiab nrog ib tsab ntawv me me;
• ob daim ntawv loj nyob rau hauv ib kab hauv ib lo lus;
• lwm yam yuam kev thiab typos ua los ntawm cov neeg siv.

Qhov chaw tso chaw

Nco ntsoov tias nws pib hloov pauv thiab Nrhiav thiab Hloov cov cuab yeej yog ob qho kev xaiv sib txawv. Hauv thawj lub cuab yeej, daim ntawv nthuav qhia nws tus kheej txheeb xyuas cov ntawv ntaus ntawv thiab siv qhov hloov pauv, thiab hauv qhov thib ob, txhua qhov kev hloov pauv tau ua los ntawm tus neeg siv ua haujlwm hauv daim ntawv nthuav qhia.

Tag nrho cov npe ntawm cov kab lus hloov pauv yog nyob hauv Excel chaw. Txhawm rau saib cov txiaj ntsig no, ua raws cov kauj ruam yooj yim no:

1. Peb nyem rau ntawm lub pob loj nyob rau sab laug sab laug ntawm lub interface, thiab tom qab ntawd nyem rau ntawm "Settings" keeb.

2. Hauv qhov rai uas tshwm, nyem rau ntawm kab "Spelling" thiab txav mus rau cov ntawv qhia zaub mov rau kev hloov pauv tsis siv neeg.

3. Hauv lub qhov rais tshiab uas tshwm ntawm qhov screen, koj tuaj yeem saib cov haujlwm tsis ua haujlwm. Kuj tseem muaj cov lus piv txwv ntawm kev hloov cov cim lossis cov lus.

Nco ntsoov tias qhov chaw ntawm qhov kev ua haujlwm no zoo ib yam nyob rau hauv tag nrho cov versions, tsuas yog qee qhov kev nkag mus rau qhov tsis muaj pib nrog nyem rau ntawm "Cov Ntaub Ntawv" keeb.

Nrhiav cov ntsiab lus

Cia peb ua tib zoo saib yuav ua li cas tshawb nrhiav cov ntsiab lus hauv ib daim ntawv. Kev taug kev:

1. Mus rau ntu "Kho kom raug", thiab tom qab ntawd nyem rau ntawm "Nrhiav" khawm. Koj tuaj yeem nkag mus rau lub qhov rais no los ntawm nias qhov tseem ceeb ua ke "Ctrl + F".

2. Hauv kab "Nrhiav" koj yuav tsum sau tus nqi uas koj xav pom hauv daim ntawv. Tom qab nkag mus rau cov ntaub ntawv, nyem "Nrhiav Tom ntej". Hauv lub qhov rais, muaj ntau yam kev tshawb nrhiav ntxiv nyob rau hauv ntu "Kev xaiv".

Nws yuav tsum nkag siab tias yog tias koj nyem lub pob "Nrhiav Tom ntej", qhov kev zov me nyuam yuav tso cov kab lus uas ze tshaj plaws thiab qhia nws hauv daim ntawv. Siv lub "Nrhiav Txhua" muaj nuj nqi tso cai rau koj los tso saib tag nrho cov kev tshawb nrhiav qhov tseem ceeb uas muaj nyob hauv daim ntawv.

Qauv hloov

Nws feem ntau tshwm sim tias tus neeg siv yuav tsum tsis tsuas yog nrhiav cov kab lus hauv cov ntaub ntawv, tab sis kuj hloov nws nrog lwm cov ntaub ntawv. Kauj ruam los ntawm kauj ruam qhia los ua qhov haujlwm no:

1. Mus rau lub thawv tshawb nrhiav raws li tau piav qhia saum toj no.

2. Tam sim no peb tsiv mus rau ntu hu ua "Hloov".
3. Muaj ib txoj kab tshiab "Hloov nrog". Hauv kab "Nrhiav" peb tsav hauv kab lus rau kev tshawb nrhiav, thiab hauv kab "Hloov nrog", peb tsav hauv tus nqi uas peb xav hloov cov khoom seem. Los ntawm kev txav mus rau ntu "Kev Xaiv", koj tuaj yeem siv ntau yam kev tshawb nrhiav cov ntxaij lim dej kom nrawm ua haujlwm nrog cov ntaub ntawv.

Pab thiab lov tes taw autocorrect

Los ntawm lub neej ntawd, qhov hloov pauv tsis siv neeg hauv daim ntawv nthuav qhia tau qhib. Muaj cov xwm txheej thaum nws yuav tsum tau muab tua kom thaum nkag mus rau cov ntaub ntawv, qhov kev zov me nyuam tsis pom qee cov cim ua yuam kev. Kauj ruam-by-step qhia rau lov tes taw tsis siv neeg hloov:

1. Mus rau ntu "Cov ntaub ntawv".

2. Hauv cov npe sab laug ntawm cov ntsiab lus, xaiv "Settings".

3. Hauv cov kev xaiv qhov rai uas tshwm, xaiv "Spelling" seem. Tom ntej no, nyem rau ntawm AutoCorrect Options.

4. Lub qhov rais tshiab tshwm nrog cov kev teeb tsa parameter. Ntawm no koj yuav tsum tau uncheck lub thawv nyob ib sab ntawm lub inscription "Hloov raws li koj ntaus ntawv", thiab ces nias "OK".

5. Daim ntawv tshaj tawm yuav coj tus neeg siv mus rau lub qhov rais dhau los, uas koj yuav tsum nyem "OK" dua.

Mloog! Txhawm rau rov ua kom muaj nuj nqi, koj yuav tsum xa rov qab cov ntawv cim ntawm ib sab ntawm cov ntawv sau "Hloov li koj ntaus" thiab nyem "OK".

Hnub autocorrect thiab muaj teeb meem tshwm sim

Muaj qee lub sij hawm thaum tus neeg siv tsav tsheb hauv cov ntaub ntawv xov xwm nrog cov dots, thiab cov ntawv nthuav qhia nws tus kheej hloov nws mus rau hnub tim. Txhawm rau khaws cov ntaub ntawv qub hauv lub xov tooj yam tsis muaj kev hloov pauv, koj yuav tsum ua cov kauj ruam yooj yim hauv qab no:

1. Peb ua ib qho kev xaiv ntawm ntau lub hlwb uas peb npaj los sau cov ntaub ntawv xov xwm nrog cov dots. Mus rau ntu "Tsev", thiab tom qab ntawd txav mus rau "Number" tab. Nyem rau ntawm qhov kev hloov pauv ntawm tes tam sim no.

2. Ib daim ntawv me me nrog ntau hom tau raug nthuav tawm. Nyem "Text".

3. Tom qab kev tswj hwm, koj tuaj yeem nkag mus rau hauv cov ntaub ntawv hauv cov hlwb uas siv cov dots.

Nws yog ib qho tseem ceeb kom nkag siab tias cov ntaub ntawv xov xwm hauv hlwb nrog cov ntawv nyeem yuav tsis raug ua tiav los ntawm qhov kev pab cuam raws li cov lej.

Autocorrect nrog lej cim

Tam sim no cia saib yuav ua li cas cov txheej txheem ntawm kev hloov pauv tsis siv neeg nrog cov cim lej ua tiav. Ua ntej koj yuav tsum mus rau qhov "AutoCorrect" qhov rai, thiab tom qab ntawd mus rau "AutoCorrect with Mathematical Symbols" section. Qhov no feature yog ke thiab pab tau raws li ntau cov cim lej tsis nyob ntawm cov keyboard. Piv txwv li, txhawm rau tso saib cov duab ntawm lub kaum sab xis hauv lub xov tooj ntawm tes, koj tsuas yog yuav tsum nkag mus rau lub kaum sab xis hais kom ua.

Daim ntawv teev lej uas twb muaj lawm tuaj yeem ntxiv nrog tus kheej qhov tseem ceeb. Txhawm rau ua qhov no, sau koj cov lus txib hauv thawj daim teb, thiab cov cim uas yuav tshwm sim thaum sau cov lus txib no hauv daim teb thib ob. Thaum kawg, nyem qhov "Ntxiv" khawm, thiab tom qab ntawd "OK".

Hloov kho cov phau ntawv txhais lus autocorrect

Lub luag haujlwm tseem ceeb ntawm kev hloov pauv tsis siv neeg yog txhawm rau kho typos thiab yuam kev hauv cov ntaub ntawv nkag los ntawm tus neeg siv. Ib phau ntawv txhais lus tshwj xeeb tau muab tso rau hauv cov ntawv sau ua ke, uas muaj cov npe ntawm cov lus thiab cov cim rau kev hloov pauv tsis siv neeg. Koj tuaj yeem ntxiv koj tus kheej cov txiaj ntsig tshwj xeeb rau phau ntawv txhais lus no, uas yuav yooj yim heev rau kev ua haujlwm nrog cov txheej txheem spreadsheet. Kev taug kev:

1. Peb txav mus rau lub qhov rais nrog cov tsis siv neeg hloov pauv, siv cov txheej txheem tau piav qhia saum toj no.
2. Hauv kab "Hloov", koj yuav tsum nkag mus rau tus cim lossis lo lus, uas yav tom ntej tus txheej txheem txheej txheem yuav ua qhov yuam kev. Hauv kab "On" koj yuav tsum nkag mus rau tus nqi uas yuav siv los hloov qhov yuam kev. Tom qab nkag mus rau tag nrho cov ntaub ntawv tsim nyog, nyem "Add".

3. Ib yam li ntawd, koj tuaj yeem ntxiv koj tus kheej qhov tseem ceeb los ntawm phau ntawv txhais lus, kom tom qab ntawd koj tsis txhob nkim sijhawm kho lawv.

Txhawm rau tshem tawm cov txiaj ntsig tsis tsim nyog los ntawm daim ntawv teev npe hloov pauv tsis siv neeg, koj tsuas yog yuav tsum xaiv qhov tsis tsim nyog ua ke, thiab tom qab ntawd nyem "Delete". Los ntawm kev xaiv tus nqi, koj tuaj yeem tsis tsuas yog rho tawm, tab sis kuj hloov nws.

Teem lub ntsiab autocorrect xaiv

Cov yam ntxwv tseem ceeb suav nrog txhua qhov tsis muaj nyob hauv ntu "AutoCorrect". Los ntawm lub neej ntawd, daim ntawv nthuav qhia suav nrog hom kev kho kom raug pom hauv daim duab:

Txhawm rau tua ib qho kev txwv, koj tsuas yog yuav tsum tau tshem lub thawv ntawm nws, thiab tom qab ntawd, txhawm rau txuag cov kev hloov pauv nkag, nyem "OK".

Ua haujlwm nrog kev zam

Daim ntawv tshaj tawm muaj cov lus tshwj xeeb tshwj xeeb uas tso cai rau koj kom paub tseeb tias tsis siv neeg hloov pauv tsis siv rau cov txiaj ntsig suav nrog hauv phau ntawv txhais lus no. Kauj ruam-by-step qhia ua hauj lwm nrog phau ntawv txhais lus:

1. Hauv "AutoCorrect", nyem rau ntawm "Exceptions".

2. Muaj ob ntu ntawm no. Thawj ntu yog "Tsab Ntawv Thawj". Nqe lus no piav qhia txog txhua yam txiaj ntsig tom qab uas "lub sijhawm" tsis pom los ntawm qhov kev pab cuam raws li qhov kawg ntawm kab lus. Hauv lwm lo lus, tom qab nkag mus rau ib lub sijhawm, lo lus tom ntej yuav pib nrog tsab ntawv me. Txhawm rau ntxiv koj tus kheej qhov tseem ceeb, koj yuav tsum nkag mus rau lo lus tshiab hauv kab saum toj kawg nkaus, thiab tom qab ntawd nyem "Ntxiv". Yog tias koj xaiv ib qho taw qhia los ntawm cov npe, koj tuaj yeem kho nws lossis tshem tawm nws.

3. Qhov thib ob yog "Ob lub peev". Ntawm no, raws li nyob rau hauv lub tab yav dhau los, koj tuaj yeem ntxiv koj tus kheej qhov tseem ceeb, nrog rau kev kho thiab tshem tawm lawv.

Excel Version Qhov txawv

Tag nrho cov lus qhia saum toj no yog siv rau 2007, 2010, 2013, thiab 2019 spreadsheet processors. Hauv xyoo 2003 editor, cov txheej txheem rau kev teeb tsa kev hloov pauv tsis siv neeg yog ua nyob rau hauv ib txoj kev sib txawv, thiab cov ntsiab lus tseem ceeb nyob rau hauv qhov chaw sib txawv kiag li. Kev taug kev:

1. Nyem rau ntawm "Service" seem.
2. Nyem rau ntawm qhov "Settings" element.

3. Txav mus rau Spelling tab.

4. Muaj peb txoj kev xaiv rau kev teeb tsa tsis siv neeg hloov pauv.

5. Txhawm rau hloov pauv hloov pauv hloov pauv, nyem rau ntawm "AutoCorrect Options" caij.

6. Lub qhov rais uas paub zoo yuav tshwm. Tsis muaj kev teeb tsa ntawm cov cim lej, vim tias txhua qhov ntsuas tau nyob hauv ib qho chaw. Peb ua txhua yam tsim nyog hloov pauv thiab nyem lub pob "OK".

Kev qhia video

Yog tias tag nrho cov lus qhia saum toj no tsis txaus, koj tuaj yeem saib cov yees duab hauv qab no:

Nws qhia txog tag nrho cov nuances ntxiv rau phau ntawv. Tom qab saib cov vis dis aus, koj yuav kawm ntau cov ntaub ntawv ntxiv uas yuav tso cai rau koj los daws txhua yam teeb meem thaum ua haujlwm nrog kev hloov pauv tsis siv neeg hauv daim ntawv nthuav qhia.

xaus

Qhov kev hloov pauv tsis siv neeg tso cai rau koj kom ceev cov txheej txheem ua haujlwm nrog cov ntaub ntawv tabular. Cov cuab yeej siv tau zoo tshaj plaws thaum ua haujlwm nrog ntau cov ntaub ntawv. Nws yog ib qho tseem ceeb heev uas yuav tsum muaj peev xwm siv tau thiab teeb tsa qhov muaj txiaj ntsig zoo no.