"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

How To Create A Hyperlink To Another Workbook

Everyone who has surfed the Internet knows the benefits of hyperlinks.

Hyperlinks on a web page are the text or graphics that you can click on to give you instant access to other information no matter where it is located.

Did you know that you can create hyperlinks in Excel? You can create hyperlinks in one workbook that will allow you to instantly open another workbook without having to remember where it is located.

Here's what you do to create a hyperlink to another Excel workbook.

  1. Select a cell where you want to place the hyperlink;
  2. Type a description of the workbook you want to link to;
  3. Right click on that cell and choose Hyperlink...;
  4. Click the File... button and browse to the file location;
  5. Select the file you want to link to and click OK;
  6. If you want to go to a specific sheet in the workbook, click on the Bookmark... button, select the sheet name and click OK.
  7. You can also click the Screen Tip... button to add a description to your hyperlink that will pop up when a user holds the mouse over the hyperlink.
  8. Click OK to close the Insert Hyperlink dialog box and save your workbook.
  9. Try out the hyperlink to see how it works.
Hyperlinks are very convenient in Excel for giving users quick access to related files. I use them to create a Favorites sheet for all my frequently used workbooks and webpages. I'll tell you about how to do that in an upcoming newsletter.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.