View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Pivot tables and blank cells

Beke wrote:
In a few of my columns I have blank cells, when I create a pivot table it
automatically inserts a row for blank cells. I do not need to incorporate
blank cell data into my report. How do I get rid of this?


Hi Beke,

In the drop-down button for the category that contains blanks, uncheck
(blank).