Excel 2007: selecting blanks

an easy yet extremly useful tip:

Office 2007 changed menus around just a tad, so you might get a little frustrated when trying to do simple things such as deleting all the blank rows in Excel if you were used to your good old Edit menu.

Well, arguably, in Excel 2007 it's even easier and the procedure is the same, it's just been moved around. So on the Home tab, find the Editing section in the Ribbon. Iif you haven't moved things around by default this will be the last one on the right. Find the "Find & Select" Button, which again by default will be the last one on th right, then select "Go to Special...".

There find the radio button which says Blanks then press OK.

now you've got all blanks selected so you can do as you please (though I'm guessing you will most likely press the delete button next...)