removing blank rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guerilla - 16 Feb 2007 11:10 GMT

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

Reply to this Message

Niek Otten - 16 Feb 2007 11:37 GMT

Hi Matt,

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 3 lines]
| regards,
| Matt

Reply to this Message

Bill Ridgeway - 16 Feb 2007 12:29 GMT

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

> Hi,
>
[quoted text clipped - 3 lines]
> regards,
> Matt

Reply to this Message

Guerilla - 16 Feb 2007 12:47 GMT

Thanks very much.

Matt

Reply to this Message