Kab lus no yuav coj koj nkag mus rau cov ntaub ntawv rau hauv lub rooj pivot hauv Microsoft Excel. Phau ntawv qhia no tuaj yeem ua raws ntawm Windows thiab Mac version ntawm Microsoft Excel.
Kauj ruam
Kauj Ruam 1. Nyem ob npaug rau daim ntawv Excel uas muaj cov lus pivot
Daim ntawv yuav qhib.
Kauj Ruam 2. Nyem rau tab uas muaj cov ntaub ntawv koj xav nkag (piv txwv li Ntawv 2) nyob hauv qab ntawm lub qhov rai Excel
Kauj Ruam 3. Ntxiv lossis hloov cov ntaub ntawv koj xav ntxig rau hauv lub rooj pivot tom ntej lossis qis dua cov ntaub ntawv uas twb muaj lawm
- Piv txwv li, yog tias koj twb muaj cov ntaub ntawv hauv hlwb A1 txog E10, koj tuaj yeem nkag cov ntaub ntawv hauv kab F lossis kab 11.
- Yog tias koj tsuas xav hloov cov ntaub ntawv uas tshwm hauv lub rooj pivot, hloov cov ntaub ntawv ntawd hauv daim ntawv ua haujlwm nquag.
Kauj Ruam 4. Rov qab mus rau lub tab uas muaj cov lus pivot los ntawm txhaj rau lub npe tab
Kauj Ruam 5. Nyem rau lub rooj pivot kom xaiv nws
Kauj Ruam 6. Nyem rau Txheeb Xyuas khawm nyob hauv nruab nrab ntawm cov kab ntsuab hauv lub qhov rai Excel
Koj yuav pom lub cuab yeej tshiab hauv qab kab ntawv.
Yog tias koj siv Mac, nyem lub tab PivotTable Ntsuas.
Kauj Ruam 7. Nyem rau Hloov Cov Ntaub Ntawv Cov Ntaub Ntawv khawm hauv ntu "Cov Ntaub Ntawv" ntawm "Txheeb Xyuas" toolbar
Koj yuav pom cov ntawv qhia zaub mov nco-down.
Kauj Ruam 8. Los ntawm cov ntawv qhia zaub mov, nyem Hloov Chaw Cov Ntaub Ntawv…
Ib lub qhov rai tshiab yuav qhib.
Kauj Ruam 9. Xaiv koj cov ntaub ntawv
Nyem thiab luag tus cursor los ntawm sab tes laug sab laug mus rau hauv qab sab laug. Cov cell uas muaj cov ntaub ntawv koj tau nkag mus yuav raug xaiv ib yam nkaus.
Kauj ruam 10. Nyem OK hauv qab ntawm lub qhov rais
