Delete Blank Lines
 

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

TIA

Delete Blank Lines
 

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

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

TIA

Delete Blank Lines
 

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


"Saxman" wrote:

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

TIA

Delete Blank Lines
 

go to bottom of sheet
put xxxxxx (or whatever) in A cell
click col A, SELECTS WHOLE COLUMN
f5
SPECIAL
BLANKS
CLICK EDIT
DELETE
ENTIRE ROWS
ENTER
THAT SHOULD DO IT
then dekete xxxxxx
u have 1 more row than the data list

--
JOHNW


"Saxman" wrote:

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

TIA