Automatically select empty rows

[Guest]

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

 

[Anne Troy]

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

 

[Guest]

This also works fine...Select any one column, Click on Data>Auto Filter. From
trhe drop down list select "Blanks". You now have all the blank rows in front
of you. You can now select all and delete them. The hidden rows won't be
deleted.