Pivot Table and Formatting Subtotals Automatically

[Dries]

Hi,

by arranging some data into the pivot table, my boss
exactly gets what he wants; the only thing, he asked me
to format the subtotals (like putting all in bold or
color background of the cells), so
1) I can do it manually but then i have to redo it every
time i refresh the table
2) I should be able to do it automatically and so that if
I refresh the table, it's not necessary to refresh all
the time

And I'm looking after a number 2) solution.

Thx for any help

Dries.
..

 

[Debra Dalgleish]

by arranging some data into the pivot table, my boss
exactly gets what he wants; the only thing, he asked me
to format the subtotals (like putting all in bold or
color background of the cells), so
1) I can do it manually but then i have to redo it every
time i refresh the table
2) I should be able to do it automatically and so that if
I refresh the table, it's not necessary to refresh all
the time

And I'm looking after a number 2) solution.

 

[Dries]

Thx for your help,

but is it also possible to format all subtotals at once?
now I'm doing it manually, but that's not the way I want
to do it!

Dries.

 

[Debra Dalgleish]

Turn on 'Enable Selection' -- (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

Then, point to the left side of one of the Subtotal heading cells
(e.g. a cell that contains the text 'DeptA Subtotal')
The pointer should change to a black arrow.
Click, and all subtotal rows will be selected.
Format the selected cells.

 

[Dries]

Thx Debra,

that works just fine!!

Dries.

-----Original Message-----
Turn on 'Enable Selection' -- (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

Then, point to the left side of one of the Subtotal heading cells
(e.g. a cell that contains the text 'DeptA Subtotal')
The pointer should change to a black arrow.
Click, and all subtotal rows will be selected.
Format the selected cells.



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

.