Remove (blank) from pivot table

Anonymous
2011-02-25T12:16:56+00:00

Hi,

My source data has empty cells.  When I PT this data - the PT shows "(blank)" for the empty cells.  How can I keep the cells "empty" in the PT.  I do not want to manually filter and uncheck (blank) as this removes other data which is needed.

TIA,

PS

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2011-02-25T14:15:06+00:00

Excel 2007/2010 PivotTable

Show blank cell instead of (blank)

in RowField/ColumnField item labels.

http://c3017412.r12.cf0.rackcdn.com/01_23_11.xlsx

If you get *.zip, don't unzip, just rename *.xlsx

Was this answer helpful?

200+ people found this answer helpful.
0 comments

46 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-12-14T16:37:54+00:00

    Right-click in your PT

    Go to Filter > Label Filters

    Select "does not equal" from the dropdown

    Click OK

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-02-18T18:12:15+00:00

    This may not be a fix for Excel 2013, yet might solely be with my attempt on a Win7 computer w/o admin rights...

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-26T06:04:29+00:00

    This only work for Values fields, but doesn't work for Columns/Rows fields.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-02-02T15:14:49+00:00

    Clever. Solve the problem in the data not the pivot.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments