Datasheet

Making “Special” Range Selections
As you use Excel, you’ll probably wonder how you can 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 4-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 4-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.
NOTE
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 4-1 summarizes the options available in the Go To Special dialog box.
Tip 4: Making “Special” Range Selections
18
04_137666 ch01.qxp 5/22/07 7:31 PM Page 18