Pivot Table Formatting
 

Hi,

I use pivot tables a lot and often use the facility where you highlight
pivot table subtotals and put them in yellow for example. This is where you
can highlight the first subtotal and it will automatically highlight all
other subtotals in the report. So the changes you do to one subtotal happen
to all and allow refreshing etc.

My colleague at work has tried to highlight all subtotals but he can't do it
- does anyone know why this is?

Thanks
Beccy

Pivot Table Formatting
 

Enable Selection may not be turned on:

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTableSelectEnable Selection

Beccy wrote:
I use pivot tables a lot and often use the facility where you highlight
pivot table subtotals and put them in yellow for example. This is where you
can highlight the first subtotal and it will automatically highlight all
other subtotals in the report. So the changes you do to one subtotal happen
to all and allow refreshing etc.

My colleague at work has tried to highlight all subtotals but he can't do it
- does anyone know why this is?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html