Tuesday, May 30, 2017

Find cells that contain formulas

Find cells that contain formulas

  1. On the Edit menu, click Go To.

  2. Click Special.

  3. Select Formulas, and select or clear the Numbers, Text, Logicals, or Errors check boxes to find formulas with those characteristics.

  4. Click OK.

    The cells that contain the formulas are selected.

See also

Replace a formula with its result

No comments:

Post a Comment