+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Remove "Blank" count from Row Labels

  1. #1
    Registered User
    Join Date
    05-21-2020
    Location
    Newcastle upon Tyne
    MS-Off Ver
    Office 13
    Posts
    1

    Pivot Table - Remove "Blank" count from Row Labels

    Hi,

    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.

    Thanks,

    Erica
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-23-2020
    Location
    Guwahati, Assam, India
    MS-Off Ver
    2019
    Posts
    15

    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)

Bookmarks

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