Find cells that contain formulas

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

  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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.