Hello Ron,

I tried your steps, It works very well. Many thanks for your help

May I know what are steps for the reverse , i.e. to insert one, two or three
blank rows of cells to lines of data ?

Kind Regards

Low Seng Kuang




--
A36B58K641


"Ron Coderre" wrote:

Try something like this:

Select a column range in which a blank cell indicates a row to be deleted.
(Example: C5:C1000)

Press the [F5] key......that's the shortcut for <edit<goto
Click the [Special] button
Check: Blanks
Click the [OK] button

(Now only the blank cells are selected)

From the Excel main menu:
<edit<delete<entire row

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mr. Low" wrote:

Dear friends,

I am using Seagate Infordesktop Software to run reports in Excel 2002 format.

My report was designed with an empty row between each data line from top to
bottom.

I need to eliminate those empty row spacing without altering the sequence of
the data lines. May I know is there any shortcut or keyboard command for
doing this ?
Currently

I am sorting block by block of the data to eliminate the rows. I cannot do
it in one go for the entire worksheet asonly the first column of the line of
each block of data has a reference number.

I would be glad if some one who is knowledgable in MS Excel 2002 Spreadsheet
could advise me on this.

Thanks

Low Seng Kuang
Malaysia
--
A36B58K641