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.

1. Click OK.

More about finding things in Excel

• Find or replace text and numbers on a worksheet

• Find merged cells

• Find ranges by using defined names

• Remove or allow a circular reference

• Find cells that have conditional formats

• Find hidden cells on a worksheet