How to View Pivot Table Settings in Google Sheets

A Google Sheets pivot table is a powerful tool for summarizing large datasets, but its real value comes from being able to understand and change its settings. Whether you're trying to figure out a report someone else built or need to tweak your own analysis, knowing where to find the controls is essential. This article will show you exactly how to view, understand, and modify your pivot table settings in Google Sheets.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Are Pivot Table Settings?

Think of pivot table settings as the "control panel" for your data summary. They dictate which data from your source sheet is used, how it's organized, and what calculations are performed. When you need to understand why your pivot table looks the way it does or make a change, these settings are where you'll go.

You might need to view the settings to:

• Discover the source data range the table is referencing.
• See how the data is grouped (i.e., what's in the rows vs. the columns).
• Check which calculation is being used (e.g., SUM, COUNT, AVERAGE).
• Modify filters that are impacting the displayed results.
• Quickly update the table to answer a new question with the same data.

How to Open the Pivot Table Editor in Google Sheets

Finding your pivot table's settings is straightforward once you know the first step. The entire control panel is housed within the Pivot table editor pane, which usually appears on the right side of your screen.

Here’s how to access it:

Step 1: Select Your Pivot Table

Simply click any cell inside the pivot table you want to inspect. As soon as you click it, Google Sheets recognizes that you are interacting with a pivot table and brings up the necessary controls.

Step 2: Locate the Pivot Table Editor

Once you click on the table, the Pivot table editor pane should automatically pop up on the right side of your spreadsheet. This pane contains all the settings and options for your selected table.

If the editor doesn't appear automatically, don't worry. Sometimes, you might need to click the small "Edit" pencil icon that shows up directly below the pivot table when it's selected. This will manually open the editor pane.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Deep Dive into the Pivot Table Settings

The Pivot table editor is divided into distinct sections, each controlling a different aspect of your report. Let's break down what each setting does.

1. Data Range

This is arguably the most important setting. Located at the very top of the editor, the Data range tells your pivot table which cells in your spreadsheet contain the source data. It's often written in a format like 'Sheet Name'!A1:G500.

• Why it matters: If your pivot table isn't showing new data you've added, the data range is the first place to check. It might be fixed on an old range (e.g., A1:G500) when you've now added data down to row 600.
• Pro Tip: To make your pivot table automatically include new rows, use an open-ended range by removing the final row number (e.g., change A1:G500 to A1:G). This tells Google Sheets to include all data in columns A through G, no matter how many rows you add later.

2. Rows

The "Rows" section determines how your data is grouped vertically. Each unique item from the field you place here will become a new row header in your pivot table.

• Example: If you are analyzing sales data, you could drag your "Product Category" field into the Rows section. The pivot table would then create a separate row for each category, like "Electronics," "Apparel," and "Home Goods."
• You can add multiple fields to create nested rows for a more granular breakdown (e.g., Category, then a sub-row for Product Name).

3. Columns

The "Columns" section works just like Rows but groups your data horizontally. Each unique item from the field you place here becomes a column header, running across the top of your table.

• Example: Continuing with the sales data, you could add a "Month" field to the Columns section. This would create columns for "January," "February," "March," etc., allowing you to see Product Category sales spread across the year.

4. Values

This section is where the calculation happens. You drag a field — almost always a numerical one — into the "Values" box to be summarized.

• Example: Here, you would drag your "Sales Revenue" field. By default, Google Sheets will try to SUM it, giving you the total sales revenue for each combination of rows and columns.
• You can change the calculation from SUM to other options like:

5. Filters

The "Filters" section lets you focus on a specific subset of your data without altering the main pivot table structure. It's perfect for narrowing your analysis.

• Example: You could add the "Country" field to the Filters section. You would then be able to check or uncheck specific countries from a list, showing only the data for "United States" and "Canada," for instance, while hiding everything else.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Editing Your Pivot Table in Real-Time

Once you have the Pivot table editor open, making changes is simple and intuitive. The pivot table will update instantly with every change you make.

Moving and Reorganizing Fields

Want to see months as rows instead of columns? Just click and drag the "Month" field from the Columns section into the Rows section in the editor. The pivot table will instantly rearrange itself.

Customizing and Sorting Data

Within each field in the Rows or Columns sections, you can specify the sort order. Click the dropdown menu to sort by that field's name or by one of the calculations in your Values section. You can choose between ascending (A-Z, 1-10) and descending (Z-A, 10-1) order.

For example, you could sort your list of "Product Categories" not alphabetically, but by the SUM of Sales Revenue in descending order to quickly see your top-performing categories.

Adding and Removing Totals

For both Rows and Columns, there are simple "Show totals" checkboxes. Unchecking these will hide the grand total row or column. This can be useful for cleaning up your report's appearance if the totals aren't necessary for your analysis.

Troubleshooting Common Pivot Table Issues

Viewing the settings is often the first step to fixing a problem. Here are a couple of very common scenarios and how the editor helps you solve them.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Scenario 1: "My new data isn't showing up in the pivot table."

This is almost always a Data Range problem. Open the editor and look at the range. Chances are, the pivot table is still referencing the old set of cells. Click the grid icon next to the data range, re-select all of your current data, or adjust the range to be open-ended (like A1:G) to prevent this from happening again.

Scenario 2: "My numbers look wrong - it's counting instead of adding."

If you have any blank cells or text in your numerical column, Google Sheets might default to using COUNTA (Count All) instead of SUM. Open the editor and look at your field in the "Values" section. Click the dropdown under "Summarize by" and change it from COUNTA to SUM to fix the calculation.

Final Thoughts

Getting comfortable with the Pivot table editor transforms a pivot table from a static report into a flexible, dynamic analysis tool. By spending a few minutes exploring the Rows, Columns, Values, and Filters sections, you gain complete control over your data summary, allowing you to debug issues, adapt your report, and uncover new insights with just a few clicks.

While mastering pivot tables is a huge leap forward, it’s often just one part of a bigger reporting puzzle. Manually exporting data from tools like Google Analytics, Shopify, Facebook Ads, or your CRM to create these summaries is still time-consuming. At Graphed, we automate that entire process. You can connect all your data sources in seconds and ask questions in plain English like, "Show me my top-performing ad campaigns by revenue last month." We instantly build a live, updating dashboard for you — no more downloading CSVs or wrestling with pivot table settings to get answers.