To find cells that contain formulas, click Home, Find & Select, and Go To. Click Special, and then click Formulas. You can search part or all of a worksheet.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.

Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

Here’s how: Click Open in Excel and use error checking to detect errors in formulas. For news about the latest Excel Online updates, visit the Microsoft Excel blog. For the full suite of Office …

To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display and trace the relationships between these cells …

Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors …

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.