Thaum siv Microsoft Excel daim ntawv nthuav qhia nrog cov ntaub ntawv ntau, nws muaj peev xwm uas koj yuav pom tib qho nkag. Qhov "Cov Qauv Txheej Txheem" hauv Microsoft Excel tuaj yeem qhia koj qhov twg cov ntaub ntawv theej tawm yog, thaum "Tshem Tawm Cov Ntawv" cov yam ntxwv yuav tshem tawm cov ntawv theej tawm. Saib thiab tshem tawm cov ntawv theej tawm kom ntseeg tau qhov tseeb ntawm koj cov ntaub ntawv thiab kev nthuav qhia.
Kauj ruam
Txoj Kev 1 ntawm 2: Siv Txoj Cai Raws Li Txoj Cai
Kauj Ruam 1. Qhib cov ntawv
Thawj qhov koj yuav tsum tau ua yog xaiv tag nrho cov ntaub ntawv uas koj xav kom nrhiav tau cov ntawv theej ntawm.
Kauj Ruam 2. Nyem lub xovtooj ntawm tes nyob rau sab saud sab saud ntawm cov ntaub ntawv
Qhov no pib txheej txheem xaiv cov ntaub ntawv.
Kauj Ruam 3. Nias thiab tuav Shift qhov tseem ceeb, tom qab ntawd nyem lub cell kawg nyob rau hauv qab txoj cai kaum ntawm cov pab pawg
Qhov no yuav xaiv txhua cov ntaub ntawv koj tau teev tseg.
Koj tuaj yeem ua qhov no hauv lwm qhov kev txiav txim (piv txwv li, nyem rau sab xis sab xis ua ntej, tom qab ntawd hais meej cov ntaub ntawv tom ntej los ntawm qhov ntawd)
Kauj Ruam 4. Saib rau ntu "Cov Qauv" hauv cov cuab yeej
Thaj chaw no muaj cov cuab yeej rau kev teeb tsa cov ntaub ntawv, suav nrog "Cov Qauv Ua Qauv".
Kauj Ruam 5. Nyem rau "Conditional Formatting"
Qhov no yuav tso tawm cov ntawv qhia zaub mov nco-down.
Kauj Ruam 6. Xaiv "Highlight Cells Rules", tom qab ntawv nyem "Duplicate Values"
Nco ntsoov tias koj cov ntaub ntawv tseem tseem ceeb thaum ua li ntawd. Qhov no yuav qhib lub qhov rai program nrog cov kev xaiv teeb tsa hauv lwm cov ntawv qhia zaub mov nco.
Kauj Ruam 7. Xaiv "Duplicate Values" los ntawm cov ntawv qhia zaub mov nco-down
Yog tias koj xav kom pom txhua qhov txiaj ntsig uas tsis muaj qhov sib txawv, xaiv "Cim"
Kauj Ruam 8. Xaiv qhov xim uas koj xav tau
Cov xim tseem ceeb yuav qhia txog qhov theej tawm. Thawj xim yog liab nrog cov ntawv liab tsaus.
Kauj Ruam 9. Nyem "OK" kom pom qhov tshwm sim
Kauj Ruam 10. Xaiv lub npov theej tawm, tom qab ntawd nyem lub pob Rho tawm kom tshem nws
Tej zaum koj tsis xav tshem cov lej sib npaug yog tias txhua cov ntaub ntawv sawv cev rau qee yam (piv txwv li, daim ntawv tshuaj ntsuam).
Tom qab rho tawm cov ntawv theej tawm, tus khub ua ke poob nws qhov kev tsom teeb
Kauj Ruam 11. Nyem rau ntawm "Conditional Formatting" dua
Txawm hais tias koj tau tshem tawm cov theej tawm lossis tsis yog, koj yuav tsum tau tshem ntawm cov ntsiab lus ua ntej ua ntej kaw daim ntawv.
Kauj Ruam 12. Xaiv "Clear Rules", tom qab ntawd nyem "Clear Rules from Entire Sheet" kom tshem tawm cov ntawv teev npe
Qhov no yuav tshem tawm qhov tseem ceeb ntawm txhua qhov theej tawm uas koj tsis tau tshem tawm.
Yog tias muaj ntau qhov ntawm daim ntawv nthuav tawm, koj tuaj yeem xaiv thaj chaw tshwj xeeb thiab nyem "Clear Rules from Selected Cells" kom tshem tawm cov ntsiab lus
Kauj Ruam 13. Txuag daim ntawv hloov pauv
Yog tias koj txaus siab rau qhov kev hloov pauv, koj tau ua tiav pom thiab tshem tawm qhov sib tshooj hauv Excel!
Txoj Kev 2 ntawm 2: Siv Kev Tshem Tawm Cov Qauv Ua Ntej hauv Excel
Kauj Ruam 1. Qhib cov ntawv
Thawj qhov koj yuav tsum tau ua yog xaiv tag nrho cov ntaub ntawv uas koj xav kom nrhiav tau cov ntawv theej ntawm.
Kauj Ruam 2. Nyem lub xovtooj ntawm tes nyob rau sab saud sab saud ntawm cov ntaub ntawv
Qhov no pib txheej txheem xaiv cov ntaub ntawv.
Kauj Ruam 3. Nias thiab tuav Shift qhov tseem ceeb, tom qab ntawd nyem lub cell kawg nyob rau hauv qab txoj cai kaum ntawm cov pab pawg
Qhov no yuav xaiv txhua cov ntaub ntawv koj tau teev tseg.
Koj tuaj yeem ua qhov no hauv lwm qhov kev txiav txim (piv txwv li, nyem rau sab xis sab xis ua ntej, tom qab ntawd hais meej cov ntaub ntawv tom ntej los ntawm qhov ntawd)
Kauj Ruam 4. Nyem rau "Cov Ntaub Ntawv" tab nyob rau sab saum toj ntawm lub vijtsam
Kauj Ruam 5. Nrhiav ntu "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm lub cuab yeej
Tshooj lus no muaj cov cuab yeej rau kev hloov kho cov ntaub ntawv xaiv, suav nrog "Tshem Tawm Cov Khoom".
Kauj Ruam 6. Nyem "Tshem Cov Luam"
Qhov no yuav qhib qhov program program window.
Kauj Ruam 7. Nyem "Xaiv Txhua" kom paub tseeb tias txhua kab ntawv tau xaiv
Kauj Ruam 8. Zuam kab uas koj xav tshuaj xyuas siv lub cuab yeej no
Kev teeb tsa thawj zaug tau xaiv txhua kab.
Kauj Ruam 9. Nyem qhov "Kuv cov ntaub ntawv muaj headers" xaiv, yog tias koj siv headers
Qhov no yuav qhia rau txoj haujlwm tias thawj zaug nkag mus hauv txhua kab ntawv yog lub taub hau, yog li cov ntawv nkag yuav raug hla los ntawm cov txheej txheem tshem tawm.
Kauj Ruam 10. Nyem "OK" ib zaug txaus siab rau koj qhov kev xaiv
Qhov no yuav txiav tawm txhua qhov theej tawm uas koj tau teev tseg.
Yog tias qhov program qhia koj tias tsis pom muaj qhov theej tawm, tshwj xeeb tshaj yog tias koj paub tias muaj, txheeb xyuas cov haujlwm hauv qhov "Tshem Tawm Cov Ntawv" Cov qhov rai qhov rai. Txheeb xyuas kab ib los ntawm ib qho yuav daws txhua qhov yuam kev hauv ntu no
Kauj Ruam 11. Txuag daim ntawv hloov pauv
Yog tias koj txaus siab rau qhov kev hloov pauv, koj tau ua tiav tshem tawm cov ntawv theej hauv Excel!
Lub tswv yim
- Koj kuj tseem tuaj yeem pom cov ntawv theej los ntawm kev txhim kho cov cuab yeej thib peb ntxiv. Qee qhov ntawm cov cuab yeej no txhim kho Excel's "Cov Qauv Ua Qauv" ua kom koj tuaj yeem siv cov xim sib txawv los txheeb xyuas qhov sib txawv.
- Kev tshem tawm cov ntawv theej tawm yog qhov tsim nyog rau tshuaj xyuas cov npe qhua, chaw nyob, lossis lwm yam ntaub ntawv zoo sib xws.
