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.

  4. They apperceive if women see their admired brilliant accustomed a backpack they will wish to buy them.These admirers cannot allow the prices of those handbags.Therefore,the advantage larboard for them is to gucci replica acquisition a replica handbag.Still,if you accept difficulties of purchasing ability for people,The exact replica artist backpack ability be the best.These high-quality replica handbags attending identical to the aboriginal and are abundant beneath expensive,acceptance you to acquirement one whenever you accept charge of louis vuitton replica it.In a word,while you may charge to absorb added than you can allow on an aboriginal handbag,the replica backpack will amount you much,abundant less,while searching every bit as elegant,adult and chichi as the masterpiece.This agency that affairs replica will accredit you to own altered pieces befitting your apparel and occasion.Purchasing a replica watch from a banker who you apperceive or your acquaintance recommends ability get you a 18-carat replica watch.According to a lot of enthusiasts who adulation to abrasion a replica watch,they adopt to abrasion them because they can allow to but abounding replica watch after replica watches uk activity the pinch.For the amount of a 18-carat branded watch like Rolex,one ability get replica watch for all their ancestors associates and friends.And the replica watch they acquirement cannot be acclaimed from the absolute one.Alone authorities can acquaint the aberration amid a replica watch and a absolute one.If you wish to omega replica abrasion a Rolex on Monday,a Cartier on Wednesday and a Omega on weekends,a replica watch is your best choice.