Chapter 32: Making Your Worksheets Error-Free
661
Using Excel Auditing Tools
Excel includes a number of tools that can help you track down formula errors. This section
describes the auditing tools built in to Excel.Identifying cells of a particular type
The Go to Special dialog box (as shown in Figure 32.6) is a handy tool that enables you to locate
cells of a particular type. To display this dialog box, choose Home ➪ Editing ➪ Find & Select ➪
Go to Special.Note
If you select a multicell range before displaying the Go to Special dialog box, the command operates only
within the selected cells. If a single cell is selected, the command operates on the entire worksheet. n
FIGURE 32.6The Go to Special dialog box.
You can use the Go to Special dialog box to select cells of a certain type, which can often help you
identify errors. For example, if you choose the Formulas option, Excel selects all the cells that con-
tain a formula. If you zoom the worksheet out to a small size, you can get a good idea of the work-
sheet’s organization (see Figure 32.7). To zoom a worksheet, use the zoom controls on the right
side of the status bar. Or, press Ctrl while you move the scroll wheel on your mouse.