5 Awesome Ways to Insert Hyperlinks in Excel

In this tutorial, we will demonstrate how to insert hyperlinks in Excel in five easy ways.

Step-By-Step Guide in Inserting Hyperlinks in Excel

1. Hyperlink to an Existing File

  1. Select the cell that you want to add the hyperlink to.
  2. Go to INSERT and click the LINK option.
  3. Once a pop-up window appears, select the file that you want to link
  4. Press OK.

2. Hyperlink to Existing Web Page

  1. Select the cell that you want to add the hyperlink to.
  2. Go to INSERT and click the LINK option.
  3. Once a pop-up window appears, type in the URL for the page you want to link to
  4. Press OK.

3. Hyperlink in a Place in the Document

  1. Select the cell that you want to add the hyperlink to.
  2. Go to INSERT and click the LINK option.
  3. In the pop-up window, select the PLACE IN THIS DOCUMENT option
  4. Type the cell reference of the cell that you want to link in.
  5. Click OK.

Example

In order to add a hyperlink from “F2” to “A2,” click the cell F2 and go to INSERT, then select LINK. Click PLACE IN THIS DOCUMENT and type A2 in the TYPE THE CELL REFERENCE area.

4. Inserting Email Hyperlink

  1. Select the cell that you want to add the hyperlink to.
  2. Go to INSERT and click the LINK option.
  3. In the pop-up window, select the E-MAIL ADDRESS
  4. Type the email address and you have the option to add a subject.
  5. Press OK.

5. Hyperlink Function to Interlink in Excel

  1. Select the cell that you want to add the hyperlink to.
  2. Type =Hyperlink in the cell
  3. Browse the worksheet that you want to link and click any cell from that worksheet
  4. Add a comma ‘,’ and put a “friendly name” (an ‘on-screen’ name of the hyperlink, for example, “Click Here”).
  5. Click ENTER.
  6. An error message is normal because the default value is a website. To link an existing worksheet inside the workbook, add a hash operator (#) to the formula, and quotation marks (“) before the hash and after the cell number.
  7. Press ENTER, click on the hyperlink and it should direct you to the worksheet.

Examples

Link data from multiple worksheets or tabs. Using the examples above, all you have to do is remove the existing hyperlink location and replace it with a double quote and add the ampersand (&) symbol. Click the previous hyperlink location present in the cell, add another ampersand, and double quote. Press the ENTER key.

From this:

It should look like this:

Once the hyperlink is working, drag the cell down to get multiple worksheet links.

Conclusion

Excel is an invaluable resource for students and other users, providing a convenient way to store, organize, and analyze data. By inserting hyperlinks into worksheets, users can quickly access information that might otherwise be difficult to find, making studying and work-related tasks easier and more efficient.