Formatting Pivot Table Item Row Totals

E

Eric Stephens

Hello,

Is there a way to automatically have the item row totals appear in bold
while the detail remains unbold?

For example, if I have a Pivot Table that displays the following data:

State City Total
Tennessee Nashville 500
Chattanooga 300
Memphis 200
Knoxville 100
Tennessee Total 1,100

I would want the number 1,100 to appear in bold while the other four numbers
(the detail) are not bolded. Any help would be appreciated!

Thanks,
Eric
 
K

Ken Wright

You should be able to just select all the totals by hovering the mouse over
the start of any of the totals rows, where the cursor should change to an
arrow. Click and this selects all of them and then just apply bold
formatting. Not automatic but takes just a second.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
E

Eric Stephens

Thanks, Ken! I also discovered that I can use one of Excel's pivot table
formats.
 
Top