Edit a Pivot Table in Google Sheets: Steps and Tips

To edit a pivot table in Google Sheets, click any cell inside it to open the Pivot table editor on the right. Use the editor to add, remove, or rearrange fields under Rows, Columns, Values, and Filters; edit the source range at the top if the table needs to include different data.

What editing a pivot table changes

A pivot table summarizes data from a source range without changing the underlying records. Editing the pivot changes how that data is grouped, filtered, sorted, or summarized. For example, a sales pivot could show total revenue by region, then be changed to show revenue by salesperson within each region.

The distinction between the pivot and its source is important: the pivot’s displayed totals are results, not ordinary input cells. You generally cannot type over a total to correct it. Instead, correct the source record or adjust the pivot’s settings. This keeps the summary consistent with the data it represents.

Google Sheets saves changes automatically. When you alter a source cell already included in the range, the pivot usually recalculates to reflect the edit. If you add new records beyond the range, however, you may need to expand the range in the editor.

Open the Pivot table editor

Open the spreadsheet in Google Sheets in a web browser.
Click a cell inside the pivot table, rather than a nearby blank cell or the original data.
Look for the Pivot table editor panel on the right. If you do not see it, click another cell within the pivot table to reopen it.
Use the editor’s Add controls or the field settings to make changes. Changes appear in the sheet as you work.

If you are unsure whether you selected the pivot, click a cell containing a row label or summary value. A normal cell selection will not show the pivot editor. Also check that you have permission to edit the spreadsheet; view-only access does not allow changes to the pivot configuration.

Change rows, columns, and values

The editor organizes the pivot’s fields into four sections. Each field usually corresponds to a column header in the source data. The same field can sometimes be used in more than one section, depending on the summary you need.

Rows: Creates the categories listed down the left side, such as product or salesperson.
Columns: Splits the summary across the top, such as sales by month.
Values: Calculates a measure, such as total sales, record count, or average order amount.
Filters: Limits which source records contribute to the pivot, such as keeping only one region.

To add a field, click Add in the relevant section and choose a source column. To remove one, use the remove control beside the field in the editor. You can change the order of row or column fields by dragging them in the section; the order affects how categories are nested. For example, placing Region above Salesperson gives each region a group of salespeople, while reversing them groups regions beneath each salesperson.

For a value field, open its settings to choose how it is summarized. A numeric field may default to SUM, while text or mixed data may be counted. Choose an appropriate option such as SUM, AVERAGE, COUNT, or COUNTA, depending on the question. If a revenue field is unexpectedly counted instead of totaled, check that its source values are numbers rather than text. The field’s “Show as” setting can also display results as a percentage of a row, column, or grand total where that option is available.

Change the source data range

The source range determines which rows and columns the pivot can use. Select the pivot table and inspect the data range shown near the top of the Pivot table editor. Click the range control to enter or select a different range, then confirm it. Use a range that includes every required header and record, but avoid including unrelated notes or totals that could be treated as data.

For example, if a pivot uses source rows 1 through 200 and you append records in rows 201 through 220, those new records may not appear until the source range includes them. Expand the range to cover the added rows. If you expect to append data often, choose a range with room for future records, while keeping the header row and column structure consistent.

Check the source before changing the range: the first row should contain clear column headers, and each record should use the same column layout. A blank or duplicated header can make fields confusing or unavailable. If the source is on another sheet, include the sheet name in the range when selecting or entering it. Take care not to select the pivot output itself as its own source.

Sort, filter, and group pivot results

Field settings let you control the order and selection of categories. In a Rows or Columns field, use its sort options to sort by the field’s labels or by a value field. Sorting by a total is useful when you want the highest-selling products at the top rather than an alphabetical list. Choose ascending or descending order according to the comparison you are making.

To restrict the records used in the summary, add a field under Filters and choose which items to include or exclude. For example, a Region filter can show only West-region sales while retaining the same row and value layout. A filter changes the pivot’s calculation; it does not delete or hide the corresponding records in the source table. Review active filters if totals seem lower than expected.

Date fields can often be grouped to make a summary easier to read. In the pivot, right-click a date value and look for Create pivot date group, then choose a suitable interval such as month, quarter, or year if offered. Grouping is useful when individual dates create too many rows. If the grouping option is absent or dates do not group correctly, check that the source cells contain actual date values rather than text that merely looks like a date.

Example: revise a sales summary

Suppose a source sheet has columns for Date, Region, Product, Salesperson, and Revenue. A pivot currently lists total revenue by product. To compare performance by region and product, select the pivot and add Region to Rows above Product. Keep Revenue in Values and confirm that it summarizes by SUM. The result nests product totals under each region.

To compare the mix across months, add Date to Columns and group the dates by month if the source dates are valid. To focus on one salesperson, add Salesperson under Filters and select that person. If the table shows a count instead of revenue, inspect the Revenue source column for numbers stored as text, then correct those source values. The pivot’s settings determine the layout; the source records determine the figures.

Common problems and how to fix them

The editor does not appear: Click a cell inside the pivot output. If the sheet is view-only, request edit access.
New records are missing: Expand the source data range so it includes the added rows or columns.
A field is missing: Check that the source range includes its column and that the header row is complete. Then reopen or inspect the editor.
Numbers are counted, not summed: Check for text values, blanks, or inconsistent entries in the source column and choose the intended summary method.
Totals look wrong: Review filters, the selected source range, duplicate records, and the value field’s summary setting.
Editing a pivot cell does not stick: Pivot output is generated from its source and configuration. Change the source data or the editor settings rather than typing over the result.

When troubleshooting, compare a small sample of source records with the pivot. A total can be mathematically correct for the selected range but still be misleading if the range omits recent rows or a filter excludes a category. If the data has been reorganized, verify that each field still represents the intended kind of information.

Google Sheets and Excel pivots

Google Sheets uses a side-panel editor, while Excel for Microsoft 365 generally uses the PivotTable Fields pane and ribbon commands. The concepts—source data, rows, columns, values, and filters—are similar, but the controls and some capabilities differ. Instructions for Excel’s ribbon should not be followed as if they were Google Sheets menu paths.

In Sheets, editing a pivot in a browser is collaborative: other editors may see changes as the spreadsheet updates. If several people are working in the same file, agree on the intended layout and avoid changing the source structure while someone else is configuring the pivot. For a major redesign, making a copy of the sheet first can preserve the original summary for comparison.

Frequently Asked Questions

Can I edit a pivot table by typing into its cells?
Not reliably. Pivot cells are generated from the source data and pivot settings, so typing over a result does not change the underlying calculation. Edit the source record or use the Pivot table editor to change the summary.

How do I add a new column to a Google Sheets pivot table?
Click inside the pivot, then add the desired source field under Columns in the editor. If the field is not listed, make sure the source range includes that column and has a usable header.

Why is my pivot table not updating?
Edits to data already within the source range are generally reflected automatically. Newly appended rows may fall outside that range, so check the range at the top of the editor and expand it when necessary.

Can I change the source data after creating a pivot table?
Yes. Select the pivot and change its data range in the editor. Keep the replacement range structured with a header row and consistent columns so the existing fields can be mapped sensibly.

How do I remove a field from a pivot table?
Open the pivot editor and remove the field from the section where it appears, such as Rows, Values, or Filters. Removing a field from the pivot does not delete that column from the source sheet.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.