Yuav ua li cas khov lub cell hauv Excel

Excel yog cov ntxhuav siv, thaum ua haujlwm nrog cov khoom siv uas tau hloov pauv, chaw nyob hloov pauv, thiab lwm yam. Tab sis qee kis koj yuav tsum tau kho qee yam khoom lossis, raws li lawv hais sib txawv, kom nws tsis hloov nws qhov chaw nyob. Cia kom paub cov kev xaiv uas tso cai rau nws ua.

Cov Hom Kev Kho Mob

Yuav tsum tau hais tias hom kev txhim kho hauv kev poob cev qhev tuaj yeem sib txawv kiag li. Feem ntau, lawv tuaj yeem muab faib ua peb pawg loj:

1. Khov chaw nyob;
2. Fastening hlwb;
3. Kev tiv thaiv ntawm cov khoom los ntawm kev kho kom raug.

Thaum mus rau qhov chaw nyob, qhov txuas rau lub cell tsis hloov thaum nws luam nws, uas yog, nws tsis yog tus txheeb ze. Kev lees paub ntawm cov hlwb tso cai rau koj kom pom lawv tas li ntawm lub vijtsam, txawm hais tias tus neeg siv tau nyob deb npaum li cas cov ntawv sau cia lossis sab xis. Kev tiv thaiv ntawm cov ntsiab lus los ntawm kev kho kom haum cov ntaub ntawv hloov pauv hauv lub caij tshwj xeeb. Cia peb xav txog txhua qhov ntawm cov kev xaiv no.

Txoj kev 1: Chaw nyob khov

Ua ntej, peb yuav tsom rau kev txhim kho lub xov tooj ntawm tes. Txhawm rau kom khov nws, los ntawm cov txheeb ze siv, qhov chaw nyob hauv Excel li cas, koj yuav tsum ua qhov txuas uas tsis hloov pauv cov tswj xyuas thaum luam. Txhawm rau ua qhov no, koj yuav tsum nruab qhov chaw nyob ntawm cov nyiaj daus las ($) los ntawm txhua txoj kev sib koom tes.

Teem cov nyiaj daus las yog ua los ntawm nias cov cim tsim nyog ntawm cov keyboard. Nws nyob ntawm ib qho tseem ceeb nrog tus lej "4", tab sis kom tshem tawm cov vijtsam uas koj xav tau los nias tus yuam sij hauv cov tsiaj ntawv Askiv (nrog "Hloov" tus yuam sij "). Muaj qhov yooj yim thiab nrawm. Koj yuav tsum xaiv qhov chaw nyob ntawm lub caij hauv ib lub xovtooj lossis hauv kab ua haujlwm thiab nyem rau ntawm F4 muaj nuj nqi. Thaum koj thawj zaug nyem, daim paib nyiaj daus yuav tshwm sim ntawm qhov chaw nyob thiab kab ntawv, thaum lub sij hawm thib ob nws yuav nyob ntawm qhov chaw nyob, thaum lub sij hawm thib peb - ​​ntawm qhov chaw nyob ntawm cov ntawv. Plaub nias F4 tus yuam sij tshem tawm cov nyiaj daus kos npe, thiab cov txheej txheem tom ntej no los ntawm lub voj voog tshiab.

Cia peb saib qhov chaw nyob khov rau ib qho piv txwv.

1. Txhawm rau pib nrog, luam cov mis li ib txwm mus rau lwm yam ntawm kem. Ua li no, siv tus cim sau. Nruab tus cursor mus rau sab xis sab xis ntawm lub cell, cov ntaub ntawv los ntawm uas koj xav kom luam. Nyob rau tib lub sijhawm, nws tau hloov mus rau hauv tus ntoo khaub lig, uas nqa lub npe ntawm cov cim sau. Thawb lub khawm nas laug thiab rub tus ntoo khaub lig mus rau qhov kawg ntawm lub rooj.



2. Tom qab ntawd, peb faib cov khoom qis tshaj ntawm lub rooj thiab saib ntawm kab mis, uas yog cov mis tau hloov pauv thaum luam. Raws li koj tuaj yeem pom, tag nrho cov chaw ua haujlwm uas tau nyob hauv thawj ntu ntawm kem, thaum luam tawm. Raws li qhov tshwm sim, cov mis nyuj muaj teeb meem tsis raug. Qhov no yog vim qhov tseeb tias qhov chaw nyob ntawm qhov thib ob, nyob rau hauv kev sib piv rau thawj zaug, yuav tsum tsis txhob hloov pauv rau qhov kev suav, uas yog, nws yuav tsum tau ua kom meej lossis tsau.



3. Peb rov qab mus rau thawj ntu ntawm kem thiab nruab DOLDAR kos npe ze ntawm kev tswj hwm ntawm ib ntawm cov qauv uas peb tau tham saum toj no. Tam sim no qhov txuas no yog khov.



4. Tom qab ntawd, siv cov cim sau, theej nws mus rau lub rooj ua hauv qab no.



5. Tom qab ntawd peb faib cov theem kawg ntawm cov kem. Raws li peb tuaj yeem pom tau los ntawm cov kab lus ntawm lub cev, cov kev sib koom tes ntawm thawj qhov tseem ceeb tseem hloov thaum luam, tab sis qhov chaw nyob hauv qhov tseeb, tsis hloov.



6. Yog tias koj tso nyiaj daus las kos npe tsuas yog nyob ntawm cov chaw sib koom ua ke, tom qab ntawd qhov chaw nyob ntawm qhov chaw nyob ntawm txoj hlua txuas, thiab cov kev sib txuas ntawm txoj hlua yog hloov thaum luam tawm thaum luam.



7. Hloov siab, yog tias koj teeb tsa daus las kos npe ze rau qhov chaw nyob ntawm kab chaw nyob, tom qab ntawd thaum luam nws yuav tsis hloov, tsis hloov, tsis hloov, tsis hloov chaw nyob ntawm cov chaw nyob.

Cov qauv no ua rau kom khov kho ntawm cov hlwb.

TSHOOJ: Cov lus hais txog hauv Excel

Txoj Kev 2: Txhim Kho Cov Hlwb

Tam sim no peb kawm paub txhim kho lub hlwb kom lawv tsis tu ncua ntawm lub vijtsam uas tus neeg siv yuav tsis mus rau hauv thaj tsam nplooj. Nyob rau tib lub sijhawm, nws yuav tsum tau sau tseg tias tus kheej lub cev tsis tuaj yeem ceev, tab sis koj tuaj yeem kho thaj chaw uas nws nyob.

Yog tias cov xov tooj xav tau nyob rau sab saud ntawm daim ntawv lossis hauv kem sab laug, tom qab ntawd kev kho yog theem pib yooj yim.

1. Txhawm rau txoj hlua, ua cov haujlwm hauv qab no. Mus rau "saib" tab thiab av nplaum ntawm "Fasten cheeb tsam" khawm, uas nyob rau hauv lub qhov rais ntawm lub qhov rais ntawm "qhov rai" talebar. Cov npe ntawm cov kev xaiv ua haujlwm sib txawv qhib. Xaiv lub npe "nyab xeeb cov kab ntawv sab saud".



2. Tam sim no txawm tias koj nqis mus rau hauv qab ntawm daim ntawv, thawj kab, uas txhais tau tias cov khoom koj xav tau, nyob hauv nws, tseem yuav nyob rau saum lub qhov rais.

Ib yam li ntawd, koj tuaj yeem khov cov sab laug sab laug.

1. Mus rau "Saib" tab thiab nyem rau ntawm "Fasten cheeb tsam" khawm. Lub sijhawm no kuv xaiv qhov kev xaiv "ruaj ntseg thawj kem".



2. Raws li koj tuaj yeem pom, lub tshaj plaws sab laug sab laug yog tam sim no tsau.

Kwv yees li tib txoj kev koj tuaj yeem ua ke tsis tsuas yog thawj kem thiab txoj hlua, tab sis feem ntau, tag nrho thaj chaw yog sab laug thiab sab saud los ntawm cov khoom uas tau xaiv.

1. Lub algorithm tiav rau txoj haujlwm no yog txawv me ntsis los ntawm ob qho dhau los. Ua ntej tshaj plaws, nws yog qhov tsim nyog los nthuav dav cov nplooj ntoo, thaj chaw los ntawm saum toj thiab sab laug ntawm uas yuav raug tsau. Tom qab ntawd, mus rau "Saib" tab thiab nyem rau ntawm lub cim uas paub "ceev thaj tsam". Hauv cov ntawv qhia zaub mov uas qhib, xaiv cov khoom nrog tib lub npe.



2. Tom qab qhov kev txiav txim no, tag nrho cov chaw nyob ntawm sab laug thiab saum toj no lub ntsiab lus muaj kev kho rau ntawm daim ntawv.

Yog tias xav tau, tshem tawm cov khov ua hauv txoj kev no, yooj yim heev. Lub algorithm tiav yog tib yam nyob rau txhua kis uas nws yuav yog tus neeg siv uas yuav tsis muaj kev nyab xeeb: txoj hlua, kem lossis thaj chaw. Peb tsiv mus rau "View" tab, nyem rau ntawm "kho thaj tsam" icon thiab hauv cov npe uas qhib, xaiv cov kev xaiv rau "tshem tawm cov kev sib xyaw ntawm thaj chaw". Tom qab ntawd, txhua qhov ruaj khov ntawm daim ntawv tam sim no yuav raug tso tseg.

Zaj Lus Qhia: Yuav ua li cas kho thaj tsam hauv Excel

Txoj Kev 3: Kev Tiv Thaiv Kev Tiv Thaiv

Thaum kawg, koj tuaj yeem tiv thaiv lub cell los ntawm kev kho los ntawm thaiv lub peev xwm los hloov rau cov neeg siv. Yog li, tag nrho cov ntaub ntawv uas nyob hauv nws yuav khov.

Yog tias koj lub rooj tsis yog zog thiab tsis muab rau kev hloov pauv ntawm cov kev hloov pauv ntawm nws, koj tuaj yeem tiv thaiv tsis tsuas yog tag nrho cov ntawv nyeem tag nrho. Nws yog qhov tseem yooj yim dua.

1. Tsiv mus rau hauv "file" tab.



2. Nyob rau hauv lub qhov rais uas qhib nyob rau hauv daim ntawv qhia zaub mov sab laug, mus rau ntu "cov ntsiab lus" ". Hauv qhov nruab nrab ntawm lub qhov rais, av nplaum ntawm cov inscription "tiv thaiv phau ntawv". Nyob rau hauv cov npe ntawm kev ruaj ntseg kev ua uas qhib, xaiv "tiv thaiv cov ntawv tam sim no" kev xaiv.



3. Lub qhov rais me me tau tsim tawm, uas yog hu ua "daim ntawv tiv thaiv". Ua ntej tshaj plaws, hauv ib daim teb tshwj xeeb koj yuav tsum nkag mus rau tus password tshwj xeeb, uas yuav tsum muaj los ntawm cov neeg siv khoom yog tias nws xav tau kev tiv thaiv kev tiv thaiv yav tom ntej los hloov cov ntawv. Ib qho ntxiv, ntawm yuav, koj tuaj yeem nruab lossis tshem tawm cov kev txwv ntxiv, txhim kho lossis tshem tawm cov chij nyob ze cov khoom uas tau nthuav tawm hauv lub qhov rai no. Tab sis feem ntau, cov chaw teeb tsa tau zoo sib xws nrog txoj haujlwm, kom koj tuaj yeem nyem rau ntawm "OK" khawm tom qab nkag rau tus password.



4. Tom qab ntawd, lwm lub qhov rais pib, uas tus password nkag mus ua ntej yuav tsum tau rov ua dua. Qhov no yog ua kom ntseeg tau tias tus neeg siv tau ntseeg meej tias nws tau qhia meej tus password thiab sau tseg rau nws kuv tus kheej tuaj yeem poob cov ntaub ntawv. Tom qab rov nkag mus rau tus password, nias lub "OK" khawm.



5. Tam sim no thaum sim hloov kho ib daim ntawv twg, qhov kev txiav txim no yuav raug thaiv. Cov ntaub ntawv qhov rai yuav qhib, tshaj tawm txog qhov tsis muaj peev xwm hloov cov ntaub ntawv ntawm daim ntawv tiv thaiv.

Muaj lwm txoj hauv kev los thaiv cov kev hloov pauv ntawm cov khoom ntawm daim ntawv.

1. Mus rau "tshuaj xyuas" qhov rai thiab av nplaum ntawm "tiv thaiv nplooj", uas yog nyob ntawm daim kab xev hauv "Hloov" Tool thaiv.



2. Qhib twb paub txog peb lub qhov rai tiv thaiv lub qhov rai. Txhua qhov kev nqis tes ua ntxiv nyob rau hauv tib txoj kev raws li tau piav qhia hauv version yav dhau los.

Tab sis yuav ua li cas yog tias koj yuav tsum khov tsuas yog ib lossis ntau lub hlwb, thiab lwm cov hlwb, thiab hauv lwm tus xav tau, raws li ua ntej, kom dawb do ua cov ntaub ntawv? Muaj ib txoj hauv kev ntawm txoj haujlwm no, tab sis nws cov kev daws teeb meem yog qee yam nyuaj dua li cov haujlwm dhau los.

Nyob rau hauv tag nrho cov cell ntawm daim ntawv teev npe hauv lub zog, kev tiv thaiv yog qhia, thaum cov ntawv xauv tau qhib rau hauv dav dav, cov kev xaiv tau hais saum toj no. Peb yuav tau tshem tawm cov kev tiv thaiv kev tiv thaiv hauv cov yam ntxwv ntawm tag nrho cov ntawv, thiab tom qab ntawd muab nws dua hauv cov ntsiab lus uas peb xav kom khov ntawm kev hloov pauv.

1. Nyem rau ntawm lub duab plaub, uas yog nyob ntawm qhov kev sib tshuam ntawm kab rov tav thiab ntsug kom ua ke panels. Tsis tas li, yog tias tus cursor nyob hauv txhua thaj chaw ntawm daim ntawv sab nraud ntawm lub rooj, Nias kev sib xyaw ua ke ntawm cov lej kub ntawm Ctrl + cov keyboard. Cov nyhuv yuav zoo ib yam - txhua cov ntsiab lus ntawm daim ntawv yog tseem ceeb.



2. Tom qab ntawd peb clas rau ntawm qhov tseem ceeb cheeb tsam los ntawm txoj nyem sab xis. Nyob rau hauv cov ntawv thov cov ntawv qhia qhib cov lus qhia, xaiv cov "xovtooj ntawm tes ...". Tsis tas li, hloov, koj tuaj yeem siv Ctrl + 1 teeb tsa sib xyaw.



3. Lub "xovtooj ntawm tes" lub qhov rai yog qhib. Kev hloov mus rau "Kev Tiv Thaiv". Nws yuav tsum tau muab tshem tawm lub ntsuas phoo ze ntawm cov "muaj kev tiv thaiv cell" parameter. Nyem rau ntawm "OK" khawm.



4. Tom ntej no, peb rov qab mus rau daim ntawv thiab faib cov khoom lossis pab pawg uas peb yuav tau khov cov ntaub ntawv. Peb nyem txoj cai-nyem rau ntawm cov thooj thiab hauv cov ntawv qhia zaub mov, mus rau lub npe hu ua "xov tooj" ntawm tes ... ".



5. Tom qab qhib lub qhov rai formatting, ib zaug ntxiv mus rau "kev tiv thaiv" tab thiab teeb lub npov nyob ze ntawm "tiv thaiv ntawm tes" khoom. Tam sim no koj tuaj yeem nyem rau ntawm "OK" khawm.



6. Tom qab ntawd, peb teeb cov ntawv pov thawj los ntawm ib qho ntawm ob txoj hauv kev uas tau piav ua ntej.

Tom qab ua tiav txhua cov txheej txheem piav qhia meej rau meej peb saum toj no, tsuas yog cov hlwb uas peb rov tsim kev tiv thaiv los ntawm cov khoom ntawm hom yuav raug txwv los ntawm kev hloov pauv. Hauv tag nrho lwm cov ntsiab lus ntawm daim ntawv, raws li ua ntej, koj tuaj yeem tiv thaiv cov ntaub ntawv pub dawb.

Zaj Lus Qhia: Yuav ua li cas tiv thaiv cov cell los ntawm kev hloov pauv mus rau Excel

Raws li koj tuaj yeem pom, muaj peb txoj hauv kev los ua kom khov lub hlwb. Tab sis nws yog ib qho tseem ceeb kom nco ntsoov tias nws txawv ntawm lawv tsis yog thev naus laus zis ntawm kev ua cov txheej txheem no, tab sis kuj yog qhov tseem ceeb ntawm lub esseds ntawm lub te nws tus kheej. Yog li, nyob rau hauv ib kis, tsuas yog qhov chaw nyob ntawm nplooj ntoos hlav tau sau tseg, hauv qhov thib ob - thaj chaw yog tsau ntawm cov ntaub ntawv hloov pauv hauv lub hlwb tau teeb tsa. Yog li ntawd, nws yog ib qho tseem ceeb heev kom nkag siab ua ntej ua cov txheej txheem, dab tsi yog koj yuav thaiv thiab vim li cas koj ua nws.