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.



Caconz wrote:

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?

--

Dave Peterson