PivotTable formatting in Google Sheets - Step-by-Step Guide

Introduction

PivotTables help you summarize large data quickly. Formatting a PivotTable makes it easier to read and understand the summarized data by changing colors, fonts, and layout.

When you want to highlight totals or subtotals in your sales report

When you need to change the font size or color to make data clearer for a presentation

When you want to add borders to separate different sections of your PivotTable

When you want to adjust column widths so all data fits nicely

When you want to apply a style to make your PivotTable look professional

Steps

Step 1: Click

- any cell inside the PivotTable

The Pivot table editor panel appears on the right side of the screen

Step 2: Click

- the PivotTable to select it

The PivotTable is highlighted and the toolbar shows formatting options

Step 3: Click

- Format menu in the top menu bar

A dropdown menu with formatting options appears

Step 4: Select

- Text color or Fill color from the Format menu

A color palette opens for you to choose colors

💡 Use fill color to highlight important rows or columns

Step 5: Click

- a color in the palette

The selected cells in the PivotTable change to the chosen color

Step 6: Right-click

- a cell or range inside the PivotTable

A context menu appears with options like 'Resize column' or 'Insert row'

💡 Use 'Resize column' to adjust column width for better visibility

Step 7: Click

- any cell in the PivotTable and then click the 'Pivot table editor' panel

You can adjust layout options like showing totals or changing row order

Before vs After

Before

PivotTable with default black text, no colors, and columns all the same width

After

PivotTable with blue header text, light gray fill on totals row, and wider columns for better readability

Settings Reference

Text color

📍 Format menu > Text color

Change the color of text in the PivotTable cells

Default: Automatic (usually black)

Fill color

📍 Format menu > Fill color

Change the background color of cells to highlight data

Default: No fill

Resize column

📍 Right-click menu on a column header

Adjust column width to fit content or preferred size

Default: Auto fit

Show totals

📍 Pivot table editor panel > Values section

Display or hide total rows and columns in the PivotTable

Default: Show totals

Common Mistakes

Trying to format PivotTable cells by typing directly into them

PivotTable cells are generated by the tool and cannot be edited directly

Use the Format menu or right-click options to change appearance

Applying fill color to the entire sheet instead of just the PivotTable

This can confuse the data and make the sheet look messy

Select only the PivotTable cells before applying fill color

Summary

PivotTable formatting helps make summarized data easier to read and understand.

Use the Format menu and right-click options to change colors, fonts, and column widths.

Remember you cannot type directly into PivotTable cells; use formatting tools instead.