Results 1 to 5 of 5

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.

  4. #4
    Board Regular
    Join Date
    Jun 2010
    Location
    Atlanta, GA USA
    Posts
    548

    Default Re: How to unbold Pivot Table row labels

    Perhaps this is not what you what, but I unchecked Row Headers under Pivot Table Tools Design.
    Thank you,

    Tony

    Alpharetta/Atlanta GA USA
    Excel 2013, and 2010

  5. #5
    New Member
    Join Date
    Oct 2013
    Posts
    3

    Default Re: How to unbold Pivot Table row labels

    Quote Originally Posted by Tanner_2004 View Post
    Perhaps this is not what you what, but I unchecked Row Headers under Pivot Table Tools Design.
    This was exactly what I wanted. I was using the default PT table style with Tabular Layout and Excel was applying a default bold font to all values under alternating row labels which could not be unbolded any way other than what you suggested. Strangely, every time I autofit the column widths of these default bold row labels, it jams up my computer's processor but unchecking Row Headers did the trick. Thanks!

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