Thursday, November 4, 2021

How to Edit a Pivot Table in Excel

After you create a pivot table, you might need to edit it later. This wikiHow will show you how to edit a pivot table in Excel on your computer by adding or changing the source data. After you make any changes to the data for your Pivot Table, you will need to refresh it to see any changes.

[Edit]Steps

  1. Open your project in Excel. To do this, double-click the Excel document that contains your pivot table in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file that has your pivot table.
    Edit a Pivot Table in Excel Step 1.jpg
  2. Go to the spreadsheet page that contains the data for the pivot table. Click the tab that contains your data (e.g., Sheet 2) at the bottom of the Excel window.
    Edit a Pivot Table in Excel Step 2.jpg
  3. Add or change your data. Enter the data that you want to add to your pivot table directly next to or below the current data.
    Edit a Pivot Table in Excel Step 3.jpg
    • For example, if you have data in cells A1 through E10, you would add another column in the F column or another row in the 11 row.
    • If you simply want to change the data in your pivot table, edit the data here. It won't be reflected in the pivot table until you refresh the data, though.
  4. Go back to the pivot table tab. Click the tab on which your pivot table is listed.
    Edit a Pivot Table in Excel Step 4.jpg
  5. Select your pivot table. Click the pivot table to select it.
    Edit a Pivot Table in Excel Step 5.jpg
  6. Click the tab. It's in the middle of the editing ribbon that's at the top of the Excel window. Doing so will open a toolbar just below the editing ribbon.
    Edit a Pivot Table in Excel Step 6.jpg
    • On a Mac, click the PivotTable Analyze tab here instead.
  7. Click . This option is in the "Data" section of the Analyze toolbar. A drop-down menu will appear.
    Edit a Pivot Table in Excel Step 7.jpg
  8. Click . It's in the drop-down menu. Doing so opens a window.
    Edit a Pivot Table in Excel Step 8.jpg
  9. Select your data. Click and drag from the top-left cell in your data group down to the bottom-left cell in the group. This will include the column(s) or row(s) that you added.
    Edit a Pivot Table in Excel Step 9.jpg
  10. Click . It's at the bottom of the window.
    Edit a Pivot Table in Excel Step 10.jpg
  11. Click . It's in the "Data" section of the toolbar.
    Edit a Pivot Table in Excel Step 11.jpg
    • If you added a new column to your pivot table, check its box on the right side of the Excel window to display it.[1]

[Edit]References

[Edit]Quick Summary



from How to of the Day https://ift.tt/2ZWoTFT

No comments:

Post a Comment