Excel tus Subtotal feature ua haujlwm los ntawm inserting lub SUBTOTAL muaj nuj nqi rau hauv ib lub database los yog ib daim ntawv teev cov ntaub ntawv muaj feem xyuam. Siv cov Subtotal feature ua kev tshawb nrhiav thiab muab cov ntaub ntawv tawm los ntawm ib lub rooj loj ntawm cov ntaub ntawv ceev thiab yooj yim.
Txawm tias nws yog hu ua "Subtotal feature", koj tsis tas rau kev nrhiav cov nyiaj los sis tag nrho rau cov kab ntawv xaiv ntawm cov ntaub ntawv. Ntxiv nrog rau tag nrho, koj tuaj yeem nrhiav qhov nruab nrab qhov tseem ceeb rau txhua kem los yog cov lus teb ntawm koj cov ntaub ntawv. Cov kauj ruam no yog kauj ruam qhia muaj xws li ib qho piv txwv ntawm qhov yuav nrhiav qhov nruab nrab qhov tseem ceeb rau ib kem ntawm cov ntaub ntawv hauv cov ntaub ntawv. Cov kauj ruam hauv phau ntawv no yog:
- Nkag mus rau Cov Ntawv Qhia Tawm
- Txheeb Cov Qauv Cov Ntaub Ntawv
- Nrhiav Cov Nqi Nruab Nrab
01 ntawm 02
Nkag mus rau Cov Ntaub Ntawv Xov Xwm Ntawm Tag Nrho
Nkag mus rau Cov Ntaub Ntawv Xov Xwm Ntawm Tag Nrho
Lus Cim: Rau kev pabcuam ntawm cov lus qhia no saib daim duab saum toj no.
Thawj kauj ruam uas siv cov Subtotal feature hauv Excel yog nkag mus rau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .
Thaum ua li ntawd, khaws cov lus hauv qab no:
- Nws yog ib qho tseem ceeb kom nkag mus rau cov ntaub ntawv kom raug. Tsis raug teeb meem, vim yog cov ntaub ntawv nkag tsis raug, yog lub hauv paus ntawm ntau cov teeb meem ntsig txog kev tswj xyuas cov ntaub ntawv.
- Tsis txhob sau ntawv tsis muaj dab tsi los yog txhua kab ntawv thaum nkag mus rau hauv cov ntaub ntawv. Qhov no suav nrog TSIS tawm hauv kab sab nraud ntawm kem npe thiab thawj kab ntawm cov ntaub ntawv.
Rau no nyeem:
Sau cov ntaub ntawv rau hauv hlwb A1 rau D12 raws li pom hauv daim duab saum toj no. Rau cov neeg uas tsis xav zoo li typing, cov ntaub ntawv, cov lus qhia rau kev luam mus rau hauv Excel, muaj nyob rau ntawm qhov txuas no.
02 ntawm 02
Sorting Cov Ntaub Ntawv
Sorting Cov Ntaub Ntawv
Lus Cim: Rau kev pabcuam ntawm cov lus qhia no saib daim duab saum toj no. Nyem rau ntawm daim duab kom loj.
Ua ntej subtotals tau ua ntawv thov, koj cov ntaub ntawv yuav tsum tau muab tso ua ke los ntawm kem ntawm cov ntaub ntawv koj xav muab cov ntaub ntawv tawm los ntawm. Qhov kev sib koom tes no yog siv Excel's Sort feature .
Nyob rau hauv qhov kev nyeem no, peb xav nrhiav qhov nruab nrab ntawm cov khoom txiav txim ib thaj chaw muag khoom ces cov ntaub ntawv yuav tsum tau muab xa los ntawm Cheeb Tsam sab xa.
Txheeb Xyuas Cov Ntaub Ntawv Nrug ntawm Muag Khoom Thaj Tsam
- Xaiv lub hlwb A2 rau D12 los qhia lawv. Nco ntsoov tsis pub muaj lub npe ntawm kab ntawv hauv koj xaiv.
- Nias rau ntawm cov ntaub ntawv ntawm txoj hlua .
- Ndliv lub Nres Khawm nyob nruab nrab ntawm cov ntaub ntawv xov ribbon qhib qhov khawm sib tham .
- Xaiv qhov Tsi los ntawm Thaj Tsam los ntawm daim ntawv teev npe hauv qab ntawm Kem sau npe hauv lub thawv ntawv.
- Nco ntsoov tias Kuv cov ntaub ntawv muaj cov npe yog kos nyob rau saum toj kawg kiag sab xis ntawm lub thawv ntawv.
- Nyem OK.
- Cov ntaub ntawv nyob rau hauv hlwb A3 rau D12 yuav tsum tam sim no sorted alphabetically los ntawm thib ob kem Region . Cov ntaub ntawv rau peb muag reps ntawm cheeb tsam East yuav tsum raug sau ua ntej, tom qab North, ces South, thiab thaj tsam West thaj tsam.