View Single Post
  #3  
Old August 24th, 2005, 11:05 PM
Chuck Snyder
external usenet poster
 
Posts: n/a
Default

You can also go back into the list from which your PivotTable was derived
and fill in all the blanks with N/A or a period or whatever character you'd
like. Steps:

1. Select an area of the spreadsheet that encompasses all the blanks.
2. Do an EditGoTo
3. Click on the Special button
4. Select the Blanks radio button and hit OK
5. Type in the replacement character.
6. Do a Ctrl-Enter to fill in all the blank cells.

Adapted from "Pivot Table Data Crunching" by Jelen and Alexander, p. 21.

Chuck