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.
- Select a cell where you want to place the hyperlink;
- Type a description of the workbook you want to link to;
- Right click on that cell and choose Hyperlink...;
- Click the File... button and browse to the file location;
- Select the file you want to link to and click OK;
- If you want to go to a specific sheet in the workbook, click on the Bookmark... button, select the sheet name and click OK.
- 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.
- Click OK to close the Insert Hyperlink dialog box and save your workbook.
- 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.