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.

  1. Click Home > Find & Select > Go To.

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

  1. Click OK.

More about finding things in Excel

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!