Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linked cells
Hi,
On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and Paste Link). With about 20 sheets in a workbook, it gets difficult to go between Sheet1 and the rest of the sheets. Is there a way, e.g. double click on a linked cell on Sheet1 to activate the sheet (Sheet2, Sheet3 ...) with the source cell on it? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linked cells
If you go to Tools=Options=Edit tab and uncheck "Edit Directly in Cell",
then you can double click on it an be taken to the link. -- Regards, Tom Ogilvy "Penka" wrote in message ... Hi, On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and Paste Link). With about 20 sheets in a workbook, it gets difficult to go between Sheet1 and the rest of the sheets. Is there a way, e.g. double click on a linked cell on Sheet1 to activate the sheet (Sheet2, Sheet3 ...) with the source cell on it? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
Linked Cells | Excel Worksheet Functions | |||
linked cells | Links and Linking in Excel | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) |