In excel and a pivot table - how can I stop it displaying (blank).

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

Guest

Hi there, I'm learning to use pivot tables. How can I stop the table listing
(blank) in certain cells?

I want to keep the data it relates to but would rather see that cell empty

Regards

Mansel
 
In step 3 of the pivot table wizard, you can click the Options button, and in
this dialog there's a checkbox "For Empty Cells, show" and you can fill in
something (or leave blank)
HTH
Bob Umlas
Excel MVP
 
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 filter list - listing irrelevant subcategorys 1
Pivot Table 2
Pivot tables - 'blank' label 2
Display No Data in Pivot 1
Question on the occupied field of the pivot table in excel spreadsheet 0
pivot table (blank) 2
Totaling blank cells in Pivot Tables 8
Pivot table 1

Back
Top