Can I delete multiple blank rows collectively?

B

bursar

I have imported a report to excel which contains alot of blank rows, almost
every other row. I want to delete the blank rows so I can use the auto filter
function but don't want to select each line individually. Is there a quick
way? Sorry, don't know which version of Excel - how do I find out?
 
B

Bob Phillips

Autofilter on blanks, then delete all the visible rows.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top