Results 1 to 3 of 3

How to unbold Pivot Table row labels

This is a discussion on How to unbold Pivot Table row labels within the Excel Questions forums, part of the Question Forums category; Using Excel 2007, nested Pivot Table rows always seem to bold all but the inner-most row label. Is there a ...

  1. #1
    New Member
    Join Date
    Nov 2006
    Posts
    8

    Unhappy How to unbold Pivot Table row labels

    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."

  2. #2
    Board Regular
    Join Date
    Feb 2009
    Location
    Anchorage, AK, USA
    Posts
    317

    Default Re: How to unbold Pivot Table row labels

    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).

  3. #3
    New Member
    Join Date
    Nov 2006
    Posts
    8

    Unhappy Re: How to unbold Pivot Table row labels

    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.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com