Cov chav kawm ntxiv hauv cov ntawv nyeem tsis xim xim twg. Tshwj xeeb yog lawv tsis tas yuav tsum raug tso cai hauv cov rooj ntawv uas tau muab rau kev tswj lossis cov pej xeem. Tab sis txawm tias koj yuav siv cov ntaub ntawv no rau koj tus kheej cov hom phiaj, cov nrauj ntxiv yuav pab txhawb qhov loj ntawm daim ntawv, uas yog qhov tsis zoo. Tsis tas li ntawd, lub xub ntiag ntawm cov ntsiab lus tsis tseem ceeb ua rau nws yooj yim mus tshawb cov ntaub ntawv, kev siv cov ntxaij lim dej, kev siv sorting thiab lwm yam cuab yeej. Cia peb kawm saib koj yuav ua li cas sai sai thiab tshem tawm.
Tshooj: Tshem cov chaw loj hauv Microsoft Word
Gap tshem tawm tshuab
Tam sim ntawd kuv yuav tsum hais tias qhov chaw hauv Excel ua tau ntau hom. Cov no tuaj yeem yog qhov chaw ntawm cov lus, qhov chaw pib ntawm tus nqi thiab thaum kawg, cov neeg cais ntawm cov kab zauv ntawm cov kab zauv, thiab lwm yam. Li no, qhov algorithm rau lawv tshem tawm ntawm cov no yog txawv.
Method 1: Siv Daim Hlev Tawm
Lub cuab yeej ua hauj lwm zoo tshaj ntawm kev hloov ob chav chaw nyob ntawm cov lus uas muaj tib yam hauv Excel "Hloov".
- Nyob hauv tab "Tsev", nyem rau ntawm lub pob "Nrhiav thiab pom tseeb"uas yog nyob rau hauv lub cuab yeej thaiv Editing ntawm daim kab xev. Hauv daim ntawv teev npe, xaiv qhov khoom "Hloov". Koj tuaj yeem siv qhov kev ua haujlwm saum toj no xwb ntaus cov keyboard shortcut Ctrl + H.
- Nyob rau hauv ib qho ntawm cov kev xaiv, tus "Nrhiav thiab Hloov" qhov rais qhib hauv lub tab "Hloov". Hauv teb "Nrhiav" teev tus cursor thiab ob npaug nias ntawm lub pob Spacebar ntawm cov keyboard. Hauv teb "Hloov nrog" ntxig rau ib qhov chaw. Ces nyem rau ntawm lub pob "Hloov Tag Nrho".
- Qhov kev pab cuam hloov chaw ob chav nrog ib leeg. Tom qab ntawd, ib lub qhov rais tshwm nrog daim ntawv qhia txog kev ua haujlwm. Peb nias lub khawm "OK".
- Tom qab ntawd lub qhov rais rov tshwm dua. "Nrhiav thiab hloov". Peb ua hauv qhov rai no raws nraim tib yam li tau piav qhia nyob rau hauv pawg lus thib ob ntawm txoj kev qhia no kom txog thaum cov lus pom tshwm tias cov ntaub ntawv xav tau tsis tau pom.
Yog li, peb tau rhuav tshem ob chav ob qho chaw ntawm cov lus hauv daim ntawv.
Tshooj: Excel Character Hloov
Txoj kev 2: tshem cov kab nrib ntawm cov nab npawb
Qee zaum, tej qhov chaw muaj nyob nruab nrab ntawm cov zauv nyob hauv xov tooj. Qhov no tsis yog qhov yuam kev, tsuas yog rau kev pom kev ntawm cov zauv loj xwb hom sau ntawv no yooj yim dua. Tab sis tseem, qhov no yog qhov zoo ntawm txhua lub sijhawm. Piv txwv, yog hais tias lub xov tooj ntawm tes tsis yog formatted hom ntawv, qhov sib ntxiv ntawm ib qho kev sib cais yuav cuam tshuam qhov tseeb ntawm cov lus teb hauv cov qauv. Yog li ntawd, qhov teeb meem ntawm kev tshem tawm cov neeg cais tawm ua ceev. Cov hauj lwm no yuav ua tau zoo siv tib lub cuab tam. "Nrhiav thiab hloov".
- Xaiv lub kem lossis ntau yam uas koj xav muab tshem tawm qhov kev txiav txim ntawm cov zauv. Lub sijhawm no tseem ceeb heev, vim hais tias yog qhov khwv tsis tau xaiv, lub cuab tam yuav tshem tag nrho cov chaw ntawm daim ntawv, nrog rau ntawm cov lus, uas yog, qhov lawv xav tau tiag tiag. Tsis tas li ntawd, zoo li ua ntej, nias ntawm khawm "Nrhiav thiab pom tseeb" nyob rau hauv lub block ntawm cov cuab yeej Editing nyob rau ntawm txoj kab hauv qhov tab "Tsev". Hauv daim ntawv qhia ntxiv, xaiv qhov khoom "Hloov".
- Lub qhov rais pib dua. "Nrhiav thiab hloov" nyob rau hauv tab "Hloov". Tab sis lub sij hawm no peb yuav ntxiv me ntsis txawv qhov tseem ceeb rau cov teb. Hauv teb "Nrhiav" teeb ib qhov chaw thiab lub teb "Hloov nrog" peb tawm tas npliag. Kom paub tseeb tias tsis muaj qhov chaw nyob hauv daim teb no, muab tus cursor rau nws tuav thiab tuav lub pob khawm rov qab (hauv daim ntawv xub) ntawm tus keyboard. Tuav lub khawm kom txog thaum tus cursor hits sab laug ntawm lub tshav pob. Tom qab ntawd, nyem rau ntawm lub pob "Hloov Tag Nrho".
- Qhov kev zov me nyuam yuav ua rau kev khiav hauj lwm ntawm kev tshem tawm cov kab nrig ntawm cov ntawv. Raws li hauv txoj kev dhau los, kom paub tseeb tias qhov hauj lwm tiav tag nrho, peb ua ib qho kev tshawb nrhiav rov qab mus txog thaum cov lus tshwm tawm tias qhov nqi tsis pom.
Cov pawg ntawm cov zauv yuav raug muab tshem tawm, thiab cov qauv yuav pib kom muab xam kom raug.
Txoj kev 3: rho tawm cov tsiaj ntawv ntawm cov zauv los ntawm kev teeb tsa
Tab sis muaj ntau zaus thaum koj pom meej tias pom ntawm cov ntawv xov xwm tawm hauv cov lej, thiab qhov kev tshawb nrhiav tsis muab cov txiaj ntsig. Qhov no qhia tau hais tias nyob rau hauv cov ntaub ntawv no qhov kev sib cais tau ua los ntawm kev hloov. Qhov kev xaiv ntawm qhov chaw tsis cuam tshuam rau qhov tseeb ntawm cov qauv ntawm cov qauv, tab sis tib lub sijhawm, qee cov neeg ntseeg tias tsis muaj nws, lub rooj yuav zoo dua. Cia peb saib seb yuav rho tawm li cas.
Txij li thaum cov kis tau siv cov cuab yeej tawm ntawv, tsuas yog nrog cov cuab yeej tib yam tuaj yeem raug tshem tawm.
- Xaiv qhov ntau ntawm cov zauv nrog cais. Nias rau kev xaiv nrog txoj kev nas khawm. Hauv daim ntawv qhia zaub mov, xaiv qhov khoom "Qib hlwb ...".
- Lub qhov rai pib tuaj. Mus rau lub tab "Tooj", nyob rau hauv rooj plaub qhib lub qhov chaw sim lwm qhov. Yog hais tias qhov kev sib cais tau teem caij siv cov formatting, tom qab ntawd ces nyob hauv qhov kev txwv parameter "Teeb Meem" kev xaiv yuav tsum muab ntsia "Numeric". Nyob rau sab xis ntawm lub qhov rais yog qhov chaw muaj tseeb ntawm hom ntawv no. Nyob ze ze "Tshem pawg cais () koj tsuas yog yuav tsum tsis pom nws. Tom qab ntawd, nws thiaj li hloov cov nyhuv, ces nias lub khawm "OK".
- Lub formatting qhov rai kaw, thiab qhov sib cais ntawm tus leb ntawm cov zauv hauv qhov xaiv khwv yuav raug muab tshem tawm.
Tshooj: Excel cov lus formatting
Method 4: Tshem cov nras nrog cov haujlwm
Tool "Nrhiav thiab hloov" Zoo rau kev tshem cov nrawm ntawm cov cim. Tab sis yog tias lawv yuav tsum raug tshem tawm thaum pib los yog thaum kawg ntawm qhov kev qhia? Hauv qhov no, qhov kev ua haujlwm tau los ntawm cov pab pawg neeg txhais lus. CUTS.
Qhov no muaj nuj nqi tshem tawm txhua qhov chaw los ntawm cov ntawv nyeem ntawm ntau qhov xaiv, tsuas yog rau ib qho chaw ntawm cov lus. Ntawd yog, nws muaj peev xwm daws tau qhov teeb meem nrog cov chaw thaum pib ntawm lo lus nyob rau hauv lub cell, nyob rau ntawm lub kawg ntawm lo lus, thiab kuj mus tshem ob chav chaw.
Lub syntax ntawm no tus neeg teb xov tooj yog yooj yim heev thiab muaj tsuas yog ib qho sib cav:
= TRIMS (ntawv nyeem)
Raws li kev sib cav "Cov ntawv nyeem" muaj peev xwm ua raws li cov ntaub ntawv qhia txog nws tus kheej, los yog raws li ib tug reference rau lub cell uas nws muaj. Rau peb cov ntaub ntawv, tsuas yog qhov kev xaiv kawg nkaus xwb.
- Xaiv lub xov tooj ntawm tes uas nyob rau sab nraud los yog kab uas qhov chaw yuav tsum tau muab tshem tawm. Ndliv lub khawm "Ntxig rau kev ua haujlwm"nyob rau sab laug ntawm lub mis bar.
- Tus ua haujlwm Wizard pib. Nyob hauv qeb "Daim ntawv teev npe tag nrho" los yog "Cov ntawv nyeem" nrhiav ib yam khoom "SZHPROBELY". Xaiv nws thiab nyem rau ntawm lub pob. "OK".
- Qhov sib xyaw qhov rooj qhib qhov rooj. Hmoov tsis, txoj hauj lwm no tsis muab rau kev siv tag nrho peb xav tau raws li qhov kev sib cav. Yog li no, peb npaj tus cursor hauv qhov sib cav, ces xaiv qhov xub thawj ntawm cov kab uas peb ua haujlwm. Tom qab lub xovtooj ntawm qhov chaw nyob hauv lub tshav pob, nyem rau ntawm lub pob "OK".
- Raws li koj tau pom, cov ntsiab lus ntawm cov xovtooj yog tshwm nyob hauv thaj chaw uas qhov kev ua haujlwm nyob, tabsis tsis muaj qhov chaw ntxiv. Peb tau tshem tawm qhov chaw rau ib qho tsuas yog ib qho. Txhawm rau tshem tawm hauv lwm lub hlwb, koj yuav tsum tau ua tej yam zoo sib xws nrog lwm lub hlwb. Ntawm chav kawm, nws muaj peev xwm mus nqa tawm ib qho kev khiav hauj lwm nrog txhua lub cell, tab sis qhov no yuav siv sij hawm ntau heev, tshwj xeeb tshaj yog tias qhov ntau yog loj. Nws muaj ib txoj hau kev los ua kom txoj kev ua kom yooj yim. Teem tus cursor hauv qab ces kaum ntawm tus xovtooj, uas twb muaj cov qauv. Tus cursor yog hloov mus ua ib tug me me ntoo khaub lig. Nws hu ua tus cim kos npe. Tuav lub pob nyem khawm thiab luag ua lub luag haujlwm rau lub sijhawm uas koj xav tshem tawm tej qhov chaw.
- Raws li koj tau pom, tom qab cov yeeb yam no, muaj ntau yam ua tiav, uas yog txhua yam ntawm qhov chaw muaj nyob, tab sis tsis muaj lwm qhov chaw. Tam sim no peb fim cov hauj lwm ntawm kev hloov qhov tseem ceeb ntawm qhov tseem ceeb nrog cov ntaub ntawv hloov dua siab tshiab. Yog tias peb ua ib daim ntawv yooj yim, ces cov qauv yuav muab luam, uas txhais tau hais tias qhov nkag yuav tshwm sim tsis yog. Yog li ntawd, peb tsuas yog xav kom muab ib daim qauv ntawm qhov tseem ceeb.
Xaiv qhov ntev nrog qhov tseem ceeb dua. Peb nias lub khawm "Daim qauv"nyob rau ntawm txoj kab hauv qhov tab "Tsev" nyob rau hauv ib pawg ntawm cov cuab yeej "Ntawv Teev Npe". Raws li lwm txoj hau kev, koj tuaj yeem sau qhov shortcut tom qab xaiv Ctrl + C.
- Xaiv cov ntaub ntawv qhia thawj. Nias rau kev xaiv nrog txoj kev nas khawm. Hauv cov ntawv qhia zaub mov hauv lub nras "Insertion Options" xaiv ib yam khoom "Qhov tseem ceeb". Nws yog xwm li ib cov square pictogram nrog cov naj npawb hauv.
- Raws li koj tau pom, tom qab cov txheej txheem saum toj no, qhov tseem ceeb nrog rau cov chaw ntxiv tau hloov nrog cov ntaub ntawv zoo tib yam tsis muaj lawv. Ntawd yog, qhov haujlwm tiav. Tam sim no koj tuaj yeem rho tawm qhov chaw mus los uas tau siv rau kev hloov hlo. Xaiv qhov ntau ntawm cov hlwb uas muaj cov mis CUTS. Peb nyem rau ntawm nws nrog rau txoj kev nas khawm. Hauv daim ntawv qhia ua activated, xaiv qhov khoom "Cov lus tseeb".
- Tom qab ntawd, cov ntaub ntawv ntxiv yuav raug muab tshem tawm hauv daim ntawv. Yog hais tias muaj lwm yam nyob rau hauv lub rooj uas muaj chaw seem, ces koj yuav tsum nrog lawv siv tib qho algorithm raws li tau piav saum toj no.
Tshooj: Excel Function Wizard
Tshooj: Yuav ua li cas kom autocomplete hauv Excel
Raws li koj tuaj yeem pom, muaj ntau txoj kev los tshem tawm tej qhov chaw nyob hauv Excel. Tab sis tag nrho cov kev xaiv no yog siv nrog ob yam cuab yeej - qhov rais "Nrhiav thiab hloov" thiab tus neeg teb xov tooj CUTS. Nyob rau hauv ib rooj plaub sib cais, koj tuaj yeem siv tau hom ntawv. Tsis muaj txoj hauv kev uas yuav yooj yim tshaj plaws los siv rau txhua lub sijhawm. Nyob rau hauv ib rooj plaub, nws yuav pom kev siv ib qho kev xaiv, thiab nyob rau hauv lub thib ob - lwm, thiab lwm yam. Piv txwv li, tshem ob qhov chaw ntawm cov lus yuav ua tau los ntawm lub cuab yeej. "Nrhiav thiab hloov", tab sis tsuas yog muaj nuj nqi xwb yuav tshem tawm cov chaw pib thiab nyob rau thaum xaus ntawm lub cell CUTS. Yog li, tus neeg siv yuav tsum tau txiav txim siab rau daim ntawv thov ntawm ib hom kev ywj pheej ntawm kev ywj pheej, noj rau hauv cov nyiaj qhov teeb meem.
