Pivot tables in Excel - Fix to not show BLANK


I am so happy, I finally figured out how to trick excel 
into not showing the blank cell in a pivot table without 
limiting my data set!

In the Pivot table layout move the field from row to 
page.  Then double click on the field and click on 
the "blank" to hide it.  Move the field back to row and 
hit finish.

It seems like you always have to "trick" MS software to 
do what you want.
anonymous (74722)
8/24/2004 9:55:24 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 42


Similar Artilces: