Thaum ua haujlwm nrog Microsoft Excel daim ntawv nthuav qhia nrog ntau cov ntaub ntawv, koj yuav zaum ntsib cov npe sib xyaw. Microsoft Excel's Cov Qauv Txheej Txheem Txheej Txheem qhia koj raws nraim qhov twg yog qhov sib txawv, thaum tshem tawm cov ntawv theej tawm tshwj xeeb yuav rho tawm lawv rau koj. Saib thiab rho tawm cov ntawv sib thooj kom ntseeg tau tias koj cov ntaub ntawv thiab kev nthuav qhia muaj tseeb raws li qhov ua tau.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv Txoj Cai Raws Li Txoj Cai
Kauj Ruam 1. Qhib koj thawj daim ntawv
Thawj qhov koj yuav tsum tau ua yog xaiv tag nrho cov ntaub ntawv koj xav tshuaj xyuas rau qhov sib tshooj.
Kauj Ruam 2. Nyem rau ntawm tes nyob rau sab saud sab laug ntawm koj cov ntaub ntawv
Qhov no pib txheej txheem xaiv.
Kauj Ruam 3. Tuav tus yuam sij ⇧ Shift thiab nyem lub cell kawg
Nco ntsoov tias lub xovtooj kawg yuav tsum yog nyob rau sab xis sab xis ntawm koj cov ntaub ntawv. Qhov no yuav xaiv tag nrho koj cov ntaub ntawv.
Koj tuaj yeem ua qhov no nyob rau hauv ib qho kev txiav txim (piv txwv li, nyem rau ntawm lub npov sab xis sab xis ua ntej, tom qab ntawd hais meej los ntawm qhov ntawd)
Kauj Ruam 4. Nyem rau "Conditional Formatting
" Nws tuaj yeem pom nyob hauv "Tsev" tab/kab ntawm lub cuab yeej (feem ntau, hauv ntu "Cov Qauv" ntu). Nyem rau nws yuav ua kom lub tshuab raj nco-down.
Kauj Ruam 5. Xaiv "Highlight Cells Rules," ces "Duplicate Values
" Nco ntsoov tias koj cov ntaub ntawv tseem tseem ceeb thaum koj ua qhov no. Qhov no yuav qhib lub qhov rai nrog kev xaiv kev hloov pauv hauv lwm cov ntawv qhia zaub mov nco.
Kauj Ruam 6. Xaiv "Duplicate Values" los ntawm cov ntawv qhia zaub mov nco-down
Yog tias koj xav hloov pauv kom pom txhua qhov txiaj ntsig tshwj xeeb, koj tuaj yeem xaiv "Cim" tshwj xeeb
Kauj Ruam 7. Xaiv koj cov xim tseem ceeb
Cov xim tseem ceeb yuav xaiv qhov sib txawv. Lub neej ntawd yog lub teeb liab nrog cov ntawv tsaus tsaus.
Kauj Ruam 8. Nyem "OK" los saib koj cov txiaj ntsig
Kauj Ruam 9. Xaiv ib lub thawv uas sib theej thiab nias Rho tawm kom tshem nws
Koj yuav tsis xav rho tawm cov txiaj ntsig no yog tias txhua daim ntawm cov ntaub ntawv sawv cev rau qee yam (piv txwv li, daim ntawv tshuaj ntsuam).
Thaum koj rho tawm ib zaug ib zaug, nws tus khub tus nqi yuav plam nws qhov tseem ceeb
Kauj ruam 10. Nyem rau ntawm "Conditional Formatting" dua
Txawm hais tias koj tshem koj cov ntawv theej tawm lossis tsis yog, koj yuav tsum tshem tawm qhov ua kom pom tseeb ua ntej tawm ntawm daim ntawv.
Kauj Ruam 11. Xaiv "Clear Rules," tom qab ntawd "Clear Rules from Entire Sheet" kom tshem tawm cov qauv
Qhov no yuav tshem tawm qhov tseem ceeb nyob ib puag ncig ib qho twg koj tsis tau rho tawm.
Yog tias koj muaj ntau ntu ntawm koj daim ntawv nthuav tawm, koj tuaj yeem xaiv thaj chaw tshwj xeeb thiab nyem "Clear Rules from Selected Cells" kom tshem lawv qhov tseem ceeb
Kauj Ruam 12. Txuag koj daim ntawv hloov pauv
Yog tias koj txaus siab rau koj qhov kev kho dua tshiab, koj tau ua tiav pom thiab tshem tawm cov ntawv theej hauv Excel!
Txoj Kev 2 ntawm 2: Siv Excel's Tshem Tawm Cov Qauv Ua Ke
Kauj Ruam 1. Qhib koj thawj daim ntawv
Thawj qhov koj yuav tsum tau ua yog xaiv tag nrho cov ntaub ntawv koj xav tshuaj xyuas rau qhov sib tshooj.
Kauj Ruam 2. Nyem rau ntawm tes nyob rau sab saud sab laug ntawm koj cov ntaub ntawv
Qhov no pib txheej txheem xaiv.
Kauj Ruam 3. Tuav tus yuam sij ⇧ Shift thiab nyem lub cell kawg
Qhov kawg ntawm tes yog nyob rau sab xis sab xis ntawm koj cov ntaub ntawv. Qhov no yuav xaiv tag nrho koj cov ntaub ntawv.
Koj tuaj yeem ua qhov no nyob rau hauv ib qho kev txiav txim (piv txwv li, nyem rau ntawm lub npov sab xis sab xis ua ntej, tom qab ntawd hais meej los ntawm qhov ntawd)
Kauj Ruam 4. Nyem rau ntawm "Cov Ntaub Ntawv" tab nyob rau sab saum toj ntawm qhov screen
Kauj Ruam 5. Nrhiav ntu "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm lub cuab yeej
Tshooj lus no suav nrog cov cuab yeej los tswj hwm koj cov ntaub ntawv xaiv, suav nrog "Tshem Tawm Cov Khoom".
Kauj Ruam 6. Nyem "Tshem Tawm Cov Luam
" Qhov no yuav coj lub qhov rai hloov kho.
Kauj Ruam 7. Nyem "Xaiv Txhua
" Qhov no yuav txheeb xyuas txhua yam ntawm koj kab ntawv tau raug xaiv.
Kauj Ruam 8. Txheeb xyuas txhua kab uas koj xav siv lub cuab yeej no
Qhov chaw teeb tsa tau txheeb xyuas txhua kab.
Kauj Ruam 9. Nyem qhov "Kuv cov ntaub ntawv muaj cov ntawv", yog tias muaj
Qhov no yuav ua kom txoj haujlwm sau npe nkag thawj zaug hauv txhua kab ntawv ua kab ntawv, tso lawv tawm ntawm cov txheej txheem tshem tawm.
Kauj Ruam 10. Nyem "OK" kom tshem tawm cov ntawv sib dhos
Thaum koj txaus siab rau koj cov kev xaiv, nyem "OK". Qhov no yuav cia li tshem tawm txhua qhov muaj txiaj ntsig los ntawm koj qhov kev xaiv.
Yog tias txoj haujlwm qhia rau koj tias tsis muaj qhov theej tawm-tshwj xeeb tshaj yog tias koj paub muaj-sim tso ib qho kev txheeb xyuas ib sab ntawm ib tus zuj zus hauv "Remove Duplicates" window. Luam theej duab txhua kab ntawm ib lub sijhawm yuav daws qhov yuam kev ntawm no
Kauj Ruam 11. Txuag koj daim ntawv hloov pauv
Yog tias koj txaus siab rau koj qhov kev kho dua tshiab, koj tau ua tiav tshem tawm cov ntawv theej hauv Excel!
Lub tswv yim
- Koj tseem tuaj yeem txheeb xyuas qhov muaj txiaj ntsig zoo los ntawm kev teeb tsa tus neeg siv khoom thib peb ntxiv rau hauv. Qee qhov kev siv hluav taws xob no txhim kho Excel cov txheej txheem kev ua haujlwm kom pab tau koj siv ntau yam xim txhawm rau txheeb xyuas qhov muaj txiaj ntsig zoo.
- Kev tshem koj cov ntawv theej tawm tuaj yeem yooj yim thaum tshuaj xyuas cov npe tuaj koom, cov npe chaw nyob, lossis cov ntaub ntawv zoo sib xws.