Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Go To Link
Hello,
I would like to insert in a cell on one tab a 'go to' link which will navigate to another tab in the same worksheet. I am familiar with inserting hyperlinks. But I want to make sure the link goes to a specific tab in the SAME worksheet. e.g., in TAB-1 of worksheet A I want to click on a link to go to a cell reference (e.g., A1) in Tab-5 of the same worksheet A. Thanks, Steve |
#2
|
|||
|
|||
Steven
Select a cell in Sheet1 and right-click and "hyperlink". From the dialog that opens choose "place in this document" Navigate to Sheet5 in the list. A1 is default cell reference. OK your way out. Just for info.......a TAB is a worksheet. A workbook contains one or more worksheets. Gord Dibben Excel MVP On Mon, 13 Dec 2004 09:26:17 -0800, "Steven Stadelhofer" wrote: Hello, I would like to insert in a cell on one tab a 'go to' link which will navigate to another tab in the same worksheet. I am familiar with inserting hyperlinks. But I want to make sure the link goes to a specific tab in the SAME worksheet. e.g., in TAB-1 of worksheet A I want to click on a link to go to a cell reference (e.g., A1) in Tab-5 of the same worksheet A. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |