Go to reference cell
 

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!

Go to reference cell
 

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.

--
Greetings from New Zealand



"BoB" wrote in message
...
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!

Go to reference cell
 

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
"BoB" wrote:

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!

Go to reference cell
 

ToolsOptionsEdit.

Uncheck "edit directly in cell".

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


Gord Dibben MS Excel MVP

On Thu, 10 Apr 2008 13:19:02 -0700, BoB wrote:

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!