removing blank rows

[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

 

[Niek Otten]

Hi Matt,

http://www.cpearson.com/excel/excelM.htm#DeleteBlankRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| 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
|

 

[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

 

[Guerilla]

Thanks very much.

Matt