Pivot Tables

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

I am trying to get (blank) to stop appearing in cells that contain no data.

Can anyone help?
 
You have a few choices.

Fill those blank cells (in the original data) with
1. a spacebar (yech).
2. an apostrophe
3. a formula that leaves the cell looking blank. =""

I like the third. I hope that it reminds me that it's there for a real reason.

Or fill them with something you like better.

A quick way to fill that range:
select the range
edit|goto|special|Blanks
type what you want and hit ctrl-enter to fill all the cells in the selection
 

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 Help! 1
Pivot table report invalid 0
Pivot Table (blank) Cells 3
Pivot Table display 1
Pivot Table selection that will allow Grouped fields to show up ineach cell 1
Turning Data into a Table 1
Export Pivot table 1
How to base a pivot table on another pivot table? 3

Back
Top