Free computer Tutorials
|HOME||Stay at Home and Learn|
How to add an Hyperlink to an Excel Spreadsheet
If you have a lot of different worksheets and want a quick way to jump between them, you can use Hyperlinks. Hyperlinks are those underlined bits of text on the internet that lead to web pages
To get a feel for how they work in Excel, start a new spreadsheet and do the following:
The icons on the left of the dialogue box are all the places you can link to: Existing file or web page, This document, New document, or an Email address.
We're going to place links in specific cells of three different worksheets.
Now that we have a selected a page to link to, we can specify that Excel goes to a cell of our choice:
Our A1 cell has nothing in it. So to insert some text for our link, do this:
We can add a screen tip as well.
Click the button in the top right of the dialogue box "Screen Tip". Another dialogue box pops up, like the one below:
Click on the link and see what happens. Now it's your turn to try it.
In cell C10 of the spreadsheet, insert a Hyperlink to take you to cell B10 of Sheet 2. Add a suitable Screen Tip.
In cell B10 of sheet 2, insert a Hyperlink to take you to cell A1 of Sheet 1. Add a suitable Screen Tip.
And that ends this somewhat brief introduction to Web integration. There a whole lot more you can do with Excel and an internet connection: Upload data from a spreadsheet to a web page; Save a spreadsheet as a web page; Publish a spreadsheet to web page that others can interact with; Hold an Online discussion. In fact, an entire book could be written on Excel and the Internet!
To wrap up this Excel course, the final section details a few Extra things you can do with Excel. It starts with something called Object Linking and Embedding.