View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Hide empty rows in pivot table Excel 2003

Hi
Double click on the field and de-select Show Items with no data.

--
Regards
Roger Govier

"menda" wrote in message
...
Hi,

I have a problem displaying pivot tables in Excel 2003. I would like blank
rows to be hidden, but I don't find any options for this. In Excel 2007 I
found it at the pivot tables options and in owc pivot table I found it
under
commands and options.

Does anyone know an option in Excel 2003?

Thanks for the help.

L.M.