Search Not Just Numbers

Tuesday 26 January 2010

Easily remove blank rows in Excel data

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.


  1. Man, really want to know how can you be that smart, lol...great read, thanks.

  2. Hello, you site is very funny he told me to cheer up .. Merry Christmas.

  3. I really liked your article.