Excel question - hiding rows without data?

[EddScott]

Is there a way to hide rows without data?

I need this because as the above, I've got 2 sheets building a bunch of other sheets BUT each built sheet has lots of gaps (row 1 in sheet 1, row 2 in sheet 2 etc but row 2 in sheet 1 is empty and row 1 in sheet 2 is empty and so on)

I have a Macro that hides empty rows but it won't hide rows with formulas or rows with VALUE in the cell.

 

[Malakite]

why hide the rows? can you not just sort the data so there are no gaps?

 

[EddScott]

Yes but it would be nice if the gaps would magically disappear

Played about with it and as you say, sorting seems much easier. Got some VB coding but none of them really do what I want.