Create Hyperlink in Excel: Complete Guide

This updated guide explains how to Create Hyperlink in Excel through clear steps, practical examples, and important checks that help prevent common errors.

this guide guides you to create hyperlink links to websites, to other sheets in the same Excel file, links to newly created Excel files and links to email addresses.

Step 1: You select the cell you may need to insert hyperlinks, then right-click and select Hyperlink (or choose Insert -> Hyperlink , or Ctrl + K ).

Create Hyperlink in Excel example screenshot 1

Step 2: In Insert Hyperlink , you can insert the path for the following purposes:

- Create hyperlinks to a website.

- Create hyperlinks to one of the sheets in the file.

- Create hyperlinks to a newly created Excel file.

- Create hyperlinks to email addresses.

1. Create Hyperlinks to a Website.

In Insert Hyperlink, select Existing File or Web Page . Here you enter the website address at the Address , enter the content to display the hyperlink in Text to display . Click ScreenTip to enter the content displayed when you hover over the hyperlink display content.

Create Hyperlink in Excel � 1. Create Hyperlinks to a Website. screenshot 2

Then click OK , the link will be created.

Create Hyperlink in Excel � 1. Create Hyperlinks to a Website. screenshot 3

You just need to click the mouse pointer on the link to access the website.

2. Create Hyperlinks to a Sheet in Excel.

In Insert Hyperlink, select Place in This Document .

To link to a certain sheet in the Excel file, select the sheet name in the Or select a place in this document section and enter the content into Text to display or ScreenTip . Then you click OK .

Create Hyperlink in Excel � 2. Create Hyperlinks to a Sheet in Excel. screenshot 4

After creating the link, you just need to click the hyperlink immediately cursor will move to the sheet of your choice.

3. Create Hyperlinks to a Newly Created Excel File.

In Insert Hyperlink, select Create New Document .

You click Change and select the path for the new Excel file to create, enter the name for the file to create in the Name of new document . In addition, you also enter the content into Text to display and ScreenTip if desired.

Create Hyperlink in Excel � 3. Create Hyperlinks to a Newly Created Excel File. screenshot 5

Then you click OK , the newly created Excel file will show you off or manipulate if desired. The next time you may need to open the newly created file you just need to click the hyperlink that you have linked. A notice appears and select Yes so the newly created Excel file will display.

Create Hyperlink in Excel � 3. Create Hyperlinks to a Newly Created Excel File. screenshot 6

4. Create Hyperlinks to Email Addresses.

In Insert Hyperlink you choose E-mail Address . Then enter the email address to send in the E-mail address , and enter the subject text in the Subject section. Finally click OK .

Create Hyperlink in Excel � 4. Create Hyperlinks to Email Addresses. screenshot 7

So you know how to create hyperlinks in Excel, depending on the purpose of use, you create links that are suitable for the content.

FAQ

What is the easiest way to Create Hyperlink in Excel?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.