Remove (blank) from pivot table

The BEST way is just to type Alt+255 on one of the containing (blank) cell on pivot area to eliminate this word and to make it empty cell.

Format your data as table. and select only the contents of the table for pivot chart. Once you update/add colums the data will be automatically updated in pivot table also.

Click on the drop down arrow in your pivot table.

Then select label filters.

select equals and then use the drop down to reselect notequals.

then type in (blank).

Hi,

I figured a workaround which you might be interested in. In essence it involves masking the string (blank) with white color fonts using conditional formating. Needs to be done one time only upon the whole sheet or PT or range of cells.

1. select the whole sheet/ table/ range of cells
2. select [Conditional Formatting] -> [New Formatting Rule]
3. in the [New Formatting Rule] dialog window

select [Format only cells that contain]

under the [Format only cells with:] select [Cell Value] from the drop-down list - actually it is selected by default ; select [equal to] from the drop-down list next; type (blank) in the third box 

4. then press the [Format] button to set the format
5. it opens another dialog window about formatting
6. select [Fonts] tab (it is the default one)
7. select white color for fonts
8. OK and OK again and you've done it :)

In this way, (blank) will not visually annoy you and the same time you don't mess with cells contents.

Hope to have been of help

*** Email address is removed for privacy ***

Thank you!!! This worked even after a refresh!!!  I tweaked it a bit because I am using multiple colors for my lines.  I did Conditional Formatting - New Rule - Format Only cells that contain - Cell Value - Equal To - ="(blank)" - Format - Number - Custom

• ;;;  - OK  [(that was three semi-colons]