#1   Report Post  
Steven Stadelhofer
 
Posts: n/a
Default 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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 08:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 12:18 AM
I am trying to link based on a text value instead of cell position John Links and Linking in Excel 3 December 3rd 04 06:29 PM
most effective way to link ms word tables to excel Mark S Lloyd Excel Discussion (Misc queries) 0 November 26th 04 08:11 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"