Select And Format All Subtotals Rows In Pivot Table

Table of Contents

Follow the below steps to select all subtotals in Pivot table. (This is applicable to all report layouts)

Step 1: Hover your cursor over any subtotals

Step 2: Wait until your cursor turns into a small black down arrow

Step 3: Click it

In this article, I will show you how to format all subtotals in different Pivot table report layouts.

Keep reading for detailed explanation and step-by-step tutorial.

Example

The following table will be used for demonstration.

Select And Format All Subtotals Rows In Pivot Table
What is report layout?

Excel offers 3 reports layout for different displaying purpose, which are Compact, Outline and Tabular form.

You can tweak the layout to present the pivot table differently.

Select And Format All Subtotals Rows In Pivot Table

In Compact Form

Step 1: Hover your cursor over any subtotals

Step 2: Wait until your cursor turns into a small black down arrow

Step 3: Click it

In Outline Form

Step 1: Hover your cursor over any subtotals

Step 2: Wait until your cursor turns into a small black down arrow

Step 3: Click it

Yup, the way to select all subtotals in the outline form is the same as compact form.

In Tabular Form

Step 1: Hover your cursor over any subtotals

Do you find this article helpful? Subscribe to our newsletter to get regular Excel tips and exclusive free Excel resources.

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
International Open Academy

Join Our Newsletters!

JOIN OUR NEWSLETTERs!