|
|
|
|
|
How to add a link to another sheet in Excel 2010
Hyperlinks is a real handy function in Microsoft Excel, let me show you how to crate a hyperlink to another Sheet.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
You have some data on Sheet1 ...
|
|
| |
2.
|
|
|
... and some more data on Sheet2. Now you want to add a hyperlink to Sheet1. When the hyperlink is clicked it should bring you to the Sheet2.
|
|
| |
3.
|
|
|
First choose the cell you want to create a hyperlink for.
London in my case.
|
|
| |
4.
|
|
|
Right click that cell and choose Hyperlink...
|
|
| |
5.
|
|
|
In the Insert Hyperlink window, click the Place in This Document button.
There are few types of hyperlinks, you can create a link to a certain file or a document on your computer or network, link to a webpage or even create a custom one. We are going to create a link to another sheet.
|
|
| |
6.
|
|
|
Now choose the Sheet you want to create the link to.
Sheet2 in my case.
|
|
| |
7.
|
|
|
If you now go back to the Sheet where you created the hyperlink you should notice the text turned into a text link, if you now click it ...
|
|
| |
8.
|
|
|
... it should bring you to the Sheet you chose in step 6.
|
|
|
 |
|
|
|
