View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Remove "(blank)" in a pivot table?

click the pull-down under the label. The clear the check box next to (blank)
--
Gary''s Student


"GunnarX" wrote:

Pivot table returns "(blank)" if field is empty. Can this be shut off or
hidden?