View Pivot Table Fields in Google Sheets

To view pivot table fields in Google Sheets, click any cell inside the pivot table; the Pivot table editor opens on the right and lists the source columns you can add under Rows, Columns, Values, or Filters. If you cannot see the editor, make sure a cell in the pivot table—not just its source data—is selected, then look along the right side of the sheet for the panel.

What Pivot Table Fields Represent

A pivot table field is a column from the source data that you can use to organize, calculate, or filter a summary. For example, a sales table might have columns named Date, Region, Product, and Revenue. Those four headers become fields in the pivot table editor. You do not create a separate field list: Sheets reads the column headings in the selected source range and displays them in the editor.

Each field has a role in the summary. Put Region in Rows to list regions down the table, or put Product in Columns to spread products across it. Put Revenue in Values to calculate a total or another summary for each region and product combination. Put Date or another field in Filters to limit which source records are included.

The fields list is therefore both a view of the pivot table’s available ingredients and the starting point for changing its layout. It does not show every column in the spreadsheet automatically. It shows the columns included in that pivot table’s source range, so a column outside the range will not appear until the range is changed.

Open the Pivot Table Editor

Open the Google Sheets file containing the pivot table.
Click a cell inside the pivot table. Selecting the original data or a blank cell elsewhere will not show that table’s field controls.
Look for the Pivot table editor panel on the right. Its available fields are usually listed near the top, above the Rows, Columns, Values, and Filters sections.
If the editor is not visible, click within the pivot table once more and check the right edge of the browser window. If a compact Edit control is shown for the selected pivot table, click it to reopen the editor.

When a pivot table is selected, Sheets may also outline or otherwise distinguish the pivot table area. This helps confirm that the selection is in the summary rather than the data behind it. If the right panel is simply outside the visible area, widening the browser window or reducing browser zoom can make it easier to see. The editor is a side panel, not a separate worksheet tab.

Understand the Four Field Areas

After opening the editor, you will see the source field names and the sections that control how the pivot table uses them. The exact contents depend on the selected pivot table and its data, but the core sections have distinct jobs:

Rows: Creates labels down the left side. A Region field, for example, groups records into regions. Adding another row field can create a more detailed hierarchy, such as region followed by salesperson.
Columns: Creates headings across the top. Adding Product here can make separate columns for each product category, which is useful for comparing categories side by side.
Values: Calculates a result from a field, such as a sum of Revenue or a count of records. This is the area that produces the numbers in the summary.
Filters: Restricts which source records are included in the pivot table. A filter can help focus a report on a particular year, region, or status without deleting source rows.

These roles can be combined. For instance, Rows: Region, Columns: Product, and Values: Revenue gives a cross-tabulation of revenue by region and product. The same fields can be assigned differently to answer a different question. Moving a field changes the structure of the summary, not the underlying source data.

Add and Change Fields

To use a field, find its source-column name in the editor and click Add beside the section where you want it. Choose the field from the list. For example, add Region to Rows and Revenue to Values to create a total by region. Add Product to Columns if you want each region’s results split across product categories as well.

Once a field has been added, its settings appear in the relevant section. In Values, check the summarization choice: a numeric column is commonly summarized by SUM, while text data may be counted. You can change the calculation when the available options fit your question better—for example, use an average when a total would be misleading. A count of transactions answers a different question from a sum of their revenue, even if both use the same source column.

Use the field’s settings to adjust sorting, display, or filtering options when they are available. To remove a field from a section, use the remove control shown on its field card. Removing it from the pivot setup does not delete the source column. If the order of nested row or column fields matters, arrange the fields in the order that best communicates the grouping, and inspect the table after each change.

When a Field Is Missing

If a column you expect is not listed, the most common reason is that it is not part of the pivot table’s source range. Check the range shown near the top of the Pivot table editor. It should include all the columns you want to use, along with the header row. If the source table has expanded since the pivot table was created, newly added columns or rows may sit beyond the original range.

Also check the source headings. Each included column should have a clear heading in the first row of the selected range. A blank heading, a heading placed on a different row than expected, or a range that starts one row too low can make the field list confusing or incomplete. If you changed a heading, confirm that the intended source range still includes that header and the data beneath it.

Use this quick checklist before rebuilding the pivot table:

Click inside the correct pivot table, especially if the sheet contains more than one.
Check that the missing column is inside the pivot table’s data range.
Confirm that the source range includes the row containing the column names.
Look for blank or unclear headers and make each source column identifiable.
Check whether a filter is excluding records from the displayed results; a filter affects what appears, although it does not normally remove the field from the available field list.

If the source data is on another sheet, the pivot can still use it, but the editor’s range needs to refer to the intended data. Review the range carefully before editing it; a range that is too short omits records, while one that includes unrelated columns or title rows can produce an unsuitable field list.

Change the Source Range and Keep Data Organized

When you need fields or records that were added after the pivot table was made, select the pivot table and review its data range in the editor. Update the range so it covers the complete source table, including its headers and the added rows or columns. Then check the field list and the resulting summary. Changes within the pivot table’s source range are reflected in the pivot table, but data outside that range cannot contribute to it until you include that data.

For easier maintenance, keep a single header row, avoid blank columns within the source table, and place new records directly below the existing data. Avoid putting notes, subtotals, or a second header row inside the source range: those entries can be treated as ordinary records and distort the summary. If the source has multiple tables or unrelated content, select only the relevant rectangular range when creating or adjusting the pivot.

Changing the source range is different from changing a field’s role. The first determines which columns and records are available; the second determines how available data is grouped, calculated, or filtered. Knowing which problem you have makes troubleshooting faster: a missing column points toward the range or header, while an unexpected total often points toward the field setup or the source values.

Read the Results Before Relying on Them

A pivot table can make a large dataset easier to explore, but the summary is only as meaningful as its source data and settings. Suppose a sales sheet has one row per order line and a Revenue column. Summing Revenue by Region gives total revenue by region. Counting Revenue instead gives the number of nonblank revenue entries, which may correspond to order lines—not necessarily unique orders or customers.

Similarly, an average calculated from line-level records is an average per row, not automatically an average per customer or per day. Before interpreting a number, identify what one source row represents and what the Values field is calculating. If categories appear unexpectedly, check for inconsistent spelling or extra spaces in the source values; Sheets may treat different text entries as separate categories.

Filters are useful for focusing a report, but remember that a filtered summary does not show every source record. If totals seem lower than expected, inspect the Filters section and verify the selected values. You can also compare the pivot table’s grand total with a separate check of the source data, provided both calculations cover the same rows and apply the same inclusion rules.

Google Sheets Compared with Excel

Google Sheets and Microsoft Excel both use pivot tables with row, column, value, and filter roles, but their editing interfaces differ. In Sheets, the pivot table editor appears as a side panel in the browser when you select a pivot table. In Excel for Microsoft 365 on Windows, pivot settings are managed through the PivotTable Fields pane, which is associated with the PivotTable Analyze tools on the ribbon. Instructions for opening one program’s field pane should not be assumed to match the other.

The field concepts transfer readily between the programs, but menu wording, available controls, and layout can differ. This guidance describes Google Sheets in a web browser. If you are working in Excel, select the pivot table and use Excel’s PivotTable Fields pane instead of looking for Sheets’ side panel.

Frequently Asked Questions

Why can’t I see the Pivot table editor in Google Sheets?
Click a cell inside the pivot table. The editor is associated with the selected pivot table, so clicking the source data or an empty cell will not open its field controls. Also check the right side of the browser window for a closed or out-of-view side panel.

Where are the pivot table fields listed?
They appear in the Pivot table editor on the right, usually above the Rows, Columns, Values, and Filters sections. Each listed field corresponds to a column in the pivot table’s source range.

How do I add a field to Rows or Values?
In the editor, click Add next to Rows or Values and select the source-column name. The field then appears in that section, and the pivot table updates to use it in that role.

Why is a new column missing from the field list?
It may be outside the pivot table’s source range, or the range may not include its header. Check the data range in the editor and extend it to include the new column and the header row.

Can I see the source data from a pivot table?
The editor shows the pivot table’s source range and field names, not a separate copy of every source row. To inspect or correct individual records, go to the source data range in the sheet and review the relevant rows there.

Does removing a field delete its source data?
No. Removing a field from Rows, Columns, Values, or Filters changes the pivot table’s arrangement. It does not delete the original column or its records from the spreadsheet.

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.