Pivot table blank cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,
I am using Pivot Table but have some problam in PT empty cells shown like
(blank) which I really don't need, what shall I do ? I just need them as a
empty !

Thanks in advance.
 
Select a cell that shows (blank)
Type a space character, then press Enter
The cells will appear empty
 
Thank you very much Dear ! That's working !



Debra Dalgleish said:
Select a cell that shows (blank)
Type a space character, then press Enter
The cells will appear empty
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep the word (blank) out of Pivot Table? 2
Pivot tables - 'blank' label 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table magic 1
pivot table (blank) 2
Totaling blank cells in Pivot Tables 8
Pivot table 1
Pivot Table blank rows 1

Back
Top