removing blank rows

G

Guerilla

Hi,

I have a large document which contains numerous blank rows. How can I
remove them without spending hours manually deleting the rows?

regards,
Matt
 
B

Bill Ridgeway

In a helper column insert 1 in the first cell and 2 in the second cell.
Highlight these two cells and drag down (small box on the bottom right) to
the last row. This will give a sort key so that the spreadsheet may be
sorted to the same order (less the blanks).

Sort on any of the other columns. Delete the blank rows.

Sort using the helper column

Regards.

Bill Ridgeway
Computer Solutions
 
Top