Microsoft Office Tutorials and References
In Depth Information
Making “Special” Range Selections
Table 5-1: Go To Special Options
What It Selects
Only the cells that contain cell comments.
All non-empty cells that don’t contain formulas. This option is useful if you have
a model set up and you want to clear out all input cells (so you can enter new
values), but keep the formulas intact. Use the check boxes under the Formulas
option to choose which cells to include.
Cells that contain formulas. Qualify this choice by selecting the check box for
the type of result: Numbers, Text, Logicals (the logical values TRUE or FALSE),
All empty cells.
A rectangular range of cells around the active cell. This range is determined by
surrounding blank rows and columns. You can also use the Ctrl+A shortcut key
The entire array (used for multicell array formulas).
All graphical objects on the worksheet. This is useful if you want to delete all
If one row is selected, cells that are different from the active cell. If more than
one row is selected, the same comparison is done, but the comparison cell for
each row is the cell in the same column as the active cell.
If one column is selected, cells that are different from the active cell. If more
than one column is selected, the same comparison is done, but the comparison
cell for each column is the cell in the same rows as the active cell.
Cells that are referred to in the formulas in the active cell or selection (limited to
the active sheet). You can select either direct precedents or precedents at any
Cells with formulas that refer to the active cell or selection (limited to the active
sheet). You can select either direct dependents or dependents at any level.
The lower right cell in the worksheet that contains data or formatting.
Visible Cells Only
Only visible cells in the selection. This option is useful when dealing with
outlines or a filtered list.
Cells that have a conditional format applied (by using the Home
Conditional Formatting command).
Cells that are set up for data entry validation (by using the Data
Data Validation command). The All option selects all cells of this type. The Same
option selects only the cells that have the same validation rules as the active cell.
When you select an option in the Go To Special dialog box, be sure to note which
suboptions become available. For example, when you select the Constants or Formulas
option, the four suboptions become available to help you further refine the results.
Likewise, the Dependents suboptions also apply to Precedents, and the Data
Validation suboptions also apply to Conditional formats.