Select cells that contain formulas

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.

What do you want to do?

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 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.

    Excel Ribbon Image

    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 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.

    Excel Ribbon Image

    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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×