If you are still here,

then go to the top row select the entire row and go to
"Data" - Filter - Auto filter and check it.
Some arrows will appear to the first row. Go to one of them and open it.
Find "blanks" and then you will have infront of you the blank rows.

mark them all and delete them.
Go to filter again and select "all"

Hope it helps.

"Mr. Low" wrote:

I know very little about this before

May I know the key board steps ?

Thanks

Low

--
A36B58K641


"ice" wrote:

Have you tried to "auto filter" the blanks?

"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