Hyperlinks

Hyperlink in Excel | Insert Hyperlink | Hyperlink Shortcut

HYPERLINK Using Hyperlink, we can give links to other sheets within the workbook. if you click on a particular Hyperlink which brings you to the reference sheet. in other words, if you click on image, word, which is assigned with a Hyperlink, it jumps to a given section or sheet. The Hyperlink itself can be text or a picture.

Use Insert Hyperlink dialog box in Excel to create a hyperlink to an existing file or web page or place in this document.

How to Create Hyperlink in Excel?

1. Select a cell where you want to create a hyperlink.

2. Rightclick on that cell and click on hyperlink then you will get a below dialog box with three options.

3. if you want to give a link to any website click on the "Web Page or File" tab.

4. Provide a website address in the address box and click OK.

5. Now that cell text color changed to blue. which means hyperlink applied to that cell text. if somebody clicks on that cell it jumps into the given web URL.

6. In the same way, if you want to give hyperlink within the document select "This Document" tab.

7. And select Cell Reference or Defined names from dialog box then click OK.

8. In this case I have selected Sheet3. So, if I click on hyperlink it jumps to sheet3 in the same workbook.

Shortcut to Add Hyperlink in Excel

For Windows: CTRL+K

For Mac: COMMAND+K

After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.