Hiding rows

C

Caconz

I have rows that only display data if the dollar amount is greater than 0.

I would like to automatically hide the rows that have no data.
Is this possible and if so how?
 
D

Dave Peterson

I find the easiest thing to do is to apply Data|Filter|Autofilter to that range.

Then I can filter to show only the non-blanks.
 
Top