+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Remove "Blank" count from Row Labels

  1. #1
    Registered User
    Join Date
    Newcastle upon Tyne
    MS-Off Ver
    Office 13

    Pivot Table - Remove "Blank" count from Row Labels


    I am trying to remove the blank fields from count in the row labels of a pivot table. Have tried numerous ways to do this but unable to find a solution. Any help would be greatly appreciated.

    Example attached.


    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    Guwahati, Assam, India
    MS-Off Ver

    Re: Pivot Table - Remove "Blank" count from Row Labels

    Remove (blank) cells in PivotTable
    In order to remove (blank) cells and change them to empty cells, follow these steps.
    Insert PivotTable.
    Check all the PivotTable Fields.
    Change the PivotTable to the classic layout (or keep the standard one if you prefer).
    Click inside the PivotTable and Press Alt + A to select all PivotTable data.
    Choose Home >> Styles >> Conditional Formatting >> New Rule.
    Choose Format only cells that contain.
    In Format only cells with, choose Cell Value, and equal to, then type (blank).
    Click the Formatů
    Choose the Number tab and Custom
    Inside the Type field, insert three semicolons.
    Click OK.
    This rule replaced all strings consisting (blanks) to empty spaces.
    Asha Kanta Sharma
    Guwahati, India

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1