PiVot Table Formatting - Bold Font

G

Guest

I have a PiVot Table like this:

Product ID Factory Sales
100 A 500
B 500
S 200
100 Total 1200
101 A 500
B 500
S 200
101 Total 1200

I want the the raws with total are in bold font. How can I do it? Thanks in
advance.
 
D

Debra Dalgleish

To enable selection --

On the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection

To format the subtotals --

Move the pointer to the left edge of a subtotal heading in the pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select all the subtotal rows for that
field in the pivot table.
Apply the Bold formatting.
 

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

Creating a pivot table which resembles a SQL 'group by' 2
Column Heading on each row in pivot table 1
Calculated Item causes undue repitition in pivot table 2
Pivot Table - show all row fields 1
Pivot Table Set Up 2
PivotTable Grand Totals By Item 4
Grand Total for Rows not Working in a Pivot Table 1
Report Format - Pivot Table not working 2

Top