Delete Blank Lines

S

Saxman

If there are a number of lines on a worksheet that are blank, can they
be deleted in one operation?

TIA
 
B

Bob Umlas

If you can sort the rows, the blanks will sort to the bottom, and
effectively "disappear"
OR, you can put in a formula outside your range, like:
=IF(COUNTA(A1:Z1)=0,2,1) and fill down, then sort on this column -- puts the
blanks at the bottom (they have the "2")
Bob Umlas
Excel MVP
 
R

Ron Coderre

Try this:

Select a single column range that encompasses filled cells and blank cells
(whose rows will be deleted).

e.g. Select from A2:A100, where blanks in that range represent rows to be
deleted.

Press the [F5] key.....that's the shortcut for <edit><goto>
Click the [Special] button
Check: Blanks....(now only the blank cells will be selected)

Then, from the Excel main menu:
<edit><delete>
Check: Entire row
Click [OK]

Does that help?

If NO....<edit><undo>
***********
Regards,
Ron

XL2002, WinXP
 
Top