Data Filtering with blank rows

Hi,

Can some one please help with another issue.

I work on large corporate spredasheets and due to historical reasons, have a lot of empty rows seperating diiferent parts of the spreadsheet.

This is fine to help distinguish different bits but it renders the filter function useless over the sheet as the blank rows 'breaks the sheet' as far as the filter is concerned.

As there are a large number of blank rows I don't want to delete them all everytime I want to filter.

Is there an easy way to filter and still have the blank rows i.e. make the filter ignore them?

Many thanks

Frank

Thanks for the quick response.

I will give that a go.

Frank