Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I double click a cell and jump to cell's referenced cell
Hi,
Someone once showed me how if you have a a reference to a cell in one sheet you could double click on the cell and it would jump to the referenced cell in the reference cell's sheet. For example. Cell With Reference Referenced Cell in other Sheet A1 <--double click sheet1 cell A1 takes you to -- =Sheet2!A1 |
#2
|
|||
|
|||
You have to make sure you have
tools|options|edit tab|"edit directly in cell" unchecked JerryJuice wrote: Hi, Someone once showed me how if you have a a reference to a cell in one sheet you could double click on the cell and it would jump to the referenced cell in the reference cell's sheet. For example. Cell With Reference Referenced Cell in other Sheet A1 <--double click sheet1 cell A1 takes you to -- =Sheet2!A1 -- Dave Peterson |
#3
|
|||
|
|||
In addition to what Dave said, you could keep the "Edit In Cell" option in
force, and *still* jump to the referenced cell by using a keyboard shortcut. <Ctrl < [ will take you to the referenced cell(s) of the cell in focus, And if that cell happens to be on the same sheet, <Ctrl < ] will return you to the original cell. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Dave Peterson" wrote in message ... You have to make sure you have tools|options|edit tab|"edit directly in cell" unchecked JerryJuice wrote: Hi, Someone once showed me how if you have a a reference to a cell in one sheet you could double click on the cell and it would jump to the referenced cell in the reference cell's sheet. For example. Cell With Reference Referenced Cell in other Sheet A1 <--double click sheet1 cell A1 takes you to -- =Sheet2!A1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jump directly to new cell | Excel Discussion (Misc queries) | |||
Create a Macro to jump to next cell | Excel Worksheet Functions | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
How do I "CTRL [" (jump to a precedent cell) from a European keybo | Excel Discussion (Misc queries) |