formatting blank cells in a pivot table

  • Thread starter Thread starter jonespe
  • Start date Start date
J

jonespe

I am working with a Pivot table that pulls in several
blank fields. But instead of leaving them blank, excel is
inserting the word "(blank)". I tried going to table
options, selecting the "For empty cells, show:" checkbox
and putting in a space, but to no avail. (I also tried
using other characters, but nothing is changing in the
pivot table.) Any suggestions would be most welcome!
 
You could hide the (blank) entries with conditional formatting:

1. Select the cells in the pivot table
2. Choose Format>Conditional Formatting
3. Leave the first dropdown as Cell Value Is
4. From the centre dropdown, choose Equal to
5. In the text box, type (Blank)
6. Click the Format button
7. On the Font tab, choose white (or appropriate colour)
to match the cell background
8. Click OK, click OK
 
i have a pivot table in which i have checked the "For empty cells, show"
option, but left the cell blank. i get a blank where there are no
values. when i uncheck it, it shows me 0 (zero).
 
??? - Don't worry about empty cells, all you are looking to do is count the n's.
Drag the invoice number field off the report and just use the 'User' and
'Taxable' fields to get your count. is this sensitive data or are you able to
mail me a copy and I can try and set it up for you. You would need to take the
NOSPAM bit out of my email address.
 
Back
Top