Can I delete multiple blank rows collectively?
 

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?

Can I delete multiple blank rows collectively?
 

Autofilter on blanks, then delete all the visible rows.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bursar" wrote in message
...
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?