Hi to all

I have a spreadsheet which has lots of rows of data. It also has lots of
empty rows in between the rows of data. Is there any way of deleting the
empty rows automatically, instead of highlighting each of them one at a time
and deleting them that way? Maybe theres an option within Excel somewhere
where Excel deletes empty rows within a selection? All help most appreciated

Thanks
Bigweed