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

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 :-)
------------------------------*------------------------------*----------------



"Eric Stephens" <(E-Mail Removed)> wrote in message
news:A1C0A33B-54D3-4440-9063-(E-Mail Removed)...
> 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
>

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

"Ken Wright" wrote:

> 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 :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
>
> "Eric Stephens" <(E-Mail Removed)> wrote in message
> news:A1C0A33B-54D3-4440-9063-(E-Mail Removed)...
> > 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
> >
>
>
>