How to clear the word '(blank)' from a cell in a Pivot Table

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

Guest

When a source cell in Excel is empty my Pivot Table comes up with the word
'(blank)' in the cell. How can I hide this word so the cell still appears
but with no text in it in my Pivot Table?
 
Select one of the (blank) cells in the pivot table, and type a space
character, then press the Enter key to complete the change.
 
This is a Cell Format issue that can be resolved by using an IF statement
(see display or hide zero values in Help) or by using a Custom Cell Format
(pick any cell in your sheet and se lect Format Cells Custom and use the help
index to learn what all the little notations mean and copy this new cell
form,at that you create yourself into all the cells where '(blank)' might
occur.
 
You must log in or register to reply here.

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

Pivot Table 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Totaling blank cells in Pivot Tables 8
Refreshing Pivot Table on a protected spreadsheet tab 1
Replace (blank) entry in a pivot report with clear cell 1
Pivot Tables 1
Using merge cells in worksheet for Pivot Table 1
Adding to an existing Pivot Table 7

Back
Top