How To Find Circular Reference In Excel. Move mouse over the Circular References item in the drop down list and it shows the cells with circular references. Start by selecting the first cell listed and then sorted out the problem.

Move mouse over the Circular References item in the drop down list and it shows the cells with circular references. Click the Arrow button besides the Error Checking button. Start by selecting the first cell listed and then sorted out the problem.

Find out and locate the cell in Circular Reference.

Because Excel circular references can iterate indefinitely creating an endless loop thus significantly slowing down the workbook calculations. Then click Error Checking Circular References. Below are the steps to find a circular reference in Excel. If youre using Excel on a Mac click the Excel menu and select Preferences.