Excel Option: Go to cell the Formula is referencing

[gheyman]

There is a way to adjust your setting so that if you right click or double click (I don't remember which) in the cell it automatically brings you to the cells reference.

Example
If I have a formula in cell A1 on Tab1, and the formula is 'Tab2'!C5, and I double click it automatically brings me to Tab2C5

Can remind me on how to set the options to do this?

Thanks

 

[Domenic]

You will need to use VBA code. If you only want this functionality for a specific sheet within your workbook, you would use the Worksheet_BeforeDoubleClick event handler. However, if you want this for any sheet within your workbook, you would use the Workbook_SheetBeforeDoubleClick event handler. If you'd like to pursue this, post back any and all details, and someone will likely be able to provide you with the help you need.

 

[thisoldman]

In File >> Options >> Advanced, uncheck "Allow editing directly in cells".

 

[Rick Rothstein]

If you'd like to pursue this, post back any and all details, and someone will likely be able to provide you with the help you need.

One of the details should be what should happen if the formula has two or more cell references in it or it the cell reference is a (large) range of cells.