Microsoft Office Tutorials and References
In Depth Information
Selecting with Go To Special
“Select Special” because you can use it to quickly find and select cells that meet certain
After you specify one of the Go To Special options and click OK, Excel highlights the cell or
cells that match the criteria. With a few exceptions, if you select a range of cells before you
open the Go To Special dialog box, Excel searches only within the selected range; if the
current selection is a single cell or one or more graphic objects, Excel searches the entire active
worksheet. The following are guidelines for using the Go To Special options:
Refers to any cell containing static data, such as numbers or text, but not
Current Region Handy when you’re working in a large, complex worksheet and
need to select blocks of cells. (Recall that a region is defined as a rectangular block of
cells bounded by blank rows, blank columns, or worksheet borders.)
Current Array
Selects all the cells in an array if the selected cell is part of an array
Last Cell Selects the cell in the lower-right corner of the range that encompasses
all the cells that contain data, comments, or formats. When you select Last Cell, Excel
finds the last cell in the active area of the worksheet, not the lower-right corner of the
current selection.
Visible Cells Only
Excludes from the current selection any cells in hidden rows or
Selects all graphic objects in your worksheet, regardless of the current
Conditional Formats Selects only cells that have conditional formatting applied.
You can also click the Home tab and then click the Conditional Formatting command
on the Find & Select menu.
Data Validation Using the All option, selects all cells to which data validation has
been applied; Data Validation using the Same option selects only cells with the same
validation settings as the currently selected cell. You can also click the Home tab and
then click the Data Validation command on the Find & Select menu, which uses the
All option.
For more information about graphic objects, see Chapter 10. For more information about
conditional formatting, see “Formatting conditionally” in Chapter 9, “Worksheet formatting
Search JabSto ::

Custom Search