Yuav ua li cas rho tawm Pivot Tables hauv Excel

Cov txheej txheem:

Yuav ua li cas rho tawm Pivot Tables hauv Excel
Yuav ua li cas rho tawm Pivot Tables hauv Excel
Anonim

Yuav Paub

  • Xaiv lub xovtooj ntawm lub rooj pivot thiab nyem PivotTable Analyze. Nyem Select > Tag Nrho Pivot Table thiab nias Delete txhawm rau rho tawm lub rooj pivot.
  • Khaws cov ntaub ntawv: Xaiv ib lub xovtooj thiab nyem PivotTable Analyze. Teeb lub rooj, right-click a cell, xaiv Copy, thiab mus rau Paste > Paste Values.
  • Delete tsuas yog cov ntaub ntawv: Xaiv ib lub xovtooj thiab nyem PivotTable Analyze. Nias lub rooj thiab nias Clear > Ncua Txhua khaws cia xwb lub rooj.

Kab lus no piav qhia yuav ua li cas tshem tawm cov lus pivot, uas txheeb, teeb tsa, thiab xaus koj cov ntaub ntawv, hauv Microsoft Excel. Cov lus qhia npog Excel 2019, Excel 2016, thiab Microsoft 365.

Yuav ua li cas rho tawm Pivot Table hauv koj daim ntawv ua haujlwm

Ua raws cov kauj ruam no kom tshem tawm ob lub rooj nws tus kheej thiab cov ntsiab lus tsim los ntawm lub rooj.

  1. Xaiv ib lub xov tooj ntawm koj lub rooj pivot, tom qab ntawd xaiv PivotTable Analyze hauv kab.

    Image
    Image
  2. Click Select > Tag Nrho Pivot Table txhawm rau qhia tag nrho lub rooj.

    Image
    Image
  3. Nias lub Delete tus yuam sij kom rho tawm lub rooj pivot.

Yuav ua li cas rho tawm Pivot Table thiab khaws cov ntaub ntawv

Ua raws cov kauj ruam no yog tias koj xav rho tawm lub rooj pivot tab sis khaws cov ntaub ntawv hauv nws.

  1. Xaiv ib lub xov tooj ntawm koj lub rooj pivot, tom qab ntawd xaiv PivotTable Analyze hauv kab.

    Image
    Image
  2. Click Select > Tag Nrho Pivot Table txhawm rau qhia tag nrho lub rooj.

    Image
    Image
  3. Right-click ib lub xovtooj ntawm lub ntsiab lus pivot thiab xaiv Copy.
  4. Go to Paste > Paste Values txhawm rau muab cov ntaub ntawv tso rau hauv daim ntawv ua haujlwm.

    Image
    Image
  5. Highlight lub rooj pivot dua thiab nias Delete kom tshem tawm lub rooj.

Yuav ua li cas rho tawm cov ntaub ntawv thiab khaws cov lus Pivot

Thaum koj muaj cov ntsiab lus koj xav tau, koj tuaj yeem tshem tag nrho cov ntaub ntawv kom koj tuaj yeem tshuaj xyuas cov ntaub ntawv tshiab yam tsis tas yuav tsim lub rooj pivot tshiab.

  1. Xaiv ib lub xov tooj ntawm koj lub rooj pivot, tom qab ntawd xaiv PivotTable Analyze hauv kab.

    Image
    Image
  2. Click Select > Tag Nrho Pivot Table txhawm rau qhia tag nrho lub rooj.

    Image
    Image
  3. Click Clear > Clear All kom tshem tawm cov ntaub ntawv yam tsis tas yuav tshem koj lub rooj pivot.

    Image
    Image

Pom zoo: