Another wonderfully simple tip from Chandoo at his Pointy Haired Dilbert blog:
Removing blank rows from other peoples' spreadsheets is something that has taken up my time on a number of occasions. I love this simple tip (that works in Excel 2003 as well as 2007) that reduces this to a few key strokes to remove the lot.
See the tip.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.