Removing Blank Rows

[MarkC]

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

 

[Roger Govier]

Mi Mark

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

 

[Lori]

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.