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?