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

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.

Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right.

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 …

Copy all the cells in this table and paste it into cell A1 on a blank worksheet in Excel. Tip: Before you paste the data into Excel, set the column widths for columns A through D to 250 pixels, and click …

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.

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

The data within a DataFrame can be returned as Excel values instead of as a Python object. Output a DataFrame as Excel values to incorporate other Excel-based analytics like charts, Excel formulas, …

In effect, the workbook automatically cancels the circular reference. This prevents decrease in performance that otherwise might result from trying to calculate a circular reference.

Excel displays a red circle around any cells that contain invalid data. All cells that don't meet their data validation criteria are circled, including values that were typed, copied, or filled in the cells, calculated …