Pivot Table question

[s boak]

Hi Folks:

I'm helping a pal with a table that has little data, and when the PT is
setup, the result is 90% of the cells have the word "blank"
Any way to have the cells show nothing (be empty) ??

Thanks
Steve

 

[Dave Peterson]

Try just typing a space character over it the (blank).

Debra Dalgleish has a pivottable addin that you may want to use to make
somethings easier:
http://www.contextures.com/xlPivotAddIn.html
and for instructions:
http://www.contextures.com/xlPivotAddIn02.html

 

[s boak]

Cool - - -
Thanks a bunch
SB

Try just typing a space character over it the (blank).

Debra Dalgleish has a pivottable addin that you may want to use to make
somethings easier:
http://www.contextures.com/xlPivotAddIn.html
and for instructions:
http://www.contextures.com/xlPivotAddIn02.html