Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to add a link to another sheet in Excel 2010
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

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.

 
  Author: mat | Version: 2010 | 7th September 2012 |  
 
 
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.

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO