Chapter 4: Working with Cells and Ranges
75
FIGURE 4.5Use the Go to Special dialog box to select specific types of cells.
Table 4.1 offers a description of the options available in the Go to Special dialog box. Some of the
options are very useful.TABLE 4.1Go to Special Options
Option What It Does
Comments Selects only 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.
Current Region Selects a rectangular range of cells around the active cell. This range is deter-
mined by surrounding blank rows and columns. You can also press Ctrl+Shift+*.
Current Array Selects the entire array. See Chapter 16 for more information about arrays.
Objects Selects all graphic objects on the worksheet.
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.
continued