Microsoft Office Tutorials and References
In Depth Information
Making “Special” Range Selections
Table 5-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 (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.
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 Region
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
combination.
Current Array
The entire array (used for multicell array formulas).
Objects
All graphical objects on the worksheet. This is useful if you want to delete all
objects.
Row Differences
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.
Column Differences
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.
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 Cells Only
Only visible cells in the selection. This option is useful when dealing with
outlines or a filtered list.
Conditional Formats
Cells that have a conditional format applied (by using the Home
Styles
Conditional Formatting command).
Data Validation
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.
Data Tools
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.
 
Search JabSto ::




Custom Search