Home |
Search |
Today's Posts |
#1
|
|||
|
|||
... 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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let hyperlink of PDF jump to a specific page like IE. | Excel Discussion (Misc queries) | |||
How do I disable the auto hyperlink feature in Excel? | Excel Discussion (Misc queries) | |||
How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Excel Hyperlink: Is there an easier way to follow then double-cli. | Excel Discussion (Misc queries) |