How To Find Circular References In Excel?

Go to the Formulas tab

Click Error Checking

Select Circular References

Review the listed cell address

Click each circular reference to jump to the cell

Use Trace Precedents to inspect linked cells

Use Trace Dependents to inspect affected cells

Check the status bar for circular reference alerts

Use Find and Replace to search formulas for self-references

Review formulas that refer to their own cell or a loop of cells

Suggested for You

Trending Today