How to insert a hyperlink in Microsoft Excel
In Microsoft Excel, there are times when links are required. Some users need a link to an external website, while others may need a link to a location in the same worksheet or to another worksheet. Links can be useful for directing others who look at the spreadsheet to a specific website or adding a bibliography to a school assignment. Adding this type of link, called a hyperlink, can be done by following the steps below.
Inserting a hyperlink
- Open Microsoft Excel.
- Type the appropriate data in the Excel spreadsheet.
- With your mouse or keyboard, select the cell containing the data you want to turn into a hyperlink. For example, in the picture below, the cell containing the text "ComputerHope.com" is highlighted.
- In the menu bar or Ribbon at the top of the Excel program window, click the Insert tab.
- On the Insert tab, in the Links section, click the Hyperlink or Link option.
You can also press the keyboard shortcut Ctrl+K to insert a hyperlink on any data in the selected cell.
- In the Insert Hyperlink window, type in the web page address you want to set the data in the selected cell to link to in the Address text field, then click OK.
As you can see in the image below, the text in the selected cell is now a hyperlink, set to the desired web page.
To set the data in the selected cell to link to a location in the same or another worksheet, click the Place in This Document option on the left side. You can then select the worksheet and cell to link the data to in the selected cell. It should be noted that you may only create these types of links if the worksheets are part of the same file.
- See our hyperlink and insert definitions for further information.
- Microsoft Excel help and support.
- How to insert a hyperlink in Microsoft Word.
- How to insert a hyperlink in Microsoft PowerPoint.