Google Sheets Pivot Table Formatting: A Practical Guide

To format a pivot table in Google Sheets, click a cell in the table and use the toolbar or the Format menu to change number formats, text, colors, borders, and alignment. To change what the table summarizes or how it is arranged, use the Pivot table editor instead; formatting changes appearance, while the editor changes the analysis.

What formatting changes—and what it does not

A pivot table condenses source data into a summary, such as sales by region or monthly expenses by category. Formatting makes that summary easier to read: for example, it can display revenue as currency, make headings stand out, or emphasize unusually high values. It does not change the underlying records or the arithmetic used to summarize them.

That distinction matters because a number that looks wrong may be a calculation or data-type issue rather than a formatting issue. Applying a currency format to a count does not turn the count into a sum, and adding decimal places does not make an imprecise source value more accurate. If the result itself is wrong, inspect the fields and settings in the Pivot table editor before changing its appearance.

Google Sheets runs in a browser and does not provide the same dedicated PivotTable Design ribbon found in desktop Excel. In Sheets, you generally format the cells in the pivot output with familiar spreadsheet tools, then use the editor panel for pivot-specific choices.

Apply basic formatting to the pivot output

First select the cells you want to change. To format one value column, click its first data cell and select the relevant range; to style the whole pivot table, drag across its displayed cells. The toolbar can set font, size, bold, text color, fill color, borders, and horizontal or vertical alignment. You can also use the Format menu for options such as text wrapping and number formats.

Click inside the pivot table so Sheets recognizes the pivot and opens the Pivot table editor on the right, if it is not already open.
Select the output cells you want to style. Avoid selecting unrelated cells beside the pivot.
Use toolbar controls for quick changes such as bold headings, background fills, borders, or alignment.
For number display, choose Format > Number and select an appropriate category, such as Currency, Percent, or Date.
Click a blank cell when finished to review how the table looks without an active selection.

For a readable report, use a restrained style: a distinct heading row, consistent number formats, and enough spacing or borders to separate totals from detail. Too many colors, heavy borders, or different fonts can make a compact summary harder to scan.

Choose the right number format

Number formatting is often the most useful adjustment because pivot tables may display raw values with unnecessary decimal places or without units. Select the relevant value cells, then use Format > Number. The same menu offers options such as number, currency, percent, and date; the toolbar also includes shortcuts for common formats such as currency and percent.

Revenue or cost: Use a currency format that matches the report’s context. If cents are not useful, reduce the displayed decimal places with the toolbar controls.
Rates and shares: Use Percent for values that represent fractions. A stored value of 0.25 displays as 25% when formatted as a percentage; formatting does not divide or multiply the stored value.
Counts: Use a plain number format, usually with zero decimal places. If the pivot counts records, check whether the chosen summary is counting nonblank entries or counting numeric values.
Dates: Use a date format that is easy to interpret and consistent with the source data. A date stored as text may not behave like a real date in a pivot table.

Formatting is normally applied to the selected output cells. When the pivot’s dimensions change, newly appearing cells may not inherit every manual style exactly as expected. Review the result after changing the source range or pivot configuration, especially if the table is used as a recurring report.

Change the pivot layout in the editor

When a report needs different rows, columns, filters, or calculations, use the Pivot table editor rather than trying to rearrange the output cells manually. The editor organizes the table through Rows, Columns, Values, and Filters. Use its Add controls to select fields from the source data, and adjust the field options shown there.

For example, a sales dataset might have Date, Region, Product, and Revenue columns. Add Region under Rows and Revenue under Values to summarize revenue by region. Add Product under Columns to compare products across regions. Add a date or category under Filters when readers need to focus on a subset of records. The resulting table structure is controlled by those settings, not by cell color or font style.

Check the Values settings when a summary uses the wrong calculation. A numeric field may be summarized by a sum, average, or another available method; a text field may offer counting rather than summing. Options such as showing a value as a percentage of a row, column, or total can also change its meaning. These are analytical settings, not cosmetic formats, so label the report clearly if you use them.

Make headings, totals, and comparisons clear

Pivot tables contain labels and calculated values, and readers should be able to distinguish them at a glance. Use bold text or a subtle fill for the header row, keep category labels left-aligned, and align numeric values consistently. If totals are important, give them visual emphasis without making every row compete for attention.

Options to include totals for row or column fields are part of the pivot configuration in the editor. Use those settings when the report needs subtotals or a grand total; do not create a fake total by typing over a pivot result. A total can be mathematically correct yet misleading if the values are percentages or averages, so explain what is being totaled and keep the calculation consistent with the question the report answers.

Sort order is also a pivot setting rather than a formatting effect. In the editor, field options can control ordering and the field used for sorting. Sorting categories by a value can make the largest contributors easier to find, while alphabetical order may be better for lookup. Choose one purpose and make the order predictable for readers.

Use conditional formatting carefully

Conditional formatting can make patterns in pivot results easier to see, such as highlighting values above a target. Select the relevant cells and choose Format > Conditional formatting, then create a rule and choose its formatting style. Use a range that corresponds to the value cells rather than applying a color scale indiscriminately to labels and totals.

Be deliberate about which cells the rule covers. A color scale is useful for comparing similar measurements, such as monthly sales across regions, but can confuse readers if it includes a grand total that is much larger than every detail value. A rule based on a threshold may be more appropriate when the report has a meaningful target. Include a text label or legend where color alone would not explain the meaning.

Pivot tables can expand or contract as their source data and configuration change. Check conditional-formatting ranges after those changes: a rule may not cover newly added output cells, or it may include cells that should not be compared. The rule changes the display of qualifying cells; it does not alter the pivot’s calculated results.

Keep formatting dependable as data changes

Sheets recalculates a pivot table when relevant source data changes, but the shape of the output can change too. A new category may add a row or column, and a changed field arrangement can move values into a different area. Because cell formatting is attached to cells and ranges, not to an abstract idea such as “all revenue fields,” it is sensible to inspect the formatted output after significant changes.

For a report that is updated repeatedly, use a few habits to reduce surprises:

Keep source data in a consistent rectangular range with one header row and no blank header cells.
Use clear, stable column headings so the editor can identify the intended fields.
Apply number formats to the appropriate value area and avoid styling large surrounding ranges unnecessarily.
After adding categories or changing rows and columns, verify totals, number formats, conditional rules, and print readability.
Keep an untouched copy or separate source tab if readers need to compare the summary with the original records.

When you need a fixed report for sharing, consider whether a live pivot table is the right format. A live pivot is useful for exploration and updates; a copied, static summary may be more predictable for a one-time presentation, but it will not automatically reflect later source changes.

Common formatting problems and fixes

Currency or percent values look incorrect. Check both the cell format and the calculation. Percent formatting displays a fraction as a percentage; it does not convert a value that was entered as 25 into 25%. For currency, confirm the intended currency and whether the source values are numeric.

Some rows are not included in the pivot. Formatting cannot add source records. Check the source data range in the pivot setup and make sure the new rows are included. Also inspect blank rows, inconsistent headers, and text values mixed into a numeric column.

The editor or pivot output is hard to find. Click a cell in the pivot table to bring up its editor panel. If you click outside the pivot, the panel may no longer show the relevant settings. The output itself is not an ordinary hand-built table: direct edits to its generated cells may be restricted because those cells are controlled by the pivot.

Colors do not communicate the result clearly. Remove decoration that has no meaning, and use labels or explanatory text alongside color. A visually strong style cannot compensate for an unclear field name, an unsuitable aggregation, or a missing unit.

Google Sheets versus Excel pivot formatting

The basic concepts are similar in Google Sheets and Microsoft Excel: both tools separate the pivot’s structure from the way its values look. The interface differs. Sheets uses a browser-based Pivot table editor and general cell-formatting tools; Excel for Microsoft 365 on Windows has PivotTable-specific ribbon tabs and built-in style controls. Therefore, instructions that say to use Excel’s PivotTable Design tab do not apply to Google Sheets.

Sheets is convenient when a report is shared and edited in a browser, while Excel offers a more specialized set of PivotTable layout and style commands. Neither application’s visual style can repair incorrect source data or an unsuitable summary calculation. If colleagues use both, agree on the field definitions and number conventions, then check the appearance in each application rather than assuming the formatting will transfer identically.

Frequently Asked Questions

Can I change a pivot table’s font and color in Google Sheets?
Yes. Select the relevant pivot output cells and use the toolbar’s font, text color, fill color, and border controls. Use a restrained style and review it after the pivot changes size.

How do I format pivot table numbers as currency?
Select the numeric output cells, then choose Format > Number and select a currency format. Confirm that the underlying values represent money and choose a currency appropriate to the report.

Can I make a pivot table show percentages instead of totals?
Open the Pivot table editor and inspect the field under Values. Use its available display options, such as showing values as a percentage of a row, column, or total, when appropriate. This changes how the values are calculated or presented, not merely their color or decimal display.

Why does my pivot table formatting not cover new rows?
New categories can expand the pivot output beyond the cells you originally formatted. Select the new cells and apply the needed format, then review any conditional-formatting range after the pivot grows.

Can I manually edit a value inside a Google Sheets pivot table?
Pivot output is generated from source records and editor settings, so its cells are not intended for manual corrections and may reject direct edits. Correct the source data or change the pivot configuration, then let Sheets recalculate the result.

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.