Thread
:
removing the word (blank) from pivot table cells
View Single Post
#
2
Debra Dalgleish
Posts: n/a
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).
wrote:
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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Reply With Quote