Without sorting..............select column A then
EditGotoSpecialBlanks

EditDeleteEntire Row.


Gord Dibben Microsoft Excel MVP

On Sat, 27 Aug 2011 17:07:33 +0300, "Rafeek"
wrote:

Thank you, Jim.

"Jim Cone" wrote in message
...
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.