View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default 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!