Yuav ua li cas qhib kev txheeb xyuas kev sau ntawv hauv Excel

Cov neeg ua haujlwm hauv MS Word cov ntawv nyeem tau pom tias cov kab hauv qab liab tshwm li cas thaum cov lus tsis raug lossis raug ntaus ntawv. Hmoov tsis zoo, hauv daim ntawv thov MS Excel, xws li kev ua haujlwm tsis txaus. Nws yog qhov tseeb tias txhua yam ntawm cov ntawv luv luv, cov ntawv luv luv thiab lwm yam kev sau ntawm cov lus hauv daim ntawv hloov kho tuaj yeem ua rau qhov kev zov me nyuam yuam kev, thiab nws yuav cia li muab cov txiaj ntsig tsis raug. Txawm li cas los xij, qhov no muaj nuj nqi tam sim no, thiab koj tuaj yeem siv nws.

Teem hom lus rau

Autocorrection ntawm typos thiab cov lus tsis raug yog qhib los ntawm lub neej ntawd, tab sis qhov kev zov me nyuam muaj teeb meem ntawm kev txiav txim sib txawv. Thaum kuaj xyuas cov ntaub ntawv hauv hom tsis siv neeg, hauv 9 ntawm 10 tus neeg mob, qhov kev pab cuam cuam tshuam rau cov lus Askiv sau tsis raug. Vim li cas qhov no tshwm sim thiab yuav kho li cas, cia peb sim ua kom paub ntxiv:

1. Nyob rau sab saum toj ntawm lub vaj huam sib luag, nyem lub pob "Cov ntaub ntawv" thiab ua raws li "Kev xaiv" txuas.

2. Xaiv "Language" los ntawm cov npe ntawm sab laug.
3. Lub qhov rais teeb tsa lus tom ntej muaj ob qhov chaw. Hauv thawj "Xaiv Editing Languages" koj tuaj yeem pom tias tau teeb tsa los ntawm lub neej ntawd.

Yog tias, vim li cas, koj nyiam lus Askiv (USA) ua haujlwm nrog cov ntaub ntawv, tom qab ntawd koj yuav tsum tau hloov pauv los ntawm kev ua kom txoj kab nrog cov lus nyiam thiab nyem rau ntawm "Default" khawm uas teeb.

4. Tom ntej no, peb nqes mus rau cov khoom "Xaiv hom lus rau lub interface thiab pab". Ntawm no, los ntawm lub neej ntawd, raws li koj tuaj yeem pom, lub interface tau teeb tsa rau Microsoft Windows lus, thiab rau kev siv, cov lus interface.

5. Nws yog tsim nyog los ua ib tug hloov rau . Koj tuaj yeem ua nws hauv ib txoj hauv kev hauv qab no: nyem rau ntawm kab "" thiab nyem rau ntawm "Default" khawm hauv qab no, lossis nyem rau ntawm lub pob ua haujlwm nrog tus xub nqis.
6. Nws tsuas yog pom zoo los ntawm nyem rau ntawm "OK". Lub qhov rais yuav tshwm sim nrog kev pom zoo kom rov pib qhov kev pab cuam rau cov kev hloov pauv kom muaj txiaj ntsig. Peb pom zoo thiab reboot hauv phau ntawv hom.

Tom qab rov pib dua, qhov kev zov me nyuam yuav tsum tau ua cov lus tseem ceeb.

Dab tsi koj xav tau los pab kom sau ntawv hauv Excel

Qhov kev teeb tsa no tsis tiav, thiab koj yuav tsum ua ob peb kauj ruam ntxiv:

• Hauv daim ntawv thov qhib tshiab, mus rau "Cov Ntaub Ntawv" dua thiab qhib "Kev xaiv".
• Tom ntej no, peb txaus siab rau Spelling tool. Qhib lub qhov rais qhib los ntawm txhaj rau ntawm kab LMB.
• Peb pom cov kab "AutoCorrect Options ..." thiab nyem rau ntawm nws LMB.

• Peb mus rau lub qhov rais uas qhib, qhov twg koj yuav tsum qhib lub "AutoCorrect" kem (raws li txoj cai, nws yog activated thaum lub qhov rais qhib).
• Nyob rau hauv nqe lus "Qhia cov nyees khawm rau autocorrect xaiv" peb pom cov functionality suav nrog. Ntawm no, kom yooj yim ntawm kev ua hauj lwm nrog cov ntxhuav, nws raug nquahu kom lov tes taw ntau lub luag haujlwm, piv txwv li, "Ua thawj cov ntawv ntawm kab lus hauv cov ntawv loj" thiab "Sau cov npe hnub nrog tsab ntawv loj".

Kev piav qhia los ntawm tus kws tshaj lij! Txij li cov lus tsis muab rau kev sau cov hnub ntawm lub lim tiam nrog tsab ntawv loj, koj tuaj yeem uncheck kab no. Nws tseem tsim nyog sau cia tias kev sau thawj cov ntawv ntawm kab lus tsis muaj txiaj ntsig, vim tias kev ua haujlwm nrog cov lus suav nrog cov ntawv luv tas li. Yog tias koj tso lub cim kos rau ntawm cov khoom no, tom qab txhua lub ntsiab lus hauv lo lus luv luv, qhov program yuav hnov ​​​​mob thiab kho cov lus tsis raug.

Peb mus rau hauv qab no thiab pom tias nyob rau hauv lub qhov rais interface no kuj muaj ib daim ntawv teev cov lus autocorrect. Nyob rau sab laug, cov lus sib txawv ntawm cov lus sau tsis raug tau thov, thiab sab xis, cov kev xaiv los kho lawv. Tau kawg, daim ntawv teev npe no tsis tuaj yeem hu ua tiav, tab sis tseem muaj cov lus tseem ceeb tsis raug nyob hauv daim ntawv teev npe no.

Nyob rau sab saum toj muaj cov teb rau sau cov lus rau kev tshawb nrhiav. Piv txwv li, cia peb sau "tshuab". Qhov kev pab cuam yuav cia li qhia ib lo lus rau autocorrect nyob rau sab laug teb. Hauv peb qhov xwm txheej, qhov no yog "tshuab". Nws tseem muaj peev xwm hais tias lo lus yuav tsis nyob hauv phau ntawv txhais lus tau hais tseg. Tom qab ntawd koj yuav tsum nkag mus rau qhov raug sau ntawv manually thiab nyem rau ntawm "Ntxiv" khawm hauv qab no. Qhov no ua tiav cov kev teeb tsa, thiab koj tuaj yeem pib ua qhov kev tshuaj xyuas tsis siv neeg sau ntawv hauv Excel.

Khiav Automatic Spell Checker

Tom qab sau cov lus thiab sau tag nrho cov ntaub ntawv xav tau, nws yuav tsum tau kuaj xyuas cov ntawv sau. Txhawm rau ua qhov no, koj yuav tsum ua cov npe hauv qab no:

• Yog tias koj yuav tsum kuaj xyuas ib feem ntawm cov ntawv nyeem, ces xaiv qhov uas yuav tsum tau kuaj xyuas. Txwv tsis pub, tsis tas yuav tsum tau ua kom pom cov ntawv nyeem.
• Nyob rau sab saum toj ntawm qhov kev zov me nyuam, nrhiav cov cuab yeej Tshawb xyuas.
• Tom ntej no, hauv "Spelling" yam khoom, nrhiav "Spelling" khawm thiab nyem rau nws nrog LMB.

• Lub qhov rais yuav qhib qhov twg koj yuav raug hais kom mus txuas ntxiv kev tshuaj xyuas kev sau ntawv los ntawm qhov pib ntawm daim ntawv. Nyem qhov "Yes" khawm.
• Tom qab lub cuab yeej pom ib lo lus tsis raug, lub dialog box yuav tshwm nrog cov lus uas qhov kev zov me nyuam xav tias tsis raug.

• Hauv seem "Kev Xaiv", xaiv lo lus raug thiab nyem "Hloov" yog tias tsuas muaj ib lo lus hauv cov ntawv nyeem, lossis "Hloov Tag Nrho" yog tias nws zoo li cov lus xaiv tau tshwm sim ntau zaus.

Nco tseg los ntawm tus kws tshaj lij! Kuj xyuam xim rau lwm yam khoom nyob rau sab xis. Yog tias koj paub tseeb tias lo lus sau raug raug, koj yuav tsum xaiv "Skip" lossis "Skip tag nrho". Tsis tas li, yog tias koj paub tseeb tias lo lus tsis raug, koj tuaj yeem khiav "AutoCorrect". Hauv qhov no, qhov kev zov me nyuam yuav hloov tag nrho cov lus ntawm nws tus kheej. Muaj ib qho ntxiv "Ntxiv rau phau ntawv txhais lus". Nws yog qhov tsim nyog rau nws tus kheej ntxiv cov lus uas koj tuaj yeem sau tsis raug.

xaus

Txawm hais tias koj yog tus kws tshaj lij npaum li cas, koj tsis tuaj yeem paub tseeb ntawm qhov tseeb ntawm cov ntawv sau. Tib neeg qhov xwm txheej cuam tshuam nrog qhov kev xav ntawm ntau yam kev ua yuam kev. Tshwj xeeb tshaj yog rau cov ntaub ntawv no, MS Excel muaj cov cuab yeej tshawb xyuas spell, los ntawm kev khiav uas koj tuaj yeem kho cov lus tsis raug.