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 skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×