Pivot ntxhuav yog lub zog muaj zog hauv Excel. Lawv muab kev yooj yim thiab kev txheeb xyuas lub zog rau hauv koj txhais tes. Pivot tables rho tawm cov ntaub ntawv los ntawm cov ntaub ntawv loj tsis siv cov qauv. Thaum koj pom cov ntaub ntawv koj xav kom suav nrog hauv lub rooj pivot, xws li cov ntaub ntawv suav nrog hauv cov lus qhia pivot, luam cov ntaub ntawv piv txwv rau hauv Excel daim ntawv ua haujlwm.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010; thiab Excel rau Microsoft 365.
Data for Excel Pivot Table Tutorial
Nov yog ib qho piv txwv ntawm cov ntaub ntawv koj yuav pom hauv cov lus qhia pivot:
| Cookie Muag los ntawm cheeb tsam | |||
|---|---|---|---|
| SalesRep | Region | Orders | Tag nrho Muag |
| Bill | West | 217 | $41, 107 |
| Frank | West | 268 | $72,707 |
| Harry | North | 224 | $41,676 |
| Janet | North | 286 | $87,858 |
| Joe | South | 226 | $45,606 |
| Martha | East | 228 | $49,017 |
| Mary | West | 234 | $57,967 |
| Ralph | East | 267 | $70,702 |
| Sam | East | 279 | $77,738 |
| Tom | South | 261 | $69,496 |
Yuav ua li cas luam cov ntawv nyeem
Ua raws cov kauj ruam no txhawm rau luam cov qauv ntaub ntawv rau hauv koj tus kheej cov ntaub ntawv Excel. Cov kauj ruam no muaj feem cuam tshuam rau txhua cov ntaub ntawv koj xav luam rau hauv Excel, tsis yog cov ntaub ntawv tshwj xeeb qhia hauv cov lus saum toj no.
- Highlight cov ntaub ntawv hauv cov lus saum toj no. Xaiv los ntawm lub npe Cookie Muag los ntawm cheeb tsam rau tus lej $69, 496 nyob rau hauv qab ntawm lub rooj.
-
Right-click (los yog kais-thiab-tuav) ib feem ntawm cov ntawv tseem ceeb thiab xaiv Copy los ntawm browser cov ntsiab lus qhia zaub mov.
Lwm txoj hauv kev los luam cov ntaub ntawv los ntawm lub rooj yog siv Ctrl+C (Windows) lossis Command+C (Mac) keyboard shortcut.
- Xaiv xovtooj A1 hauv daim ntawv ua haujlwm Excel dawb los ua kom nws lub cev muaj zog.
- mus rau Home tab.
-
In the Clipboard pab pawg, xaiv tus Paste poob xub.
Image - Choose paste tshwj xeeb.
-
In the Paste Special dialog box, xaiv Text.
Image - Xaiv OK txhawm rau muab cov ntaub ntawv tso rau hauv Excel.
- Txhua daim ntaub ntawv raug muab tso rau hauv ib lub xov tooj sib cais hauv daim ntawv ua haujlwm. Yog tias lub xov tooj A1 yog lub xov tooj ntawm tes thaum cov ntaub ntawv tau muab tso rau hauv daim ntawv ua haujlwm, cov ntaub ntawv tshwm nyob hauv thaj tsam A1 txog D12.
