Don’t forget to share this post

Excel spreadsheets can be used to organize data and structure it in a specific way for professional reporting. When you work with large datasets that span across many tabs, linking the data can be a great way to save time in your analysis. Moreover, you may want to link a specific cell or a full range to an external source, such as a website or another spreadsheet stored online.

In Excel, users can include hyperlinks to create direct links between sheets or cells. If you want to know more about a specific cell or piece of information, you can click on it, and it will take you to the reference cell, sheet, or online source. Creating a hyperlink in Excel can be achieved by using the built-in command or the HYPERLINK function.

In this article, you’ll learn how to insert a hyperlink in Excel to create clickable links that will take you to another cell, sheet, or website. You’ll also learn how to remove them in a few simple steps.

In How to Reference Another Sheet or Workbook in Excel, we offer multiple ways to pull data from another cell, a range of cells, or another sheet by establishing a reference. Similar to this, creating a hyperlink allows you to link data contained in a cell or a range of cells in another sheet located in the same workbook.

  1. 1. Select the cell where you want the hyperlink to be inserted. Here, I’ve selected the cell containing “PERSONNEL % OF TOTAL SALES”. Here, I will link to another sheet in my workbook containing further information.
How to Insert a Hyperlink in Excel Select cell
How to Insert a Hyperlink in Excel - Select cell
  1. 2. Go to Insert > Hyperlink. An alternative way is to right-click and select “Hyperlink” from the drop-down menu, or simply use the Ctrl/Cmd + K keyboard shortcut.
How to Insert a Hyperlink in Excel Insert hyperlink
How to Insert a Hyperlink in Excel - Insert hyperlink
  1. 3. As you can see in the prompted window, you can link to a “Web Page or File”, “This Document”, or “Email Address”. In this case, we’ll select “This Document” to link to another sheet in this same workbook.
How to Insert a Hyperlink in Excel This Document
How to Insert a Hyperlink in Excel - This Document
  1. 4. To link to another sheet, go to “Or select a place in this document” option and click on the desired sheet. Click “OK”.
How to Insert a Hyperlink in Excel Click OK
How to Insert a Hyperlink in Excel - Click OK
  1. 5. As you can see below, the select cell is now clickable and formatted as a hyperlink.
How to Insert a Hyperlink in Excel Hyperlink result
How to Insert a Hyperlink in Excel - Hyperlink result

This is a great way to make your spreadsheet more interactive - by clicking on the hyperlinked cell, you will arrive at the related sheet automatically. Let’s now see how you can link to another cell within the same sheet.

How to Reference Another Sheet or Workbook in Excel
How to Reference Another Sheet or Workbook in Excel?

Sometimes you have to reference or merge data from multiple sheets or spreadsheets. Here's how to reference another sheet or workbook in Excel.

READ MORE

Inserting a hyperlink in Excel to link to another cell can be very useful in case your data spreads across many rows and columns. To avoid scrolling through all this data, you can insert a hyperlink in the following way.

  1. 1. Select the cell where you want the hyperlink to be inserted. This time, I’ve selected the cell “Personnel Total $(000)” to link to the total amount, which is shown to the far right in column Q.
How to Insert a Hyperlink in Excel Select cell 2
How to Insert a Hyperlink in Excel - Select cell
  1. 2. Go to Insert > Hyperlink or use any of the shortcut alternatives provided earlier. The same window as before is prompted. In this case, select the same sheet under the “Or select a place in this document” option type in the cell reference you want to link to. Here, I have typed in “Q8” as it’s the cell containing the related information, “316.95”.
How to Insert a Hyperlink in Excel Cell reference in This Document
How to Insert a Hyperlink in Excel - Cell reference in This Document
  1. 3. Click “OK” to create the hyperlink.
How to Insert a Hyperlink in Excel Click OK 2
How to Insert a Hyperlink in Excel - Click OK

This is a great way to save time when analyzing or reviewing large datasets. So far, you’ve seen how to insert a hyperlink using the built-in command feature, let’s see how you can insert links using the HYPERLINK function in Excel.

An alternative way to create hyperlinks in Excel is through the HYPERLINK function, which converts the selected data into a hyperlink format. This Excel formula allows you to build links to other workbooks, websites, or other files stored in servers. Let’s start by using the HYPERLINK formula to link to another worksheet.

  1. 1. Select the cell where you want to insert the HYPERLINK formula. Note that you will need to enter the formula in the cell, so remember the text that will be replaced with the formula. Here, I want the cell “PERSONNEL % OF TOTAL SALES” to link to another sheet name, “PERSONNEL”, containing further information.
How to Insert a Hyperlink in Excel Select cell
How to Insert a Hyperlink in Excel - Select cell
  1. 2. Type in the equal sign and type HYPERLINK. Excel will prompt you with the correct formula.
How to Insert a Hyperlink in Excel Type formula
How to Insert a Hyperlink in Excel - Type formula
  1. 3. Click on the “link_location” parameter and then on any cell in the sheet you want to link to. It automatically includes the sheet reference in the formula. Here, “PERSONNEL!A1” has been included to refer to the sheet “PERSONNEL” I will link to.
How to Insert a Hyperlink in Excel Select formula parameters
How to Insert a Hyperlink in Excel - Select formula parameters
  1. 4. For “[friendly_name]” include the text you want the cell to show. Here, I will include the original text “PERSONNEL % OF TOTAL SALES”. Then, press “Enter”.
How to Insert a Hyperlink in Excel Hyperlink with other text
How to Insert a Hyperlink in Excel - Hyperlink with other text

Transfer Data From One Excel Worksheet to Another Automatically

Excel worksheets or workbooks can be linked to automatically update data. Here's how to transfer data from one Excel worksheet to another automatically

READ MORE
Transfer Data From One Excel Worksheet to Another Automatically

The steps to hyperlink to another cell using the HYPERLINK formula are almost identical to linking between sheets, the only difference is that the “link_location” will include the cell reference. Here, I have used “Q8” following the same example shown before and included “Personnel Total $(000)” for the “friendly_name” parameter.

How to Insert a Hyperlink in Excel Hyperlink to another cell
How to Insert a Hyperlink in Excel - Hyperlink to another cell

Now that you know various methods to make a hyperlink in Excel between sheets and to another cell, let’s see how you can remove it.

In case data is removed or you no longer wish to link specific data, here are the steps to remove hyperlinks in Excel.

  1. 1. Select the hyperlinked cell(s) you want to remove and right-click on them. Click on “Remove hyperlink”.
How to Insert a Hyperlink in Excel Remove hyperlink
How to Insert a Hyperlink in Excel - Remove hyperlink
  1. 2. Another quick option is to go to Home > Clear > Clear Formats or Home > Clear > Remove Hyperlinks.
How to Insert a Hyperlink in Excel Clear hyperlink format
How to Insert a Hyperlink in Excel - Clear hyperlink format

Both methods are applicable to removing single hyperlinks; however, if you create multiple hyperlinks in an Excel spreadsheet all at once, then the best way to remove them is to use a macro code. This will delete all hyperlinks and leave them as unformatted text.

How to manage Excel data with Layer?

Layer is a collaboration platform for spreadsheets that works on top of your existing Excel files and Google Sheets. Share parts of your spreadsheet, collect and consolidate data, and review changes to make collaboration seamless and more efficient while keeping full control over your data. Using Layer, you can:

  • Manage Access: Give spreadsheet access on a tab or cell level to relevant stakeholders.
  • Collaborate: Automate tasks, set deadlines, and communicate on top of your files.
  • Review & Track: Consolidate input, track changes, and restore previous versions.

Sign up to get started with Layer right now or schedule an onboarding call so we can help you set up and share your spreadsheet flows.

Conclusion

Hyperlinks are a super easy method to reference specific cells, sheets or files in large datasets. As they are links, your data can remain dynamic, and the rest of your spreadsheet will not be affected by any changes. This is particularly great in circumstances where you need to constantly change or update your data, or if you work on the same Excel file with multiple users.

In this article, you have learned how to create a hyperlink in Excel using the built-in command and the HYPERLINK function. Both allow you to create clickable data that will take you directly to another cell, sheet, or website. This is a great way to make your datasets more interactive and visual for users.

If you want to learn more about creating references to other data in Excel, read our blog article on How to Reference Another Sheet or Workbook in Excel. If you prefer working with Google Sheets, you will find Linking Google Sheets: How to Reference Another Sheet more useful.

Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Mar 30 2022, Updated May 30 2022