| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
