Microsoft Office Tutorials and References
In Depth Information
Using the find and select commands
Using the find and select commands
At the right end of the Home tab on the ribbon, the Find & Select menu displays several
helpful selection commands, as shown in Figure 6-5. In the middle of the menu are five
commands that used to be buried in dialog boxes back in the old days, but they’ve more
recently been promoted to the ribbon because of their widespread use: Formulas,
Comments, Conditional Formatting, Constants, and Data Validation.
Figure 6-5 Use the Find & Select commands to zero in on specific items.
In Figure 6-5, we used the Formulas command to select all the formulas on the worksheet,
which are highlighted by multiple selection rectangles. You can use these specialized
selection commands for various purposes, such as applying specific formatting to formulas and
constants or auditing worksheets for errant conditional formatting or data-validation cells.
The two Go To commands on the Find & Select menu are also helpful for finding and
selecting a variety of worksheet elements. To quickly move to and select a cell or a range
of cells, click Go To (or press F5) to open the Go To dialog box; then type a cell reference,
range reference, or defined range name in the Reference box, and press Enter. You can also
extend a selection using Go To. For example, to select A1:Z100, you can click A1, open the
Go To dialog box, type Z100 , and then press Shift+Enter.
For more about selecting, see “Finding and replacing stuff” in Chapter 8, “Worksheet editing
techniques,” and “Selecting and grouping objects” in Chapter 10, “Creating and formatting
graphics.” For more information about defined range names and references, see “Nam-
ing cells and cell ranges” and “Using cell references in formulas” in Chapter 12, “Building
To move to another worksheet in the same workbook, open the Go To dialog box, and type
the name of the worksheet, followed by an exclamation point and a cell name or reference.
For example, to go to cell A1 on a worksheet called Sheet3, type Sheet3!A1 . To move to
Search JabSto ::

Custom Search