How to give a link in Microsoft excel?

Asked By John Anderton 0 points N/A Posted on - 08/04/2012

I have seen in some excel presentations when a particular word is clicked it goes to another sheet quickly. That means a link has been given to the word to go that sheet.

How can I give a link to another sheet in excel? Can anybody explain me?

• Status: Open
• Question Views: 1158
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #135800

How to give a link in Microsoft excel?

When I read your question I understood that you are talking about “Hyperlink” option which is available in Microsoft excel. I will explain to you how we can add a Hyperlink to a particular word.

In the following example we will assume that we want to give a Hyperlink to the word “Date”. That means when you click on the word it should go to a particular cell in another sheet. We will think it should go to cell C3 in sheet 2.

Go to the Cell A1 (Date), right click and click on the Hyperlink.

In the next window, click on the “place in this document”, click “Sheet2” under cell reference and type “C3” in “the type the cell reference” box.

Now click OK and click on the cell A1 (Date). It will go to the cell C3 in sheet2.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: MS Excel

Answered By Fosso pradha 0 points N/A #135801

How to give a link in Microsoft excel?

Dear User,

What you describe here is a hyperlink. I will give you some simple steps of how to create a hyperlink.

1. Select the cell you want to make the hyperlink into,

2. Type something (description of the page the link is provided for).

3. And right click it. When you do you can select Hyperlink from the list.

4. And simply click the file button and browse to your file and select the location of the file and click ok.

Thank you.

About Fosso pradha

Questions
1

Answers
247

Best Answers
85

• Vote Up 0 Vote Down

• Posted on - 08/06/2012
• Question Category: MS Excel