| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Go To pasted Linked cell on click
Can I change a setting to enable going to the tab and cell which is paste
linked into another tab/worksheet in same file. e.g., I pasted 'a1' from tab 1 into tab 2 and I want to click on the cell in tab 2 and go to 'a1' in tab1. I thought there was a setting I could make to enable this. Thanks |
|
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Go To pasted Linked cell on click
You can insert both a link and a hyperlink in the same cell.
1. click on the cell and enter: =Sheet1!A1 2. then click on the cell and: Insert Hyperlink... Place in this document and point to the same cell in Sheet1 -- Gary''s Student - gsnu200835 "Steve Stad" wrote: Can I change a setting to enable going to the tab and cell which is paste linked into another tab/worksheet in same file. e.g., I pasted 'a1' from tab 1 into tab 2 and I want to click on the cell in tab 2 and go to 'a1' in tab1. I thought there was a setting I could make to enable this. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel | |||
| How do I navigate on a click between linked worksheets in Excel? | Excel Worksheet Functions | |||
| Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
Linear Mode
