pivot table - subtotal format

K

Kevin

Hi - have just switched to XP

In a pivot in old excel I use to to click in a subtotal
field eg "Europe Total" and excel would automatically
highlight all subtotals at that level. It just meant I
could colour the row and it would apply to all of the
subtotals - how can I do that it XP ?

thanks
 
D

Debra Dalgleish

To enable selection --

From the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection

To format the subtotals --

Move the pointer to the left of a subtotal heading in the
pivot table.
When the black arrow appears (like the one that appears
when the pointer is over a row button), click to select the subtotal
rows in the pivot table.
Apply the formatting.
 
Top