Yuav ua li cas rho tawm cov hlwb khoob hauv Excel. 3 txoj hauv kev kom tshem tawm cov Cells tsis muaj nyob hauv Excel

Thaum hloov lub rooj los ntawm lwm qhov chaw mus rau Excel, cov xwm txheej feem ntau tshwm sim nrog kev hloov ntawm cov hlwb nrog cov ntaub ntawv thiab tsim cov voids. Thaum siv cov qauv, kev ua haujlwm ntxiv tsis tuaj yeem ua tau. Hauv qhov no, cov lus nug tshwm sim: koj tuaj yeem tshem tawm cov hlwb sai sai li cas?

Cov xwm txheej uas nws muaj peev xwm tshem tawm cov hlwb dawb

Thaum lub sijhawm ua haujlwm, cov ntaub ntawv hloov pauv yuav tshwm sim, uas tsis xav tau. Kev tshem tawm tsuas yog ua rau qee kis, piv txwv li:

• Tsis muaj ntaub ntawv nyob rau hauv tag nrho kab lossis kab.
• Tsis muaj kev sib raug zoo ntawm cov hlwb.

Txoj kev classic rau tshem tawm cov voids yog ib lub caij ntawm ib lub sij hawm. Txoj kev no tuaj yeem ua tau yog tias koj ua haujlwm nrog thaj chaw uas xav tau kev hloov kho me me. Lub xub ntiag ntawm ib tug loj tus naj npawb ntawm npliag hlwb ua rau yuav tsum tau siv batch deletion txoj kev.

Tshuaj 1: rho tawm los ntawm xaiv ib pab pawg ntawm cov hlwb

Txoj kev yooj yim tshaj plaws yog siv cov cuab yeej tshwj xeeb los xaiv cov pab pawg ntawm cov hlwb. Txheej txheem ua:

1. Xaiv thaj chaw teeb meem uas cov hlwb khoob tau sau tseg, tom qab ntawd nias F5 yuam sij.

2. Lub vijtsam yuav tsum qhib lub qhov rai hais kom ua hauv qab no. Nyem rau ntawm qhov sib tham sib xaiv khawm.
3. Qhov kev pab cuam yuav qhib lwm lub qhov rais. Xaiv "Empty Cells". Kos lub thawv thiab nyem OK.
4. Muaj ib qho kev xaiv tsis siv neeg ntawm qhov chaw tsis tau sau. Txoj cai-nias ntawm txhua qhov chaw tsis muaj ntaub ntawv qhib qhib lub qhov rais uas koj xav tau nyem "Delete".
5. Tom ntej no, "Delete Cells" yuav qhib. Muab tus zuam ib sab ntawm "Cells nrog kev hloov pauv." Peb pom zoo los ntawm nias lub pob "OK".

6. Yog li ntawd, qhov kev zov me nyuam yuav cia li tshem tawm cov chaw uas yuav tsum tau kho.
7. Txhawm rau tshem tawm cov kev xaiv, nyem LMB nyob qhov twg hauv lub rooj.

Lus Cim! Txoj kev tshem tawm nrog kev hloov pauv tsuas yog xaiv nyob rau hauv rooj plaub uas tsis muaj kab tom qab xaiv thaj chaw uas nqa cov ntaub ntawv.

Kev daws 2: Thov Lim thiab Kho kom haum Formatting

Txoj kev no yog qhov nyuaj dua, yog li ntawd, ua ntej pib qhov kev siv, nws raug nquahu kom koj ua ntej paub koj tus kheej nrog cov ncauj lus kom ntxaws txog kev ua haujlwm ntawm txhua qhov kev ua.

Mloog! Lub ntsiab tsis zoo ntawm txoj kev no yog tias nws yog siv los ua haujlwm nrog ib kem uas tsis muaj cov qauv.

Xav txog cov lus piav qhia ua ntu zus ntawm kev lim cov ntaub ntawv:

1. Xaiv ib cheeb tsam ntawm ib kab. Nrhiav cov khoom "Editing" ntawm lub toolbar. Los ntawm txhaj rau nws, lub qhov rais nrog cov npe ntawm cov chaw yuav tshwm. Mus rau "Tswj thiab Lim" tab.

2. Xaiv lub lim thiab qhib LMB.

3. Yog li ntawd, lub cell sab saum toj yog qhib. Ib tug square-shaped icon nrog ib tug xub down yuav tshwm nyob rau sab. Qhov no qhia tau tias muaj peev xwm qhib lub qhov rais nrog cov haujlwm ntxiv.
4. Nyem rau ntawm lub pob thiab nyob rau hauv tab uas qhib, tshem tawm lub thawv nyob ib sab ntawm txoj hauj lwm "(Empty)", nyem "OK".

5. Tom qab ua tiav manipulations, tsuas yog cov cell puv yuav nyob twj ywm hauv kem.

Cov kws tshaj lij tawm tswv yim! Tshem tawm cov voids uas siv cov lim dej tsuas yog tsim nyog yog tias tsis muaj cov hlwb nyob ib puag ncig, txwv tsis pub, thaum ua txoj haujlwm no, tag nrho cov ntaub ntawv yuav ploj.

Tam sim no cia peb saib yuav ua li cas ua cov kev cai formatting nrog rau kev lim dej:

1. Txhawm rau ua qhov no, xaiv thaj chaw teeb meem thiab, pom qhov "Styles" toolbar, qhib lub "Conditional Formatting" khawm.

2. Hauv qhov rai uas qhib, nrhiav kab "Ntxiv" thiab ua raws li qhov txuas no.
3. Tom ntej no, nyob rau hauv lub qhov rais uas tshwm nyob rau hauv sab laug teb, sau tus nqi "0". Nyob rau hauv txoj cai teb, xaiv cov xim sau cov kev xaiv uas koj nyiam los yog tawm hauv lub neej ntawd qhov tseem ceeb. Peb nyem "OK". Yog li ntawd, txhua lub hlwb nrog cov ntaub ntawv yuav raug pleev xim rau hauv cov xim koj xaiv.
4. Yog tias qhov kev zov me nyuam tshem tawm qhov kev xaiv yav dhau los, peb rov ua dua thiab qhib lub cuab yeej "Filter". Hover tshaj tus nqi "Lim los ntawm cov xim ntawm tes" lossis los ntawm font thiab qhib ib qho ntawm txoj haujlwm.
5. Yog li ntawd, tsuas yog cov hlwb uas muaj xim nrog cov xim, thiab yog li ntawd sau nrog cov ntaub ntawv, yuav nyob twj ywm.

6. Rov xaiv thaj tsam uas muaj xim xim thiab pom lub pob "Copy" nyob rau sab saum toj ntawm lub toolbar, nias nws. Nws yog sawv cev los ntawm ob nplooj ntawv superimposed rau ib leeg.
7. Los ntawm xaiv lwm thaj chaw ntawm daim ntawv no, peb xaiv lwm qhov.
8. Txoj cai-nias rau qhib cov ntawv qhia zaub mov, qhov twg peb pom "Cov Nqi". Lub cim tau nthuav tawm nyob rau hauv daim ntawv ntawm cov ntsiav tshuaj nrog cov lej suav 123, nyem.

Lus Cim! Thaum xaiv ib cheeb tsam, nws yog ib qho tsim nyog uas lub sab sauv yog nyob rau hauv qab kab hauv qab ntawm cov npe tseem ceeb.

9. Yog li ntawd, cov ntaub ntawv theej tau raug xa mus yam tsis siv lub lim xim.

Kev ua haujlwm ntxiv nrog cov ntaub ntawv tuaj yeem ua tiav hauv zos lossis los ntawm kev xa mus rau lwm thaj chaw ntawm daim ntawv.

Kev daws 3: siv cov qauv

Tshem tawm lub rooj khoob khoob hauv txoj kev no muaj qee qhov teeb meem thiab yog li tsis tshua nyiam. Qhov nyuaj yog nyob rau hauv kev siv cov mis, uas yuav tsum tau muab cia rau hauv ib tug nyias muaj nyias ntaub ntawv. Cia peb mus dhau cov txheej txheem hauv kev txiav txim:

1. Xaiv qhov ntau ntawm cov hlwb uas yuav tsum tau kho.
2. Tom qab ntawd peb right-click thiab nrhiav cov lus txib "Tau npe." Muab lub npe rau kab ntawv xaiv, nyem OK.

4. Nyob rau hauv txhua qhov chaw ntawm daim ntawv, xaiv thaj chaw dawb, uas sib haum rau qhov loj ntawm thaj chaw uas qhov kev hloov kho. Right-click thiab sau ib lub npe txawv.

5. Tom qab koj yuav tsum qhib lub xovtooj saum toj kawg nkaus ntawm thaj chaw dawb thiab nkag mus rau cov qauv hauv nws: =IF(ROW() -ROW(Adjustment)+1>NOTROWS(LastNames)-COUNTBLANK(LastNames);"";INDIRECT(ADDRESS(LOW((IF(LastNames<>"",ROW(LastNames);ROW()) + ROWS(Surnames)));ROW()-ROW(Adjustment)+1);COLUMN(Surnames);4))).

Lus Cim! Cov npe rau thaj chaw raug xaiv arbitrarily. Hauv peb qhov piv txwv, cov no yog "Surnames" thiab "Kev Kho".

6. Thaum cov qauv no nkag mus, nias qhov tseem ceeb ua ke "Ctrl + Ua haujlwm + Sau". Qhov no yog qhov tsim nyog vim tias muaj cov arrays hauv cov qauv.

Nthuav lub xovtooj sab saum toj mus rau ciam teb ntawm thaj chaw yav dhau los. Ib kem nrog cov ntaub ntawv xa mus yuav tsum tau tso tawm, tab sis tsis muaj lub hlwb khoob.

xaus

Tshem tawm cov khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob.