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