Microsoft Office Tutorials and References
In Depth Information
Selecting special types of cells
Table 14.1 offers a description of the options available in the Go to Special dialog box. Some
of the options are very useful.
TABLE 14.1 Go to Special Options
What it does
Selects the cells that contain a cell comment.
Selects all nonempty cells that don’t contain formulas. Use the check boxes
under the Formulas option to choose which types of nonformula cells to
Selects cells that contain formulas. Qualify this by selecting the type of
result: numbers, text, logical values ( TRUE or FALSE ), or errors.
Selects all empty cells. If a single cell is selected when the dialog box displays,
this option selects the empty cells in the used area of the worksheet.
Selects a rectangular range of cells around the active cell. This range is
determined by surrounding blank rows and columns. You can also press
Selects the entire array.
Selects all embedded objects on the worksheet, including charts and
Analyzes the selection and selects cells that are different from other cells in
Analyzes the selection and selects the cells that are different from other
cells in each column.
Selects 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 level.
Selects 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.
Selects the bottom-right cell in the worksheet that contains data or
formatting. For this option, the entire worksheet is examined, even if a
range is selected when the dialog box displays.
Visible cells only
Selects only visible cells in the selection. This option is useful when dealing
with a ﬁ filtered list or table.
Selects cells that have a conditional format applied (by choosing
Conditional Formatting). The All option selects all such
cells. The Same option selects only the cells that have the same conditional
formatting as the active cell.
Selects cells that are set up for data entry validation (by choosing Data
Data Validation). The All option selects all such cells. The Same option
selects only the cells that have the same validation rules as the active cell.