How can i jump to a cell referenced in a formula?
 

Anyone know of a way to jump to a cell referenced in a formula, when it is
not the first reference...e.g. Formula bar reads
"=D5+G5"
CTRL+{ will take me to D5 but is there a way to get to G5 easily? Especially
helpful in long formulas and off sheet links.

thanks

Ctrl-Shift-{ than press tab.

HTH,
Bernie
MS Excel MVP


"PowerExcelWannabe" wrote in message
...
Anyone know of a way to jump to a cell referenced in a formula, when it is
not the first reference...e.g. Formula bar reads
"=D5+G5"
CTRL+{ will take me to D5 but is there a way to get to G5 easily? Especially
helpful in long formulas and off sheet links.

thanks