How to Open a Pivot Table Menu in Google Sheets

To open the pivot table controls in Google Sheets, click any cell inside the pivot table; the Pivot table editor should appear in a sidebar on the right. Sheets does not use a separate, always-visible Pivot Table menu like some spreadsheet programs, so selecting the table is the key step.

Where the Pivot Table Menu Is

The phrase pivot table menu can mean two different things: the controls for editing an existing pivot table, or the command for creating one. For an existing table, the main controls are in the Pivot table editor sidebar. Click a cell within the pivot table to select it and open that editor. Its sections let you configure Rows, Columns, Values, and Filters.

To create a new pivot table, use the top menu instead: select the source data, then choose Insert > Pivot table. That command opens a setup dialog; it is not the editor for an existing pivot table. Keeping these two actions distinct makes it easier to find the right control: select a pivot table to edit it, or use Insert to create one.

Open or Reopen the Editor

In a desktop web browser, follow these steps:

Open the Google Sheets spreadsheet containing the pivot table.
Click a cell that belongs to the pivot table, such as a row label, a column heading, or a summarized value.
Look at the right side of the sheet for the Pivot table editor. If it is not visible, click another cell clearly inside the pivot table and check again.
Use the editor’s Add controls or field lists to change the table’s layout, summaries, or filters.

Make sure the selected cell is part of the pivot table, not merely a nearby blank cell or a cell in the original source data. Clicking the source range selects ordinary data and does not open the pivot editor. If the sidebar is open but narrow, widen the browser window or zoom out slightly so the controls are easier to see.

What You Can Change in the Editor

The editor organizes pivot table fields into four areas. A field is usually a column from the source data, such as Region, Product, Date, or Sales. Add the same field to different areas when you need to group, summarize, or filter the records in different ways.

Rows: Groups records down the left side. Adding Region here can create one row for each region.
Columns: Splits results across the top. Adding Month here can show a separate column for each month.
Values: Calculates a summary from a field, such as a sum, count, or average, depending on the data and available summary choices.
Filters: Limits which source records are included in the pivot table, for example to show only one product category.

After adding a field, you can often adjust its options, including how items are sorted or summarized. Available choices depend on the field and the pivot table configuration. For example, averaging a column of numeric sales amounts is meaningful, while averaging names is not. If the results look unexpected, check both the field’s data type and the summary setting.

Create a Pivot Table Before Opening Its Editor

If there is no pivot table in the sheet yet, first select the data you want to summarize. Include the column headers, and make sure each column has a clear header. Then choose Insert > Pivot table. In the dialog, choose whether to place the pivot table in a new sheet or in an existing sheet, and confirm the selection. Sheets creates the table and opens its editor so you can choose fields.

A compact, rectangular source range is easiest to work with: one header row followed by records, with each column holding one kind of information. Avoid blank header cells and merged cells in the source range. For instance, a sales list might have columns for Date, Region, Product, and Amount, with one sale per row. In the editor, add Region to Rows, Product to Columns, and Amount to Values to build a cross-tabulation of sales.

Choosing a source range carefully matters. If you select A1:D100, the pivot table is based on that range. New records entered below row 100 may not be included because they fall outside it. If you expect the list to grow, choose a source range that accommodates future entries or update the pivot table’s source range when necessary. Verify the range shown in the setup dialog rather than assuming Sheets will include every later row.

A Practical Example: Summarize Sales by Region

Suppose a sheet has four columns: Date, Region, Product, and Amount. Each row records one sale. A useful summary could show total sales for each product in each region. Select the source table, including its headers, and create a pivot table with Insert > Pivot table. In the editor, add Region to Rows, Product to Columns, and Amount to Values.

Check the Values setting to confirm that Amount is being summed rather than counted. The resulting table shows regions down the side and products across the top, with each intersection representing the total amount for that combination. Add Date to Filters if you want to limit the records to a particular period, or use a date grouping option if one is available for the chosen field. This example illustrates why the editor is more useful than a simple drop-down menu: it controls both the grouping structure and the calculation.

To change the question the pivot table answers, edit the fields rather than rearranging the original data. For example, move Product from Columns to Rows to list products under each region. Remove a field with its remove control if you no longer need that grouping. The source data remains the underlying record list; the pivot table is a summarized view of it.

Common Problems and How to Fix Them

The editor does not appear: Click a cell inside the pivot table itself. A nearby cell, chart, or source-data cell will not open the pivot editor. If the table is on another sheet, open that sheet first.
You can see the table but cannot edit it: Check whether you have edit access to the spreadsheet. View-only access allows you to inspect the file but does not grant permission to change its pivot table configuration.
A field is missing from the editor: Check the source range and its header row. A column outside the selected range, or a blank or unclear header, may not appear as an expected field. Adjust the source range if it excludes the data you need.
The totals seem wrong: Inspect the Values field’s summary choice and the source values. Amounts stored as text may not behave like numeric amounts, and blank or inconsistent entries can affect a count or other summary.
New records are missing: Confirm that the pivot table’s source range includes the added rows. Editing data inside the range is different from appending records below its end.
The sidebar is difficult to find: Use Sheets in a desktop browser and make enough room for the right-hand panel. The mobile app and a narrow phone screen have a different, more limited editing experience.

These checks address different causes. A missing sidebar is usually a selection or screen-layout issue; missing results are more often a source-range or data-quality issue. Changing a summary setting will not fix a range that omits the records, so check the source before rebuilding the layout.

How Sheets Differs from Excel

In Google Sheets, the existing pivot table’s editing controls are presented in a sidebar. Microsoft Excel for Microsoft 365 on Windows generally presents pivot-table commands through contextual ribbon tabs when a pivot table is selected. So if you are following Excel instructions that say to open a PivotTable Analyze tab, that path does not apply to Google Sheets.

Sheets also has the separate creation path Insert > Pivot table. The same general idea—choose source data, then assign fields to row, column, value, or filter areas—exists in both programs, but the interface and exact options differ. When following instructions, check that they are written for Google Sheets in a browser rather than Excel or the Sheets mobile app.

Frequently Asked Questions

How do I open the Pivot table editor in Google Sheets?
Click a cell inside the existing pivot table. The Pivot table editor should open on the right side of the sheet.

Where is the Pivot table menu in Google Sheets?
For an existing pivot table, its editing controls are in the right-hand editor sidebar rather than a dedicated top-level menu. To make a new pivot table, use Insert > Pivot table.

Why is the Pivot table editor not showing?
You may have selected a cell outside the pivot table. Click a value or label within the table, and check that you are in the sheet containing it and have permission to edit the file.

Can I edit a pivot table in the Google Sheets mobile app?
The mobile interface differs from the desktop browser and may not offer the same full set of pivot-table editing controls. For the clearest access to the editor and its field options, open the spreadsheet in Sheets on a computer.

How do I add a field to a Google Sheets pivot table?
Select the pivot table to open its editor, then use the Add control for Rows, Columns, Values, or Filters and choose the source column you want. The area you choose determines how that field affects the summary.

Does a pivot table include rows I add later?
Only if those rows fall within its source range. If newly added records are outside that range, edit the source range so it covers them, then check that the summary includes the new data.

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.