Go to reference cell

[BoB]

Hello, I have a spreadsheet with numerous tabs at the bottom. If I am looking
at a particular cell is there a way to go directly to the cell that is
referenced. For example, if I am on cell A11 on the tab named Sheet1 and that
cell's formula is =Sheet21!C13 is there a shortcut that will get me to that
cell without having to search through the tabs?

Thanks for any information!

 

[Bill Kuunders]

Only if you want to name all the referenced cells.
I hope you haven't got too many.
Name them for instance sheet21C13 without the !
You can then select the name from the dropdown right next to the formula
bar.

 

[FSt1]

hi
another way....a tad machanical but.....
copy the forumla in the formula bar(not the cell), hit enter.
press F5 to bring up the goto box.
paste the formula in the reference box at the bottom.
if a number appears instead of the formula....start over otherwise...
click ok.

regards
FSt1

 

[Gord Dibben]

Tools>Options>Edit.

Uncheck "edit directly in cell".

Double-click on A11 and you will go to Sheet2!C13


Gord Dibben MS Excel MVP