Excel's GO TO command is a powerful navigation tool. You can activate the dialog box by either pressing:
F5
CTRL + G
Edit + Go To
The Go To dialog box gives you the option to select one of the named ranges defined within the worksheet or to type in a cell or range reference.
Hidden under the "Special" button are the Go To Special Options from which you can select. Below each of these options are defined.
You can use the GO TO Special on your entire worksheet or a selected range within your worksheet.
Comments Highlights all cells that contains a comment.
Constants Highlights all cells that contains a constant; mainly non-formula cells. A constant can be text or numerical. It would not include a formula where a constant was included instead of a cell reference.
Formula highlights all cells containing a formula if all boxes (Numbers, Text, Logicals, Errors) are checked. You can narrow your search by excluding choices that are not applicable to your needs.
Blanks highlights all cells containing a blank or to express it in other terms, all cells that do not contain information or all empty cells.
Current Region highlights the range of cells surrounding the active cell bounded by blank rows and columns.
Current Array highlights the cells of an array when the active cell is contained in an array.
Object selects all objects on the worksheet such as charts, text boxes or pictures.
Row Differences highlights all cells in the selected row that differ from the contents of the active cell. For multiple rows, the highlighted cells will be based on the cell in the same column as the active cell but within each selected row. For example, if the active cell is C3 and row 4 was also selected, the comparison for row 4 will be based on cell C4.
Column Differences highlights all cells in the selected column that differ from the contents of the active cell. For multiple columns, the highlighted cells will be based on the cell in the same row as the active cell but within each selected column. For example, if the active cell is C3 and column D was also selected, the comparison for column D will be based on cell D3.
Precedents highlights the cells referenced in the formula contained in the active cell. Additional options for this feature can be selected from the Dependents choice. Select the "Direct Only" option to find only those cells that are directly referenced in the formula. The "All Levels" option will locate all cells that are directly or indirectly referenced. Thus if any of the directly referenced cells contain formulas the cells within that formula will also be located.
Dependents highlights all cells containing a formula that references the active cell. The "Direct Only" option finds only those cells containing a direct reference to the active cell. The "All Levels" option includes cells containing indirect references to the active cell. Thus, if the cell has a direct reference to another cell with a formula referencing the active cell, it will be selected.
Last Cell highlights the last cell in the lower right that contains either data or formatting.
Visible Cells Only highlights only those cells that are visible in a range when the range crosses hidden rows or columns.
Conditional Formats highlights cells that contain conditional formats. Additional options for this feature can be selected from the Data Validation choice. Select "All" to include any cell that has conditional formatting applied. Select "Same" to limit the selections to only those cells that have the same conditional formatting as the active cell.
Data Validation highlights cells that have Data Validation applied. Select "All" to include any cell that has Data Validation applied. Select "Same" to limit the selections to only those cells that have the same Data Validation rule as the active cell.
