Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 22nd 05, 11:58 AM
Dr. Darrell
 
Posts: n/a
Default ... How do I Hyperlink to worksheet of an Excel file ...

I have built a worksheet which I want to be a directory to fourteen
worksheets of another Excel File.

The Hyperlinks open the file to the last saved window of the file.

How do I link to only a specific worksheet?

Darrell

  #2   Report Post  
Old July 22nd 05, 02:23 PM
Dave Peterson
 
Posts: n/a
Default

Are you using Insert|Hyperlink to create the hyperlink?

If I point to: Book1.xls

and add the address I want to go to so it looks like: Book1.xls#sheet2!a5

It works ok.

A tip.

If you may be inserting rows/columns in that worksheet, you may want to give
that cell a name and use that. Otherwise, that link will go to sheet2!a5 no
matter if that's really the cell you want.

Same kind of thing with the =hyperlink() worksheet function:

=HYPERLINK('C:\My Documents\excel\[Book1.xls]Sheet2'!A5,"click me")

And that formula is easier to build with book1.xls open and using the mouse to
click on the cell you want.





Dr. Darrell wrote:

I have built a worksheet which I want to be a directory to fourteen
worksheets of another Excel File.

The Hyperlinks open the file to the last saved window of the file.

How do I link to only a specific worksheet?

Darrell


--

Dave Peterson


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
Excel should let hyperlink of PDF jump to a specific page like IE. Kenn Tan Excel Discussion (Misc queries) 2 April 18th 05 09:23 AM
How do I disable the auto hyperlink feature in Excel? DougJ Excel Discussion (Misc queries) 1 April 15th 05 04:37 PM
How can I protect an excel worksheet containing filters? JMcG Excel Discussion (Misc queries) 4 April 13th 05 03:13 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 09:51 PM
Excel Hyperlink: Is there an easier way to follow then double-cli. Bob Small Excel Discussion (Misc queries) 1 December 10th 04 12:24 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017