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
Option
What it does
Comments
Selects the cells that contain a cell comment.
Constants
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
include.
Formulas
Selects cells that contain formulas. Qualify this by selecting the type of
result: numbers, text, logical values ( TRUE or FALSE ), or errors.
Blanks
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.
Current region
Selects a rectangular range of cells around the active cell. This range is
determined by surrounding blank rows and columns. You can also press
Ctrl+Shift+8 (Ctrl+*).
Current array
Selects the entire array.
Objects
Selects all embedded objects on the worksheet, including charts and
graphics.
Row differences
Analyzes the selection and selects cells that are different from other cells in
each row.
Column
differences
Analyzes the selection and selects the cells that are different from other
cells in each column.
Precedents
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.
Dependents
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.
14
Last cell
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 fi filtered list or table.
Conditional
formats
Selects cells that have a conditional format applied (by choosing
Home
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.
Styles
Data validation
Selects cells that are set up for data entry validation (by choosing Data
Date
Tools
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.
Search JabSto ::




Custom Search