Pivot Table - Try to highlight ALL subtotal rows all at once. How?

F

Fanny

Hi,

I am a frequent Excel Pivot Table user and trying to find out: when I am
summing up data using Pivot Table, how do I highlight ALL the "Total" rows at
once so I can format them the same way, withouting manually going down the
list one by one after every field.

Thanks,
 
D

Debra Dalgleish

Turn on Enable Selection --
Select a cell in the pivot table
From the Pivot table toolbar,
choose PivotTable>Select>Enable Selection
(if it's already on, selecting it will
turn it off)

Then, point to the left of one of the subtotals
(stay in the cell, not in the row selector buttons)
When the pointer changes to a black arrow, click
and all the subtotals will be selected
 
Top