Can't format Pivot table subtotals anymore

[Alejo1970]

Somehow I lost the ability to format *all* the subotals in a Pivot table *at once*.

Normally you can just place the cursor at the left of a subtotal row in a pivot table, and it turns into a black arrow pointing to the right. If you click it, it'll select not only that particular subtotal row, but *all* subtotal rows. That allows you to, for example, format all subtotals as bold, or highlight them with the same color.

Well, I can't do that anymore! I did not change any option in Excel, it just stopped working.

Any ideas? I use Excel 2003, BTW. Thanks,

 

[RoryA]

Select a cell in the PT, then on the Pivot Table toolbar, choose Pivot Table->Select->Enable Selection.

 

[Alejo1970]

That worked! Can't believe I couldn't find it on my own. Thanks a lot!

 

[RoryA]

Glad to help.