Find cells that contain formulas

Suppose you need to change some formulas in a hurry, but you're new to the workbook and you don't know where the formulas are. Here's how to find them.

  1. Select a cell, or a range of cells.

    If you select one cell, you search the whole worksheet. If you select a range, you search just that range.

  2. Click Home > Find & Select > Go To Special.

  3. Click Formulas, and if you need to, clear any of the check boxes below Formulas.

Options for finding formulas in the Go To Special box

4.   Click OK.

More about finding things in Excel

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.