How to unbold Pivot Table row labels

[pschommer]

Using Excel 2007, nested Pivot Table rows always seem to bold all but the inner-most row label. Is there a way to unbold all row labels?

Displaying in Classic layout, tabular form, without expand/collapse buttons. Showing/Hiding subtotals doesn't seem to matter.

I don't recall older versions (pre-2007) having this "feature."

[sr12345]

Try this:

Click on the a cell in the row you want to change (any of the affected subtotal lines).
From the HOME tab, at the right is the EDITING section.
Under the binocular tab, called FIND AND SELECT, select SELECT OBJECTS.
This should place a thin blue line around that and all other subtotals at the same level. Make the changes you want (such as unbolding).

[pschommer]

After turning on 'Select Objects', the Font options are grayed out. No luck there.


It's also interesting that other font options will affect the outer row labels *except* for bold.