Kev faib kab thiab kab hauv Excel cia koj tawg thiab nthuav cov ntu ntawm daim ntawv ua haujlwm. Qhov no tuaj yeem ua rau cov ntaub ntawv loj thiab nyuaj kom nkag siab ntau dua. Views ua compact thiab koom. Kab lus no qhia koj ib kauj ruam los ntawm kauj ruam yuav ua li cas pab pawg thiab saib koj cov ntaub ntawv.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010, 2007; Excel rau Microsoft 365, Excel Online thiab Excel rau Mac.
Pab pawg hauv Excel
Koj tuaj yeem tsim pab pawg los ntawm kev xaiv cov kab thiab kab ke los suav nrog, lossis koj tuaj yeem tau txais Excel kom pom cov pab pawg ntawm cov ntaub ntawv. Cov pab pawg kuj tuaj yeem ua zes hauv lwm pab pawg los tsim kom muaj ntau theem hierarchy. Thaum koj cov ntaub ntawv tau muab faib ua pawg, koj tuaj yeem nthuav dav thiab tawg pawg, lossis koj tuaj yeem nthuav dav thiab tawg tag nrho cov pab pawg ntawm ib qib hauv hierarchy.
Pab pawg muab txoj hauv kev muaj txiaj ntsig zoo rau kev taw qhia thiab saib cov ntawv loj thiab nyuaj. Lawv ua kom yooj yim dua los tsom rau cov ntaub ntawv tseem ceeb. Yog tias koj xav tau kev nkag siab ntawm cov ntaub ntawv nyuaj koj yuav tsum tau siv Cov Pab Pawg thiab tseem tuaj yeem tau txais txiaj ntsig los ntawm Power Pivot For Excel.
Yuav ua li cas siv Excel rau pab pawg kab Manually
Ua kom Excel pab pawg kab, txoj hauv kev yooj yim tshaj plaws yog thawj zaug xaiv cov kab koj xav kom suav nrog, tom qab ntawd ua rau lawv ua ib pab pawg.
-
Rau pawg kab uas koj xav ua pab pawg, xaiv thawj kab tus lej thiab rub mus rau tus lej kab kawg txhawm rau xaiv tag nrho cov kab hauv pawg.
Image -
Xaiv tus Data tab > Group > pab pawg , lossis xaiv yooj yim pab pawg , nyob ntawm seb Excel version koj siv.
Image -
Ib kab nyias yuav tshwm rau sab laug ntawm kab zauv, qhia txog qhov twg ntawm cov kab uas tau muab faib.
Image Xaiv tus minus (-) kom tawg pab pawg. Cov thawv me me uas muaj tus lej ib thiab ob kuj tshwm nyob rau sab saum toj ntawm thaj av no, qhia tias daim ntawv ua haujlwm tam sim no muaj ob theem hauv nws cov hierarchy: cov pab pawg thiab cov kab ib leeg nyob rau hauv pawg.
- Cov kab tau muab faib ua pawg thiab tam sim no tuaj yeem tawg thiab nthuav dav raws li qhov xav tau. Qhov no ua rau nws yooj yim dua los tsom rau cov ntaub ntawv cuam tshuam xwb.
Yuav ua li cas Manually Pab Pawg hauv Excel
Ua kom Excel pab pawg kab, cov kauj ruam yuav luag tib yam li ua rau kab.
-
Rau cov pab pawg ntawm kab ntawv koj xav ua pab pawg, xaiv thawj kab ntawv thiab luag txoj cai mus rau kab ntawv kawg, yog li xaiv txhua kab hauv pab pawg.
Image -
Xaiv tus Data tab > Group > Group Columns, lossis xaivGroup , nyob ntawm seb Excel version koj siv.
Image -
Ib kab nyias yuav tshwm rau saum kab ntawv. Cov kab no qhia txog qhov twg ntawm pawg pawg.
Image Xaiv tus minus (-) kom tawg pab pawg. Cov thawv me me uas muaj tus lej ib thiab ob kuj tshwm nyob rau sab saum toj ntawm thaj av no, qhia tias daim ntawv ua haujlwm tam sim no muaj ob theem hauv nws cov hierarchy rau txhua kab, nrog rau kab.
- Cov kab tau muab faib ua pawg thiab tam sim no tuaj yeem tawg thiab nthuav dav raws li xav tau.
Yuav ua li cas thiaj ua Excel pab pawg kab thiab kab Automatically
Thaum koj tuaj yeem rov ua cov kauj ruam saum toj no los tsim txhua pab pawg hauv koj cov ntaub ntawv, Excel tuaj yeem ntes cov ntaub ntawv pab pawg thiab ua rau koj. Excel tsim cov pab pawg uas cov qauv qhia txog ntau yam ntawm cov hlwb. Yog tias koj daim ntawv ua haujlwm tsis muaj cov qauv, Excel yuav tsis tuaj yeem tsim cov pab pawg.
Xaiv tus Data tab > Group > Auto Outline thiab Excel yuav tsim cov pab pawg rau koj. Hauv qhov piv txwv no, Excel raug txheeb xyuas txhua pawg ntawm kab. Vim tias tsis muaj tag nrho txhua xyoo rau txhua pawg kev siv nyiaj, nws tsis tau muab faib ua pawg.
qhov kev xaiv no tsis muaj nyob hauv Excel Online, yog tias koj siv Excel Online, koj yuav tsum tsim pab pawg manually.
Yuav ua li cas los tsim ib pawg Multi-Level Pawg Hierarchy hauv Excel
Hauv qhov piv txwv yav dhau los, pawg ntawm cov nyiaj tau los thiab cov nuj nqis tau muab faib ua ke. Nws yuav ua rau kev txiav txim siab los pab pawg tag nrho cov ntaub ntawv rau txhua xyoo. Koj tuaj yeem ua qhov no manually los ntawm kev siv tib cov kauj ruam raws li koj tau siv los tsim thawj theem ntawm pawg.
-
Xaiv tag nrho cov kab kom suav nrog.
Image - Select the Data tab > Pab > Pab pawg, lossis xaivGroup , nyob ntawm seb koj siv Excel version twg.
-
Lwm txoj kab nyias yuav tshwm rau sab laug ntawm cov kab uas sawv cev rau cov pab pawg uas twb muaj lawm thiab qhia txog qhov twg ntawm pawg tshiab ntawm kab. Cov pab pawg tshiab no suav nrog ob pawg uas twb muaj lawm thiab tam sim no muaj peb lub thawv me me nyob rau sab saum toj ntawm thaj av no, qhia tias daim ntawv ua haujlwm tam sim no muaj peb theem nyob rau hauv nws hierarchy.
Image - Daim ntawv nthuav qhia tam sim no muaj ob theem ntawm pab pawg, nrog ib tus kab hauv pawg.
Yuav ua li cas thiaj tsim tau ntau theem Hierarchy
Excel siv cov qauv txhawm rau txheeb xyuas ntau pawg, ib yam li nws siv lawv los txheeb xyuas ib pawg neeg. Yog tias tus qauv siv ntau dua ib qho ntawm lwm cov qauv uas txhais cov pab pawg, qhov no qhia tias cov pab pawg no yog ib feem ntawm pawg niam txiv.
Ua raws li cov piv txwv ntawm cov nyiaj tau los, yog tias peb ntxiv cov nyiaj tau los tag nrho rau txhua xyoo, uas tsuas yog cov nyiaj tau los rho tawm cov nuj nqis, ces qhov no tso cai rau Excel kom pom tias txhua xyoo yog pab pawg thiab cov nyiaj tau los thiab cov nuj nqis yog sub-groups nyob rau hauv no. Xaiv lub Data tab > Group > Auto Outline kom tau txais cov pab pawg ntau qib.
Yuav ua li cas nthuav thiab sib sau pawg
Lub hom phiaj ntawm kev tsim cov pab pawg ntawm kab thiab / lossis kab yog tias nws tso cai rau thaj chaw ntawm daim ntawv nthuav dav kom muab zais, muab cov ntsiab lus meej ntawm tag nrho cov ntawv nthuav qhia.
-
Yuav kom vau tag nrho cov kab, xaiv tus naj npawb 1 lub thawv nyob rau sab saum toj ntawm cheeb tsam mus rau sab laug ntawm kab zauv.
Image -
Xaiv tus tus lej ob lub thawvtxhawm rau nthuav thawj qib ntawm pab pawg thiab ua kom pom theem ob ntawm pab pawg. Cov kab ib leeg nyob rau hauv pawg thib ob tseem muab zais.
Image -
Xaiv tus nab npawb peb lub npov txhawm rau nthuav qib thib ob ntawm pab pawg kom cov kab ib leeg hauv cov pab pawg no kuj pom.
Image Nws tseem tuaj yeem nthuav dav thiab tawg ib pawg neeg. Txhawm rau ua li ntawd, xaiv qhov Plus (+) lossis Minus (-) uas zoo nkaus li kos rau pawg uas yog vau lossis nthuav dav. Ua li no, pab pawg ntawm ntau qib hauv hierarchy tuaj yeem pom raws li qhov xav tau.
