Updated: November 18, 2026

If you are searching for google sheets how to edit a pivot table, the fastest path is to open the Pivot table editor and change the source, rows, columns, values, or filters from there. You do not edit a pivot table like normal cells, because the table is a summary built from source data. Once you know where the editor lives, most changes take less than a minute.

Open the Pivot Table Editor

The Pivot table editor appears in a sidebar when you click inside the pivot table. If you do not see it, you are probably selecting a normal cell outside the pivot range or the side panel was closed.

How to open the editor

  1. Click any cell inside the pivot table.
  2. Look for the Pivot table editor panel on the right side of the sheet.
  3. If the panel is hidden, click the pivot table again or choose the pivot table from the sheet area until the editor opens.

This is the core answer for google sheets pivot table editor, google sheets view pivot table editor, and google sheets how to open pivot table editor. The editor is where you change the layout, value summaries, filters, and sorting for the existing pivot.

Edit an Existing Pivot Table

To edit a pivot table in Google Sheets, use the editor sidebar to adjust the fields instead of typing into the displayed table. The table view updates from your choices in the editor, and direct cell edits inside the pivot output do not stick.

Change rows, columns, values, and summaries

  1. Open the Pivot table editor.
  2. Under Rows, add or remove the field you want to group by.
  3. Under Columns, add the field that should split the summary across columns.
  4. Under Values, click the value field and change the summary type if needed.
  5. Choose the calculation you need, such as Sum, Count, Average, or Counta.

If your question is google sheets pivot table count, the answer is in Values. Add the field you want to count, then set Summarize by to Count or Counta. Count ignores blank cells, while Counta counts non-empty cells.

Adjust the pivot table layout

To learn how to adjust pivot table settings in Google Sheets, use the same sidebar controls to move fields between Rows and Columns, change sort order, and rename custom labels. This is also how to edit pivot in Google Sheets when you want a different summary view without rebuilding the table from scratch.

Filter, Show Filter, and Slicer Options

Pivot table filters let you narrow the data before it is summarized. If your report looks too broad, add a filter inside the pivot editor instead of filtering the source sheet manually.

Add or change a pivot table filter

  1. Open the Pivot table editor.
  2. Find the Filters section.
  3. Click Add and choose the field you want to filter.
  4. Set the condition or values you want to include or exclude.

This covers google sheets pivot table filter and google sheets pivot table show filter. In the editor, the filter is the control point, and the visible pivot table updates to match. If you want a filter on the sheet itself rather than buried in the sidebar, use a slicer tied to the pivot table.

Use a slicer for interactive filtering

For google sheets pivot table filter slicer, insert a slicer and connect it to the pivot table or the source range. A slicer gives you clickable filter controls on the sheet, which is useful when other people need to change the view without opening the editor.

Move or Delete a Pivot Table

Moving and deleting a pivot table are separate actions. Moving changes where the output appears. Deleting removes the pivot table object from the sheet.

How to move a pivot table in Google Sheets

  1. Click inside the pivot table.
  2. Open the Pivot table editor if it is not already open.
  3. At the top of the editor, use the cell reference for the pivot table location.
  4. Cut the pivot table output range and paste it in the new location if you need the table elsewhere on the sheet.

If you want to move the pivot table without breaking your layout, make sure the destination range is empty. Google Sheets places the pivot output starting at the anchor cell, so nearby content can get overwritten.

How to delete a pivot table in Google Sheets

  1. Click any cell in the pivot table.
  2. Highlight the full pivot output range.
  3. Press Delete or Backspace.

If the pivot table keeps coming back, clear the pivot table object rather than just removing a few cells from the displayed output. That is the direct way to remove the report from the sheet.

Refresh a Pivot Table

Google Sheets refreshes pivot tables when the source data changes, but the table can lag if you are editing a large range or importing new rows. If you need to know how to refresh pivot in Google Sheets, the practical answer is to force the pivot to recalculate by changing its source or editing a field setting, then letting Sheets reprocess the summary.

How to refresh Google Sheets pivot table data

  1. Open the Pivot table editor.
  2. Check that the Data range includes all new rows and columns.
  3. If the range is too short, expand it to cover the added data.
  4. Change a setting in Values, Rows, or Filters, then change it back if needed.

This answers how do I refresh pivot table in Google Sheets, how do I refresh pivot in Google Sheets, and how to refresh data in Google Sheets pivot. The key point is that the pivot only summarizes the range it knows about, so a refresh starts with the correct source range.

Auto refresh pivot table Google Sheets

Google Sheets does not use a manual refresh button in the same way some desktop spreadsheet tools do. When the source data updates inside the covered range, the pivot recalculates automatically. If new data is not showing, the problem is almost always an incomplete source range, not the refresh setting.

Common Problems When Editing a Pivot Table

Most pivot table editing issues come from the source range, field placement, or the difference between a summary and a regular table. If the pivot looks wrong, check these points first.

The editor opens but changes do nothing

If the pivot table editor is open and your changes do not appear, the source data may be blank, the selected field may be in the wrong section, or the summary is still using an old field setup. Remove the field from Rows or Values, then add it again in the correct place.

The pivot output overwrites other cells

A pivot table expands as soon as you add more rows or columns in the editor. Leave open space around the anchor cell, especially if you expect the report to grow. If the output collides with nearby content, move the pivot to a blank area before expanding it.

The count is wrong

If your google sheets pivot table count is off, check whether you selected Count or Counta. Count ignores blanks, which changes the result when your source column has empty rows. If you need to count every non-empty entry, Counta is the correct option.

Frequently Asked Questions

How do I edit a pivot table in Google Sheets?

Click inside the pivot table, open the Pivot table editor, and change the fields in Rows, Columns, Values, or Filters. You do not edit the displayed summary cells directly.

How do I edit an existing pivot table without starting over?

Use the same pivot table editor and adjust the fields already in place. You can swap summaries, add filters, change grouping, or move fields between Rows and Columns without rebuilding the report.

How do I show a filter on a pivot table?

Add a field in the Filters section of the Pivot table editor. If you want a visible control on the sheet, add a slicer connected to the pivot table or its source data.

How do I delete a pivot table in Google Sheets?

Select the pivot table output and delete it. To fully remove the report, delete the pivot object from the sheet rather than clearing a few cells inside it.

Why is my pivot table not refreshing?

The most common cause is a source range that does not include the new data. Expand the data range in the Pivot table editor so the pivot can recalculate from the full dataset.