Just as a GPS is a handy gadget for a stubborn guy who refuses to ask for directions, Excel’s Go To Special feature quickly finds and selects cells in a spreadsheet without all of the U-turns and dead ends. The Go To Special window can be launched under the Find and Replace button in Excel 2010 and it offers a plethora of options to choose from.
One of the most useful abilities of Go To Special is selecting blank cells. For example, I first select all of the cells in a table (A1:D6 shown below). In the Go To Special window, I select the Blanks option. After clicking on OK, the empty cells in the table are selected.
With the empty cells selected, I can then change the cells’ background color to yellow, for example. I can also enter a value for the cells, such as zero, making the value apply to all of them at once by holding the Ctrl key while pressing enter.
The Errors option (under Formulas) in the Go To Special screen will select all of the cells with errors. It’s a fast and effective way of making sure a spreadsheet is error-free. After all, few things are more embarrassing than giving someone a spreadsheet with errors where there are supposed to be numbers.