How to go to formulas references in Excel

To access Excel formulas' references of a selected cell, you first need to trace the formula dependents in Formulas tab > Trace Dependents button.

The blue arrows will show the dependent cells:

If there is a dotted arrow it means the cell is linked to another sheet's cell or another file's cell. Double click on the arrow to navigate to the reference cell:

A Go To dialog box will pop up: Select the reference and click OK to jump to that specific cell:

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com

How to modify the reference cell in an Excel formula using the indirect function

The "indirect" function allows to decompose your formula and enter the reference cells outside of the formula.

For example if you want to multiply the cells A1 per 10 then you can write the text "A1" in a separate cell  (in C1 in the example below) and then simply enter the formula:

=INDIRECT(C1)*10

This function is particularly interesting if you want to apply a certain logic on the reference cells and to control them "outside" of the formula.

The example below show how to retrieve the value of cells A1s of each sheet of the workbook: enter the sheet names in column A, the cells reference in column B and enter the formula:

=INDIRECT(A3&"!"&B3)

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com