Try this, Michael:
Select a column. Hit Edit--Go to--Special--Blanks.
Hit Edit--Delete, and choose Entire Row when asked.
************
Anne Troy
www.OfficeArticles.com

"Michael S." wrote in message
...
Is there a way to have excel select empty rows? I imported data and each
record is seperated by an empty row. Considering there are 1000+ rows of
data
it would be quicker to have excel select the empty rows so I could remove
them.

Thank you