If a formula refers to its own cell directly, or through a chain of references to other cells ultimately refers back to its own cell, you will receive a circular reference warning from Excel.

For those who are working with complex formulas, in many cases, it won’t be easy to identify the source of a circular reference in Microsoft Excel due to the large number of dependent and ...

Excel highlighted the cells ... Click the checkmark in the formula bar (also outlined in red in the screenshot below). Ignore the warning about circular references—just click OK.

Check for Circular References in the spreadsheet ... follow the steps below. If the formula format is Text, Excel will find it difficult to auto calculate the formula. Change the formula format ...

Excel highlights the range and totals ... especially if you’re editing a macro or tracking down a circular reference. So enter this formula into a cell off to the side of your spreadsheet ...