Kev ua haujlwm ntawm kev txheeb xyuas cov ntaub ntawv hauv cov ntaub ntawv nthuav tawm Excel los ntawm Microsoft Office suite ntawm cov kev pab cuam feem ntau xav tau thaum ua haujlwm nrog cov ntaub ntawv ntawm cov ntaub ntawv. Tau kawg, daim ntawv thov no tsis muaj cov yam ntxwv zoo uas ua rau kev siv rau kev ua haujlwm nrog lub chaw tswj kev tswj hwm - piv txwv li hauv Kev Nkag Mus. Txawm li cas los xij, muaj lub peev xwm zoo txaus rau kev ua haujlwm nrog cov teeb meem uas tsis yooj yim thiab voluminous.
Nws yog qhov tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Qhib cov ntaub ntawv nthuav dav hauv Microsoft Excel uas nws cov ntaub ntawv xav tau xaiv.
Kauj ruam 2
Yog tias koj xav txheeb los ntawm cov ntaub ntawv ntawm tsuas yog ib kem, tom qab ntawd ces nyem txoj nyem txhua lub xov tooj ntawm nws. Nyob rau hauv cov ntawv qhia zaub mov uas yuav ua rau pom qhov kev ua no, nthuav "Seem" ntu. Nws muaj tsib txoj hauv kev los npaj koj cov ntaub ntawv - xaiv cov kev xaiv uas koj xav tau. Cov khoom siv ob sab saum toj yog npaj rau kev txheeb hauv nce thiab nqis, thiab lwm qhov peb tso cov kab no thaum pib ntawm lub rooj uas cov hlwb ntawm kem no tau hais nrog xim, font lossis cim.
Kauj ruam 3
Daim ntawv sau luv ntawm cov npe no tseem tuaj yeem hu tau los ntawm cov ntawv qhia zaub mov ntawm cov ntawv sau hloov - rau qhov no, siv cov Khawm Xaiv hauv cov pab pawg Editing ntawm cov lus txib ntawm Lub Tsev tab. Hauv qhov no, daim ntawv yuav tsuas muaj nce thiab nqis raws cov lus txib.
Kauj ruam 4
Yog tias koj xav tau cov ntaub ntawv txheeb los ntawm ntau cov kab lus ib zaug, xaiv cov kab "Custom sorting" - nyob rau hauv ob qho ntawm cov kev xaiv tau piav qhia saum toj no, nws muaj nyob hauv cov ntawv qhia ua ib yam khoom ntxiv.
Kauj ruam 5
Tom qab xaiv cov khoom no, lub qhov rais cais tshwm nyob ntawm qhov screen rau teeb tsa qhov kev txiav txim. Hauv kab ntawv "Sort by" nco, xaiv kab ntawv uas nws cov ntaub ntawv yuav tsum tau txheeb ua ntej. Hauv cov ntawv zoo sib xws hauv qab qhov xaiv, xaiv qhov khoom xaj - tus nqi, xim, font, lossis lub cim. Hauv daim ntawv teev 3 hauv qab, teev cov lus txiav txim - nce, nqis los sis raws li daim ntawv teev tseg. Thaum koj xaiv qhov khoom thib peb, lub qhov rais ntxiv yuav qhib, uas koj yuav tsum nkag mus rau koj daim npe, lossis xaiv ib qho ntawm cov uas twb muaj lawm.
Kauj Ruam 6
Txhawm rau teeb tsa qib tom ntej ntawm kev xaiv, nyem "Ntxiv qib" khawm thiab lwm kab uas tau sau tib yam nkaus yuav poob qhov rai. Rov ua dua nrog lawv cov haujlwm ntawm theem yav dhau los. Yog tias xav tau ntau qib ntxiv, rov ua cov kauj ruam no ntau npaum li qhov tsim nyog.
Kauj Ruam 7
Nyem OK, thiab Excel yuav txheeb cov ntaub ntawv raws li cov phiaj xwm tau muab.
