Datasheet

TABLE 4-1 GO TO SPECIAL OPTIONS
Option What It Selects
Comments Only the cells that contain cell comments.
Constants 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 and enter new values.
The formulas remain intact. Use the check boxes under the Formulas option to
choose which cells to include.
Formulas 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),
or Errors.
Blanks All empty cells.
Current A rectangular range of cells around the active cell. This range is determined
Region by surrounding blank rows and columns. You can also use the Ctrl+Shift+8
shortcut key combination.
Current The entire array (used for multicell array formulas).
Array
Objects All graphical objects on the worksheet.
Row If one row is selected, cells that are different from the active cell. If more
Differences 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.
Column If one column is selected, cells that are different from the active cell. If
Differences 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.
Precedents 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 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.
Last Cell The lower-right cell in the worksheet that contains data or formatting.
Visible Only visible cells in the selection. This option is useful when dealing with
Cells Only outlines or a filtered list.
Conditional Cells that have a conditional format applied (by using the Home
➪
Formats Styles ➪ Conditional Formatting command).
Data Cells that are set up for data entry validation (by using the Data
➪ Data
Validation Tools
➪ 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.
Tip 4: Making “Special” Range Selections
19
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 19