Pivot table blank cell

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.
 
D

Debra Dalgleish

Select a cell that shows (blank)
Type a space character, then press Enter
The cells will appear empty
 
G

Guest

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 table (blank) 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table 2
Pivot table 1
Pivot Table blank rows 1
Replace (blank) entry in a pivot report with clear cell 1
Pivot table magic 1

Top