pivot table - subtotal format

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

To enable selection --

From the Pivot toolbar, choose PivotTableSelect
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.

Kevin wrote:
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 ?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html