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

A circular reference occurs when a formula refers to the cell that it's located in. The fix is to either move the formula to another cell, or change the formula syntax to one that avoids circular references.

Click Home > Find & Select > Go To Special. Click Formulas, and if you need to, clear any of the check boxes below Formulas. 4. Click OK. More about finding things in Excel Find or replace text and …

Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.

When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can't resolve it, so it returns the #REF! error.

Excel cannot automatically calculate a formula that refers to the cell—either directly or indirectly—that contains the formula. This is called a circular reference.

A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern and contain the same type of data—such as when you consolidate budget data from different …

If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 …

Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more.

Jun 24, 2025 · Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.