I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is there
any way to delete all the blank rows???