removing the word (blank) from pivot table cells

T

techman41973

I generated a pivot table in an excel spreadsheet.
Is there any way to instruct excel not to show the word (blank) in
blank cells?
Thanks
 
D

Debra Dalgleish

Select the cell that contains (blank), and type a space character.

Or, if you don't want to include the data for blanks, click the dropdown
arrow on the field heading, and remove the check mark from (blank).
 
Top