| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
