How can I make pivot table sub-totals bold?

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?
 
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.
 
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.
 
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table totals 3
can I bold or have different colors in a pivot table? 1
Excel 2003 Pivot Formatting 2
Grand Total for Rows not Working in a Pivot Table 1
Referencing a pivot tables Grand Totals Column 1
Sub total 1
Pivot Table - move Totals column 1
Pivot Table Column Totals - XL2003 5

Top