How to Show the Pivot Table in Excel

It’s one of the most frustrating moments in Excel: you’ve built the perfect pivot table, but suddenly the settings pane vanishes, leaving you staring at a static report you can’t edit. This article will show you exactly how to get that crucial "PivotTable Fields" pane back. We'll also cover other essential management tasks like refreshing your data and changing your data source so you can stay in control of your reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, What Exactly Is a Pivot Table?

Think of a pivot table as an interactive summary of a larger dataset. Let's say you have a spreadsheet with thousands of rows of marketing campaign data: Campaign Name, Ad Platform, Spend, Clicks, and Conversions. Trying to figure out which ad platform has the best return would require a lot of manual sorting, filtering, and formulas.

A pivot table does that hard work for you. In a few clicks, you can "pivot" the data to see:

• Total spend by platform.
• Total conversions per campaign.
• Click-through rate for different ad types.

It turns a mountain of raw data into a dynamic report that can answer questions on the fly. The key word here is dynamic. The real power isn't just the summary table itself but the control panel that lets you drag, drop, and rearrange your data to find insights. When that panel disappears, your pivot table becomes just a regular, non-interactive table.

The Main Event: Showing the PivotTable Field List

The control panel we're talking about is officially called the PivotTable Field List (or sometimes the "Fields Pane"). This is the number one thing people are looking for when they can't "see" their pivot table settings. Why does it vanish? The reason is deceptively simple: you clicked on a cell outside of the pivot table area. Excel assumes you want to work on something else, so it tidies up your workspace by hiding the pivot table tools.

Here’s how to bring it back in two easy steps.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Click Inside Your Pivot Table

That’s it. Click any single cell within your pivot table's summary report. 99% of the time, this is the magic trick. As soon as you select a cell inside the pivot table, Excel recognizes you want to work on it again, and the PivotTable Fields pane will reappear on the right side of your screen.

If it doesn't come back, don't worry. It most likely means you or a colleague accidentally closed it while the pivot table was selected. Move on to the next step.

Step 2: Use the Ribbon to Manually Turn it On

If clicking inside the pivot table didn't work, you can force the Field List to show up using the menu at the top of Excel.

1. Click anywhere inside your pivot table. This makes two new "PivotTable Tools" tabs appear in the main Excel ribbon: PivotTable Analyze and Design.
2. Click on the PivotTable Analyze tab.
3. Look all the way to the right side of that ribbon. You'll see a section called "Show."
4. Click the button labeled Field List. The pane will immediately pop back onto your screen.

This button is a toggle. You can click it to show the pane and click it again to hide it manually. Most people prefer to have it hidden when they're not actively building the report to save screen space, but now you know how to bring it back whenever you need it.

Bonus Tip: Customizing the Field List Layout

Once you’ve brought your Field List back, you might notice its layout doesn't feel right. Excel gives you a few options to change how it looks. In the top corner of the PivotTable Fields pane, you’ll see a small gear icon for "Tools."

Click that gear icon, and you’ll see a dropdown menu with different layout options. The default, "Fields Section and Areas Section Stacked," has the list of all available fields at the top and the four areas (Filters, Columns, Rows, Values) at the bottom. A popular alternative is "Fields Section and Areas Section Side-by-Side," which can be easier to use on a widescreen monitor because it gives you more vertical space for your fields and areas.

Feel free to try the different layouts to see what works best for your workflow.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Other Common PivotTable Visibility Problems

The Field List isn't the only thing that can seem 'hidden' or out of date in a pivot table. Here are a few other common scenarios and their straightforward fixes.

How to Show Fresh, Up-to-Date Data (Refreshing)

A huge misconception is that pivot tables automatically update when you change your source data. They don't. If you update a number, add a row, or fix a typo in your original data table, you have to tell the pivot table to re-read the data.

This is called refreshing. Here are the two quickest ways to do it:

• The Right-Click Method: Simply right-click anywhere on the pivot table and select Refresh from the context menu. This is the fastest way.
• The Ribbon Method: Click into your pivot table, go to the PivotTable Analyze tab, and click the Refresh button (it has a green circular arrow icon). If you click the small arrow on the button, you can also choose Refresh All to update every pivot table in the entire workbook at once.

If you find yourself constantly forgetting to refresh, you can even make it an automatic process. Right-click the pivot table, go to PivotTable Options, navigate to the Data tab, and check the box that says "Refresh data when opening the file."

How to Show New Rows or Columns of Data (Changing the Data Source)

This is a big one. What happens if your original dataset grows? Maybe you exported campaign performance for May, built your pivot table, and now you have the data for June. You paste June's data at the bottom of your original table, hit Refresh, and... nothing happens. Why?

A simple refresh only updates the values within the currently defined data range. It won't automatically expand to include new rows or columns you've added outside that initial range. You need to manually tell the pivot table where to look for the new information.

Here’s how to show your pivot table its new data source:

1. Click anywhere inside your pivot table.
2. Go to the PivotTable Analyze tab in the ribbon.
3. In the "Data" section, click on Change Data Source.
4. A dialog box will pop up, showing you your current data range (e.g., Sheet1!$A$1:$F$500). That range will be highlighted with a crawling "marching ants" border in your spreadsheet.
5. Simply re-select the entire new data range, including the new rows or columns you added.
6. Click OK.

This is where using official Excel Tables comes in handy. If your source data is formatted as a Table (select your data and press Ctrl+T), it becomes a dynamic range. When you add new rows or columns, the Table expands automatically. When you create a pivot table from a Table, you'll never have to manually change the data source again. Just hit Refresh, and it will pick up all the new data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Show Different Summaries and Calculations

By default, if you drag a text field into the Values area of your pivot table, it will perform a COUNT. If you drag a number field, it will calculate a SUM.

But what if you want to show the average spend instead of the sum? Or count the number of conversions instead of adding them up? You need to change the "Value Field Settings."

1. In the PivotTable Fields pane, find your field in the Values area at the bottom right.
2. Click the small downward arrow next to the field name.
3. Select Value Field Settings from the menu.
4. A new dialog box will open. Under the "Summarize value by" tab, you can change the calculation type from Sum to Count, Average, Max, Min, and more.
5. You can also change the display name of the field here, like renaming "Sum of Spend" to "Total Spend."

This area also has a "Show Values As" tab, which is incredibly powerful. Here, you can change the calculation to show things like % of Grand Total, % of Column Total, or the Difference From a previous value, giving you rich analytical capabilities without writing a single formula.

Final Thoughts

Mastering the ability to show, hide, and manage your pivot table is the most critical step in moving from basic reporting to truly dynamic analysis within Excel. Whether it's bringing back the Field List, refreshing data, or changing the source, these skills put you firmly in control, allowing you to slice and dice your information with confidence to find the answers you need.

The manual work of exporting CSVs, cleaning them, and remembering to refresh pivot tables can still feel like a constant chore, especially when your data lives across many platforms. At Graphed we automate all of that away. We connect directly to your marketing and sales tools - like Google Analytics, Shopify, and Salesforce - and pipe your data into real-time dashboards. Instead of clicking and dragging, you simply ask for what you need in plain English, and we build the visualizations for you. No more lost Field Lists, no more stale data - just fast, clear answers.