remove (blank) from pivot table

J

Jerome Ranch

I'd appreciate any hints on how to remove the (blank) in the body of
pivot tables..so that the cell is indeed, blank (has no text)
Thanks
Jerry Ranch
 
D

Dave Peterson

I fill my empty cells with a formula that looks empty:

=""

Select your range
edit|goto|special
blanks
type
=""
and hit ctrl-enter to fill that range

You could also use an apostrophe, but I like the formula--it's easy to see and
it reminds me why it's there.
 
Top