Microsoft Office Tutorials and References
In Depth Information
Making “Special” Range Selections
Making “Special” Range Selections
In some cases, you want to locate specific types of cells in your worksheets. For example,
wouldn’t it be handy to be able to locate every cell that contains a formula, or perhaps all cells
whose values depend on the current cell?
Excel provides an easy way to locate these and many other special types of cells.
The key to many types of special selections is the Go To Special dialog box. Choose Home
Find
& Select
Go To Special to display the Go To Special dialog box, as shown in Figure 5-1. Another
way to open the Go To Special dialog box is to press F5 and then click the Special button in the
Go To dialog box.
Figure 5-1: Use the Go To Special dialog box to select specific types of cells.
After you make your choice in the Go To Special dialog box, Excel selects the qualifying subset of
cells in the current selection. Usually, this results in a multiple selection. If no cells qualify, Excel
lets you know with the message No cells were found .
If you bring up the Go To Special dialog box when only one cell is selected, Excel
bases its selection on the entire active area of the worksheet. Otherwise, the selection
is based on the selected range.
Table 5-1 summarizes the options available in the Go To Special dialog box.
 
Search JabSto ::




Custom Search