You can also just sort the data.
Blank cells sort to the bottom.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
editorial review of special sort add-in (30 ways to sort)






"Rafeek"
wrote in message
...
In an accounting software generated reports, there are alternate blank rows between rows that
contains data.

Row1: Data
Row2: Blank
Row3: Data
Row4: Blank
Row5: Data
..................
..................

I need the blank rows removed for exporting this data into MS Access. Presently I am doing this by
deleting one by one and would love to learn any short cut that is available in excel. I am using
Excel 2007.

Thanks in advance.
rafeek.