Show All

Hide All

When you check, update, or audit formulas in a workbook, you can use the Go To Special dialog box to conveniently select one or more cells that contain a formula, or select just the cells of an array formula that calculates multiple results.

• Select a range of cells that contains non-array formulas

• Select a range of cells that contains an array formula that calculates multiple results

Select a range of cells that contains non-array formulas

1. Do one of the following:
   • To check a specific cell range, select the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells.

   • To check the entire worksheet, click any cell to select all cells of this type on the active worksheet.

2. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

   

   The Go To Special dialog box is displayed.

3. Click Formulas.
4. Select or clear one or more of the following check boxes to indicate the type of formula that you want to check based on the formula result:
   • Numbers   A numeric value.
   • Text  A text value.
   • Logicals  A TRUE or FALSE value.
   • Errors  An error value, including #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

If one or more selected cells contain formulas based on the formula result that you selected in step 4, those cells are highlighted, otherwise Microsoft Office Excel 2007 displays a message that no cells were found.

 Top of Page

Select a range of cells that contains an array formula that calculates multiple results

1. Click a cell that contains an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) that calculates multiple results.

   For more information about functions that calculate multiple results, see Create or delete a formula, TREND, and GROWTH.

2. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

   

   The Go To Special dialog box is displayed.

3. Click Current array.

If cells contain the array formula based on the cell that you selected in step 1, those cells are highlighted, otherwise Office Excel 2007 displays a message that no cells were found.

 Top of Page