Microsoft Excel AutoCorrect feature

Thaum ntaus ntawv nyob rau hauv ntau cov ntaub ntawv, koj tuaj yeem ua ib hom ntawv lossis ua yuam kev tawm ntawm kev tsis paub. Tsis tas li ntawd, qee cov cim ntawm cov keyboard yuav tsis tuaj yeem tsis tuaj, tab sis tsis yog txhua leej txhua tus paub siv cov cim tshwj xeeb, thiab siv lawv li cas. Yog li ntawd, cov neeg siv hloov cov paib no nrog cov cuab kev feem ntau, hauv lawv lub tswv yim, analogues. Piv txwv, es tsis txhob "©" lawv sau "(c)", thiab tsis yog "€" - (e). Zoo hmoo, Microsoft Excel muaj kev AutoCorrect kev ua haujlwm uas tau hloov cov piv txwv saum toj no nrog cov kev sib tw kom yog, thiab tseem kho cov feem ntau tsis raug thiab typos.

Cov cai ntawm AutoCorrect

Excel programme nco cov khoom ua yuam kev tshaj plaws hauv kev sau cov lus. Txhua lo lus zoo li no yog matched nrog cov lus tseeb. Yog hais tias tus neeg siv nkag mus rau qhov kev xaiv tsis yog, vim yog lub hom ntawv lossis qhov yuam kev, ces daim ntawv thov no yuav muab hloov nrog qhov tseeb. Qhov no yog qhov tseem ceeb ntawm kev hloov pib.

Lub ntsiab yuam kev uas muaj qhov ua haujlwm kho tshiab muaj xws li cov hauv qab no: pib ua ib kab lus nrog ib tsab ntawv tsawg dua, ob tsab ntawv loj hauv ib lo lus, ua qhov tsis zoo Caps lock, ib tug xov tooj ntawm lwm yam typos typos thiab cov teeb meem.

Tawm thiab tso cai rau AutoCorrect

Nws yuav tsum tau muab sau tseg tias yog vim, AutoCorrect yeej ib txwm siv. Yog li, yog tias koj niaj hnub los sis ib ntus tsis xav tau qhov kev ua no, ces nws yuav tsum tau ua yuam kev tsis taus. Piv txwv, qhov no tuaj yeem tshwm sim los ntawm qhov tseeb tias koj feem ntau yuav tsum sau cov lus ua yuam kev, los yog qhia cov cim uas tau cim tias Excel ua kev tsis sib haum, thiab pib-hloov kho tsis tu ncua. Yog tias koj hloov lub cim uas kho ntawm qhov pib hloov mus rau qhov koj xav tau, ces qhov kev hloov tsheb yuav tsis kho dua. Tab sis, yog tias muaj ntau lub tswv yim zoo, tom qab ntawd sau nws ob zaug, koj plam lub sij hawm. Nyob rau hauv cov ntaub ntawv no, nws yog zoo dua rau ib ntus lov nws pib AutoCorrect zoo rau nws.

  1. Mus rau lub tab "Cov Ntaub Ntawv";
  2. Xaiv ib seem "Kev xaiv".
  3. Tom ntej no, mus rau seem "Sau".
  4. Ndliv lub khawm "AutoCorrect Options".
  5. Hauv qhov ntsuas tsis tau qhib qhov rooj, saib qhov khoom "Hloov thaum koj ntaus ntawv". Tshem tawm thiab nyem rau ntawm lub pob. "OK".

Yuav kom rov pab tus AutoCorrect, ntsig txog, kos lub thawv thiab nias lub pob dua. "OK".

Teeb meem nrog autostart hnub

Muaj qee zaum thaum tus neeg siv nkag mus rau hauv tus lej, thiab nws raug kho rau hnub tim, tab sis nws tsis xav tau nws. Nyob rau hauv cov ntaub ntawv no, nws tsis yog nyob rau hauv tag nrho cov tsim nyog yuav tau ua rau tag nrho lov tes taw autochange. Txhim kho qhov no, xaiv thaj chaw ntawm cov hlwb uas peb yuav sau cov lej nrog cov dots. Hauv tab "Tsev" Peb tab tom nrhiav ib qho chaw ntawm qhov chaw "Tooj". Hauv daim ntawv teev npe ntawm qhov chaw nyob ntawm no, muab cov parameter rau "Cov ntawv nyeem".

Tam sim no cov zauv nrog cov dots yuav tsis muab hloov nrog cov hnub.

Kho cov ntawv AutoCorrect

Tab sis tseem, lub ntsiab tseem ceeb ntawm qhov cuab yeej no yog tsis cuam tshuam nrog tus neeg siv, tab sis, theej los pab nws. Ntxiv nrog rau cov kab lus ntawm cov kab lus uas tsim los rau kev hloov pib los ntawm lub neej, txhua tus neeg siv tau ntxiv rau lawv cov kev xaiv.

  1. Qhib lub qhov rais ntawm cov lus AutoCorrect twb paub txog peb lawm.
  2. Hauv teb "Hloov" hais kom meej txog cov cim txheej uas yuav tau ntaus nqi los ntawm qhov kev zov me nyuam ua yuam kev. Hauv teb "Rau" Peb sau lo lus los yog lub cim los hloov. Peb nias lub khawm "Ntxiv".

Yog li, koj tuaj yeem ntxiv koj cov kev xaiv rau cov lus txhais lus.

Tsis tas li, nyob rau hauv tib lub qhov rais muaj ib tab "AutoCorrect Mathematical Cim". Ntawm no yog ib daim ntawv teev npe ntawm qhov tseem ceeb thaum nkag mus rau qhov hloov nrog cov cim lej, nrog rau cov siv hauv Excel qauv. Xwb, tsis yog txhua tus neeg siv yuav nkag mus rau lub cim (alpha) ntawm cov keyboard, tab sis txhua tus neeg yuav nkag mus rau tus nqi " alpha ", uas yuav tau hloov dua siab tshiab rau tus xeeb ceem. Los ntawm analogy, beta ( beta), thiab lwm yam cim tau sau tseg. Nyob rau tib daim ntawv, txhua tus neeg siv tau ntxiv tau lawv tus kheej cov khub, ib yam li nws tau qhia nyob rau hauv phau ntawv txhais lus tseem ceeb.

Nws kuj yog ib qho yooj yim heev rau tshem tawm cov xov xwm hauv phau ntawv no. Xaiv cov khoom uas peb tsis xav hloov automatic, thiab nias lub khawm "Rho tawm".

Deletion yuav tsum tau ua instantly.

Yeej tsis yooj yim

Nyob rau hauv lub ntsiab tab ntawm qhov kev hloov fab ntawv yog cov chaw ntawm qhov kev ua no. Los ntawm kev pom tseeb, cov kev khiav dej num hauv qab no muaj xws li: kho ob nqe lus loj ua ke, teem thawj tsab ntawv hauv kab lus loj, cov npe ntawm cov hnub ntawm lub limtiam nrog ib tsab ntawv loj, Caps lock. Tab sis, tag nrho cov kev ua haujlwm, nrog rau qee yam ntawm lawv, tuaj yeem muab tua los ntawm kev txiav cov kev xaiv ntsees thiab nias lub khawm. "OK".

Tsis suav

Ntxiv mus, AutoCorrect feature nws muaj nws cov phau ntawv txhais lus tshwj. Nws muaj cov lus thiab cov cim uas yuav tsum tsis txhob hloov, txawm tias txoj cai muaj nyob hauv cov chaw dav dav, uas txhais tau hais tias cov lus los yog cov lus hais raug muab hloov.

Mus rau phau ntawv txhais lus no nyem rau ntawm khawm. "Tsuas yog ...".

Qhov kev zam lub qhov rais qhib. Raws li koj tau pom, nws muaj ob tabs. Nyob rau hauv thawj ntawm lawv yog cov lus, tom qab uas lub ntsiab lus tsis txhais hais tias qhov kawg ntawm ib kab lus, thiab qhov tseeb tias lo lus tom ntej yuav tsum pib nrog ib tus ntawv loj. Cov no yog ntau yam abbreviations (piv txwv, "rub."), ​​Los yog cov seem ntawm cov kab lus taag.

Qhov thib ob tab muaj qhov tsis suav, uas koj tsis tas yuav hloov ob daim ntawv loj ua ke. Los ntawm kev ua neej, ib lo lus uas tau hais hauv nqe lus no ntawm phau ntawv txhais lus yog "CCleaner". Tab sis, koj tuaj yeem ntxiv ib qho xov tooj ntawm cov lus thiab kab zauv, tsis suav cov kev hloov ntawm kev hloov tsheb, hauv tib txoj kev uas tau tham txog saum toj no.

Raws li koj pom tau, AutoCorrect yog ib qho cuab yeej siv los pab kho kom raug lossis yuam kev ua thaum uas nkag mus rau lo lus, cim lossis kab lus hauv Excel. Thaum tsim kho kom zoo, qhov kev ua no yuav yog ib tus neeg pabcuam zoo, thiab nws yuav txuag lub sijhawm rau kev kuaj thiab kho cov kev ua yuam kev.