In Excel 2007, choose Go To Special from the Find and Select dropdown list in the Editing group on the Home tab. Select Blanks. When you click OK, Excel will select all the blank cells in A2:A11.