Fill Blank Cells in Excel 2010 / 2007

1. select columns
2. click on the ribbon’s tab: “Find & Select”, in dropdown list click “go to special…”
3. in the Go To Special dialog box, Chose Blanks, press OK.

You may also like...