Format pivot table totals

In addition to customizing all cells in a table or pivot table by applying table styles, you can format pivot table totals separately from the other values in a pivot table:

  • Apply unique formats to subtotals and grand totals in a pivot table, described in this document.
  • Change the number format and appearance of totals rows and columns using the toolbar. See Format column and totals data.
  • Apply conditional formatting to subtotals and grand totals. See Apply conditional formatting.

To show or hide subtotals and grand totals, see Pivot table totals and subtotals.

This document describes the format options for pivot table totals and explains how to customize the display of rows and columns containing subtotals and grant totals.

User requirements

The ability to format pivot table totals requires the following:

  • You must be assigned an account type with the Explore workbooks or Create, edit, and publish workbooks permission enabled.

  • You must be the workbook owner or be granted Can explore or Can edit workbook permission.

Pivot table totals format options

Subtotals

The Subtotals tools allow you to customize the font weight, font color, and background color of subtotal rows and columns.

Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Subtotals for east and west regions are highlighted with a bright yellow background color and values are bold.

Grand totals

The Grand totals tools allow you to customize the font weight, font color, and background color of the grand totals row and column.

Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Grand total values are highlighted with a background color of pink and the font is bolded.

Position

The Position setting allows you to move grand totals to the first or last column and row.

FirstLast

Format pivot table totals

  1. Open a workbook for customizing or editing.

  2. Select the pivot table you want to format.

  3. In the side panel, select Format, then click the Totals header to expand the section.

    Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. No formatting changes have been made.
  4. Use the Subtotals and Grand totals options to customize font weight, font color, and background color. Select an option in the Position dropdown to control the position of the grand total row and column.

    Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Subtotals have a bright yellow background color and bold, and grand total values have a light pink background color and are bold.