Hyperlinking into specific worksheet within an Excel File

D

Deb

How do I create a hyperlink into a specific worksheet within an Excel file? I
tried using a (#) bookmark referencing the tab name, but each time the Excel
file opens it enters into the worksheet where the file was saved.
 
A

Andrew Murray

As a New User you should ask you questions in the correct group. Try the
Excel newsgroup.
 
D

Dan L

Save the pages as web pages (.htm or .html) and hyperlink directly to the
page that way.
 
S

Stefan B Rusynko

Create a named range in the Excel sheet you want to open
(in cell A1 or any cell you want to go to)
- In sheet 5 create a named range as say "startsheet5"
Then link it as a bookmark using the named range
workbookname.XLS#startsheet5

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| How do I create a hyperlink into a specific worksheet within an Excel file? I
| tried using a (#) bookmark referencing the tab name, but each time the Excel
| file opens it enters into the worksheet where the file was saved.
| --
| New user looking for quick answers.
 
M

Meck2003

I have tried naming a range in cell A1, but each time it will open to the
last page the file was saved at.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top