Friday, February 17, 2017

Select cells that contain formulas

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

  3. In the Go To Special dialog box, 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 Excel 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 function, and GROWTH function.

  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

  3. In the Go To Special dialog box, click Current array.

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

Top of Page

No comments:

Post a Comment