software

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?

Autofilter on blanks, then delete all the visible rows.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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