N
Neville Bailey
I have created a pivot table, with numerous sub-totals. Is it possible to
format the sub-total lines so that they appear as bold?
format the sub-total lines so that they appear as bold?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
Have you looked at auto formatting the pivot table. On the pivot table
toolbar there is a button with a lightning bolt. It might be worth a look.
toolbar there is a button with a lightning bolt. It might be worth a look.
N
Neville Bailey
Thanks, Jim - that's exactly what I was looking for!
R
Roger Govier
Hi Neville
In addition to Jim's suggestion, you can also choose any formatting you wish
just for the subtotal rows.
Hover with the cursor in the left most cell of the subtotal row until you
see a bold right pointing arrow, then click.
that will select all Subtotals>Format in any way you wish.
In addition to Jim's suggestion, you can also choose any formatting you wish
just for the subtotal rows.
Hover with the cursor in the left most cell of the subtotal row until you
see a bold right pointing arrow, then click.
that will select all Subtotals>Format in any way you wish.
N
Neville Bailey
Wow, thanks Roger - even better! Thanks.
Roger Govier said:Hi Neville
In addition to Jim's suggestion, you can also choose any formatting you wish
just for the subtotal rows.
Hover with the cursor in the left most cell of the subtotal row until you
see a bold right pointing arrow, then click.
that will select all Subtotals>Format in any way you wish.
P
Pat Dools
Such a simple thing - GREAT to know! Thank you!