Yuav Ua Li Cas Rho Tawm Txhua Kab Dawb hauv Excel

Hauv tsab xov xwm no, kuv yuav piav qhia vim li cas tshem tawm cov kab dawb hauv Excel siv ua kom pom cov hlwb khoob > rho tawm kab yog ib lub tswv yim phem, thiab kuv yuav qhia koj 2 txoj hauv kev sai thiab raug tshem tawm cov kab tsis muaj kev puas tsuaj rau cov ntaub ntawv. Tag nrho cov txheej txheem no ua haujlwm hauv Excel 2013, 2010, thiab cov laus dua.

Yog tias koj nyeem tsab xov xwm no, feem ntau koj yuav ua haujlwm tas li hauv Excel nrog cov ntxhuav loj. Koj paub tias cov kab 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 khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob khoob Thiab txhua lub sij hawm koj yuav tsum manually txhais cov ciam teb, txwv tsis pub cov txiaj ntsig yuav yog qhov tshwm sim tsis raug thiab siv sijhawm ntau los kho qhov tsis raug.

Muaj ntau yam laj thawj vim li cas cov kab dawb paug tshwm. Piv txwv li, koj tau txais ib phau ntawv ua haujlwm Excel los ntawm lwm tus neeg lossis vim yog kev xa tawm los ntawm cov tuam txhab database, lossis cov ntaub ntawv tsis tsim nyog hauv kab raug tshem tawm manually. Txawm li cas los xij, yog tias koj lub hom phiaj yog tshem tawm tag nrho cov kab dawb huv thiab muaj lub rooj huv thiab huv si, ces ua raws li cov kauj ruam yooj yim hauv qab no:

• Tsis txhob rho tawm cov kab dawb dawb nrog kev xaiv ntawm tes dawb
• Tshem tawm cov kab khoob uas siv cov kab tseem ceeb
• Tshem cov kab khoob hauv ib lub rooj uas tsis muaj kab tseem ceeb

Tsis txhob rho tawm cov kab dawb dawb nrog kev xaiv ntawm tes dawb

Hauv Internet, koj yuav pom cov lus qhia yooj yim uas tso cai rau koj tshem tawm cov kab dawb paug:

• Xaiv cov ntaub ntawv los ntawm thawj mus rau lub cell kawg.
• Xovxwm F5qhib lub dialog mus rau (Kev hloov).
• Hauv dialog box, nyem lub pob tshwj xeeb (Hloov siab).
• Nyob rau hauv lub dialog box Mus rau qhov tshwj xeeb (Xaiv ib pawg ntawm cov hlwb) kos lub thawv kib lus (Npuas hlwb) thiab nias OK.
• Txoj cai-nias rau ntawm ib qho ntawm cov cell xaiv thiab nias Rho tawm (Rho tawm).
• Nyob rau hauv lub dialog box Rho tawm (Rho tawm cov hlwb) xaiv Tag nrho kab (kab) thiab nias OK.

Qhov no yog ib txoj kev phem heev., tsuas yog ua qhov no nrog cov rooj yooj yim heev nrog ob peb lub kaum ob kab uas haum rau ntawm ib qho screen, lossis zoo dua - txhob ua li ntawd kiag li! Lub ntsiab yog vim li cas yog tias ib kab nrog cov ntaub ntawv tseem ceeb muaj tsawg kawg yog ib lub xov tooj khoob, ces tag nrho cov kab yuav raug muab tshem tawm.

Piv txwv li, peb muaj cov neeg siv khoom nrog 6 kab hauv tag nrho. Peb xav tshem tawm cov kab 3 и 5vim lawv tsis muaj dabtsi.

Ua raws li tau hais los saum toj no thiab tau txais cov txiaj ntsig hauv qab no:

kab 4 (Roger) kuj ploj mus vim lub cell D4 hauv ib kem Cov chaw muaj tsheb khiav tig tawm los ua qhov khoob

Yog tias koj lub rooj tsis loj koj yuav pom cov ntaub ntawv poob, tab sis hauv cov ntxhuav tiag tiag nrog ntau txhiab kab koj yuav tsis paub txog tshem tawm ntau ntau kab tsim nyog. Yog tias koj muaj hmoo, koj yuav pom qhov poob hauv ob peb teev, rov qab kho cov ntawv ua haujlwm los ntawm kev thaub qab, thiab ua haujlwm txuas ntxiv. Yuav ua li cas yog tias koj tsis muaj hmoo thiab koj tsis muaj thaub qab?

Tom qab ntawv hauv tsab xov xwm no, kuv yuav qhia koj 2 txoj hauv kev nrawm thiab txhim khu kev qha kom tshem tawm cov kab dawb ntawm Excel nplooj ntawv.

Tshem tawm cov kab khoob uas siv cov kab tseem ceeb

Txoj kev no ua haujlwm yog tias koj lub rooj muaj ib kem uas pab txiav txim siab seb kab ntawv hauv nqe lus nug tsis muaj dab tsi lossis tsis yog (lub ntsiab lus tseem ceeb). Piv txwv li, nws tuaj yeem yog tus neeg siv khoom ID lossis tus lej xaj, lossis qee yam zoo sib xws.

Nws yog ib qho tseem ceeb rau peb khaws cia qhov kev txiav txim ntawm kab, yog li peb tsis tuaj yeem txheeb lub rooj los ntawm kab ntawd kom txav tag nrho cov kab khoob.

1. Xaiv tag nrho cov lus, los ntawm thawj mus rau kab kawg (nias Ctrl + Tsev, thiab tom qab ntawd Ctrl + Ua haujlwm + Xaus).
2. Ntxiv ib qho autofilter rau lub rooj. Txhawm rau ua qhov no, ntawm lub tab Cov ntaub ntawv (cov ntaub ntawv) nyem Lim ( Lim ).
3. Siv lub lim rau ib kab Cust#. Txhawm rau ua qhov no, nyem lub pob xub nyob rau hauv kab ntawv kab lus, uncheck qhov kev xaiv Xaiv Tag Nrho (Xaiv Tag Nrho), nqes mus rau qhov kawg ntawm daim ntawv (hauv kev xyaum, daim ntawv teev npe no tuaj yeem ntev heev) thiab kos lub thawv kib lus (Epty) nyob rau hauv qab ntawm daim ntawv. Nyem OK.
4. Xaiv tag nrho cov kab lim dej: nyem Ctrl + Tsev, ces tus xub nqis mus rau thawj kab ntawm cov ntaub ntawv, thiab ces nias Ctrl + Ua haujlwm + Xaus.
5. Txoj cai-nias ntawm txhua lub xov tooj ntawm tes thiab los ntawm cov ntawv qhia zaub mov xaiv Rho tawm kab (Rho tawm kab) lossis tsuas yog nyem Ctrl + -(tso npe).
6. Nyob rau hauv lub qhov rais uas tshwm nrog ib lo lus nug Rho tawm tag nrho kab ntawv? (Rho tawm tag nrho cov kab ntawv?) nyem OK.
7. Tshem cov lim siv: ntawm lub tab Cov ntaub ntawv (cov ntaub ntawv) nyem Clear (Ntshiab).
8. Zoo heev! Tag nrho cov kab khoob raug tshem tawm tag, thiab kab 3 (Roger) tseem nyob hauv qhov chaw (piv nrog qhov tshwm sim ntawm qhov kev sim dhau los).

Tshem cov kab khoob hauv ib lub rooj uas tsis muaj kab tseem ceeb

Siv cov qauv no yog tias koj lub rooj muaj ntau lub hlwb khoob tawg thoob plaws kab sib txawv, thiab koj yuav tsum tshem tawm tsuas yog cov kab uas tsis muaj lub hlwb nrog cov ntaub ntawv.

Nyob rau hauv cov ntaub ntawv no, peb tsis muaj ib tug tseem ceeb kem los pab txiav txim seb txoj hlua yog khoob los yog tsis. Yog li ntawd, peb ntxiv ib qho auxiliary kem rau lub rooj:

1. Thaum kawg ntawm lub rooj, ntxiv ib kab npe kib lus thiab muab cov mis hauv qab no tso rau hauv thawj lub xov tooj ntawm kab ntawv:

   =COUNTBLANK(A2:C2)

   =СЧИТАТЬПУСТОТЫ(A2:C2)

   Cov mis no, raws li nws lub npe qhia, suav cov hlwb khoob hauv ib qho kev muab. A2 и C2 yog thawj zaug thiab zaum kawg ntawm cov kab tam sim no, feem.

   

2. Luam cov qauv rau tag nrho cov kab. Yuav ua li cas - saib cov lus qhia ib kauj ruam-ib-kauj ruam Yuav ua li cas ntxig tib lub mis rau hauv txhua lub hlwb xaiv ib zaug.
3. Tam sim no peb lub rooj muaj ib kem tseem ceeb! Siv lub lim rau ib kab kib lus (saum toj no yog ib kauj ruam los ntawm kauj ruam qhia yuav ua li cas ua qhov no) tsuas yog qhia cov kab nrog tus nqi siab tshaj (3). Tus lej 3 txhais tau hais tias tag nrho cov hlwb hauv kab no yog khoob.
4. Tom ntej no, xaiv tag nrho cov kab lim thiab tshem tawm tag nrho. Yuav ua li cas thiaj li tau piav qhia saum toj no. Yog li ntawd, cov kab khoob (kab 5) yuav raug muab tshem tawm, tag nrho lwm cov kab (nrog lossis tsis muaj lub hlwb) yuav nyob hauv lawv qhov chaw.
5. Tam sim no cov pab pawg tuaj yeem raug tshem tawm. Lossis koj tuaj yeem siv lwm lub lim kom pom tsuas yog cov hlwb uas muaj ib lossis ntau lub hlwb. Ua li no, uncheck kab nrog tus nqi 0 (zero) thiab nias OK.