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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table subtotals 2
Pivot Table Subtotals 1
multiple subtotals in pivot table 1
Highlight Pivot Row Totals 3
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Formula Problem 1
Conditional SUBTOTAL in XL210 Table 7
can i add subtotals to subtotals in a pivot table? 1

Back
Top