New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Pivot table editor missing

Google Sheets · Verified tutorial

Pivot table editor missing in Google Sheets

Create a complete pivot table on a new sheet using all of A1:D6. Put Region in Rows and Revenue in Values summarized by SUM.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Create a complete pivot table on a new sheet using all of A1:D6. Put Region in Rows and Revenue in Values summarized by SUM.

Step-by-step

1

Select the targetCreate a complete pivot table on a new sheet.

2

Complete the next actionall of A1:D6.

3

Apply the changePut Region in Rows and Revenue in Values summarized by SUM.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A pivot table groups the source rows by Region and sums Revenue.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:D6 and repeat the final action. A pivot table groups the source rows by Region and sums Revenue.

Example spreadsheet data

This is the clean fixture used for the verified run.

Region	Owner	Category	Revenue
North	Anna	Software	120
South	Ben	Services	180
North	Cara	Services	240
West	Dev	Software	210
South	Eva	Software	160

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a complete pivot table on a new sheet.
Complete the next action. all of A1:D6.
Apply the change. Put Region in Rows and Revenue in Values summarized by SUM.
A pivot table groups the source rows by Region and sums Revenue.