How to Change Pivot Table Design in Google Sheets

A Google Sheets pivot table is brilliant for summarizing large datasets, but the default look doesn't always tell the clearest story. Changing the design is essential for turning a dense grid of numbers into a report that's both easy to read and insightful. This guide will walk you through exactly how to customize your pivot table's design and layout, from simple structural changes to advanced visual formatting.

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, a Quick Refresher: Creating a Pivot Table

Before you can customize a pivot table, you need to have one. Let's create a basic one from a sample sales dataset to use throughout this tutorial. Imagine you have data like this:

Here's how to turn that data into a pivot table:

1. Select any cell within your data range.
2. Go to the menu and click Insert > Pivot table.
3. Google Sheets will ask where to place it. Choosing "New sheet" is usually the cleanest option. Click Create.

You'll now have a blank pivot table and a "Pivot table editor" pane on the right. This editor is the control center for your entire pivot table design.

The Core of Design: The Pivot Table Editor

The design of your pivot table - what it shows and how it shows it - is controlled entirely by the Pivot table editor. It has four main sections you can drag and drop your data fields (column headers) into:

• Rows: Fields placed here will create rows down the left side of your table. In our example, placing "Product" here would list each product vertically.
• Columns: Fields here will create columns across the top. Placing "Region" in columns would create columns for "North," "South," "East," and "West."
• Values: This is where you put the numbers you want to calculate. Typically, this is a field like "Sales," "Quantity," or "Revenue." Google Sheets will automatically summarize them (usually with a SUM function).
• Filters: Fields here let you filter the entire pivot table report without changing its structure. For example, filtering by "Category" to only see data for "Electronics."

Manipulating these four sections is the first and most fundamental step in changing your pivot table's design.

Step 1: Adjusting the Layout and Structure

The layout dictates how your information is organized. Is it a long report or a wide one? Are you comparing items side-by-side or listing them top-to-bottom? Let's adjust.

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

Reorienting the Table with Rows and Columns

The most common design change is simply swapping fields between the Rows and Columns sections. This fundamentally changes how you view the data.

Let's create a table showing sales for each Product in each Region.

• Drag Region to the Columns section.
• Drag Product to the Rows section.
• Drag Sales to the Values section.

You now have a table comparing products across different regions horizontally - a wide layout. But what if you wanted to see the regions grouped under each product? Simply drag the Region field from Columns to Rows, placing it underneath the existing Product field. Now you have a nested, vertical, and deep layout instead of a wide one. This simple drag-and-drop action completely redesigns the report.

Grouping Data to Create New Summaries

One of the most powerful design features is grouping. The default pivot table shows a row for every single date. That's rarely useful. Let’s group the dates to see sales by month.

1. Create a simple pivot table with Date in the Rows section and Sales in the Values section.
2. Right-click on any of the date cells within your pivot table.
3. Navigate to Create pivot date group.
4. Choose your preferred grouping. "Month" or "Year-Month" are common choices.

Instantly, your sprawling list of daily sales is summarized into an easy-to-read monthly report. You can use a similar process to group numerical data into ranges (like customer age brackets) or manually group text fields together (like combining "East" and "West" into a group called "Coastal").

Show or Hide Totals

Sometimes grand totals are useful, other times they just add clutter. In the Pivot table editor, under the Rows and Columns sections, you'll see checkboxes for Show totals. Unchecking these will remove the grand totals and any subtotals, cleaning up the design for a more focused view. For nested rows, you can choose to show or hide subtotals for the top-level item, giving you more granular control over the design.

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

Change Summarization and Show Values As a Percentage

By default, the Values field summarizes your numbers using a SUM formula. But an effective design might require looking at an average or a count instead.

In the Values section of the editor, click on the dropdown under "Summarize by." You can change SUM to:

• AVERAGE: To find the average sale amount instead of the total.
• COUNT or COUNTA: To count the number of sales transactions.
• MIN or MAX: To identify the single smallest or largest sale.

Even more powerfully, you can change how the data is displayed. Under the "Show as" dropdown, instead of "Default," you can choose to show the value as a percentage. This is incredibly useful for design:

• '% of grand total': Shows each cell's contribution to the absolute total.
• '% of column': Shows what percentage of a column's total each cell represents (e.g., What percentage of North region's sales came from Laptops?).
• '% of row': Shows what percentage of a row's total each cell represents (e.g., What percentage of Laptop sales came from the North region?).

Transforming your report from raw numbers to percentages makes comparative analysis much clearer and is a major design improvement.

Step 2: Improving Visuals and Formatting

Once your data is structured correctly, it's time to make it look good. Visual styling draws attention to what's important and improves readability.

Apply a Consistent Look with Themes

The fastest way to apply a clean, professional design is by using themes. A theme applies a consistent color palette, font style, and alternating row colors to your entire sheet, including the pivot table.

1. Click on Format > Theme in the main menu.
2. A sidebar will appear with several pre-made themes. Click one to see it applied live.
3. You can click Customize to edit the theme's fonts and colors to match your brand.

This is a quick win for moving away from the default black-and-white grid to something more custom and presentable.

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

Highlight Key Data with Conditional Formatting

Conditional formatting is a game-changer for pivot table design. It allows you to automatically apply visual styles to cells based on their values, creating a visual report that's easy to grasp at a glance.

Let's highlight any regional sales over $10,000 in green:

1. Select all the numerical cells within your pivot table (excluding the grand totals).
2. Go to Format > Conditional formatting.
3. The Conditional format rules pane will open. Ensure your cell range is correct under "Apply to range."
4. Under "Format cells if...," choose Greater than from the dropdown menu.
5. In the "Value or formula" box, type 10000.
6. Below, choose a formatting style. You can select a green fill to make high-performing cells stand out.
7. Click Done.

You can also use a "Color scale" to create a heatmap. This automatically applies a gradient of color, making it easy to spot the highest and lowest values in your entire table without even reading the numbers.

Standard Formatting Controls

Finally, don’t forget the basics. You can manually format the cells in your pivot table just like any other range in Google Sheets.

• Number Formatting: Select the cells containing your sales figures and go to Format > Number to apply currency styling, adjust decimal places, or format them as percentages.
• Alignment: Center your column headers or right-align numbers for better readability.
• Borders and Fill Colors: Use the toolbar buttons to manually add borders or background colors to headers or specific cells you want to call attention to. While less dynamic than conditional formatting, it’s great for one-off highlights.

Final Thoughts

Designing a pivot table in Google Sheets is about moving beyond the default summary. By strategically arranging your data into rows and columns, grouping information creatively, and applying visual themes and conditional formatting, you transform a robotic data dump into a clear, actionable report that effectively communicates insights.

We built Graphed because we believe getting those clean, actionable reports shouldn't have to involve dragging fields around and fussing with formatting rules. Instead of manually building pivot tables, you can connect your data sources (like Google Ads, Shopify, or Salesforce) and simply ask for what you need in plain English: "Show me a chart of sales by region for the last quarter." Our AI builds a live dashboard for you in seconds, skipping the tedious setup so you can get straight to the insights.