Find all references to a cell

calendar_today Asked Jan 10, 2013
thumb_up 24 upvotes
history Updated April 16, 2026

Question posted 2013 · +11 upvotes

I have the following data 

    -----------------------------------
.      A     B     C

 1    Data  Total  Left
 2    D1     10     5
 3    D2     20    13
 4    D3     30    21
 5   
 6   
 7    =A2   1     
 8    =A3   2
 9    =A4   3
 10   
 11   =A2   4
 12   =A3   5
 13   =A4   6   

    -----------------------------------

I am looking for two thing specifically.

Is there a way to find all references to a cell?

Is there a way to increment the cell letter? i.e. When I find the reference A7(for A2), I want to get the value for B7.

Accepted answer +24 upvotes

Is there a way to find all references to a cell?

Select the area of the sheet you want to examine, and under the Formulas menu, select Trace Precedents. This will show which cells are used in formulas in the selected area

enter image description here

This can be automated with VBA if required.

Is there a way to increment the cell letter?

If you mean you want to change the formula in a cell, that would require VBA.

If you mean something else, more explanation is needed.

Top excel Q&A (6)

+24 upvotes ranks this answer #22 out of 167 excel solutions on this site — top 13%.
excel