Removing Blank Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkC - 20 Jun 2007 07:23 GMT

Using Excel 2002:

This is probably one of the top ten most asked questions, and saw some
related posts. But like to know, if there is a simple non-formula way of
clearing blank rows in a list? Mark the cells, then just have a action to
"Clear Blank Rows".

Thanks,

M

Reply to this Message

Roger Govier - 20 Jun 2007 07:43 GMT

Mi Mark

Select column A >press F5>Special>select Banks>OK
Whilst the selected cells are highlight>right click>Delete>Entire Row

Signature

Regards

Roger Govier

> Using Excel 2002:
>
[quoted text clipped - 6 lines]
>
> M

Reply to this Message

Lori - 20 Jun 2007 11:17 GMT

That will delete all cells containing blanks, some of which may have
data. One way to delete all rows that are blank is...

Hide all rows containing data:

> Select all cells, [Shift+Tab] [Ctrl+\] [Ctrl+9]

delete visible rows:

> Select all cells, [Alt+;] [Ctrl-]

Then unhide rows.

> Mi Mark
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: