1

I work on a complex Excel file with worksheets (tabs). I have to move one cell due to adding other things and and want to find out what the consequences are. But I do not want to check all the other cells in the other worksheets.

Is there a possibility to find out in Excel what other cells (in other worksheets) access one specific cell?

Improve this question

2 Answers 2

Reset to default
3

Select the cell you are planning to move, then click "Trace Dependents" on the Formulas tab:

enter image description here

Improve this answer
1

As mentioned already, "trace dependents" what you need.

However if you move your cell (by cut & paste or drag & drop) all the references will be updated to the new location.

Neither of above options work when your cell is referenced indirectly (by INDIRECT or OFFSET function)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .