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