Select the cell and press Ctrl + K to open Insert Hyperlink. Type or paste the web address in the Address box, change Text to display if you want friendlier wording, and press Enter. On a Mac, press Cmd + K.
In the same dialog, choose Place in This Document to jump to a sheet or cell in the workbook, Existing File or Web Page to open a file, or E-mail Address for a mail link. Pressing Ctrl + K on a cell that already has a link opens Edit Hyperlink instead.
To create links with a formula, for example from a column of URLs, use =HYPERLINK("https://excelchamps.com","ExcelChamps"). For a link to a cell in the same workbook, start the address with #: =HYPERLINK("#Sheet2!A1","Go to Sheet2").
To remove a link, right-click the cell and choose Remove Hyperlink, or select a range and use Home → Clear → Remove Hyperlinks. If Excel turns a typed web address into a link you did not want, press Ctrl + Z straight after entering it to undo the link and keep the text.
Clicking a linked cell follows the link, so to select the cell without opening it, move onto it with the arrow keys, or click and hold until the pointer changes to a cross.
Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
In Excel, sometimes users need to add a link in a cell that points to a related file, document, web address or email address, and this can be done using the hyperlink feature.
By clicking the hyperlink, users can open that linked file, document, web address or email address.
Hyperlinks are easy to recognize, as they show as underlined blue text (purple once you have clicked them).
There are multiple ways to add hyperlinks in Excel, but in this tutorial, we have explained the keyboard shortcut to add hyperlinks.
Keyboard Shortcut to Insert Hyperlink in Excel
Ctrl + K
Steps to Insert Hyperlink Using Keyboard Shortcut
- First, select the cell where you want to insert the hyperlink.
- After that, press the “Ctrl + K” keys, and you will get the “Insert Hyperlink” dialog box opened.
- Now, select the file or enter the web link in the Address field that you want to link to the selected cell, and press “Enter”.
Note: In Excel, there are multiple types of hyperlinks that you can add to the cell from the “Insert Hyperlink” dialog box, and to learn all the types, please visit “Add and Remove Hyperlinks” page.
Edit, Select and Remove a Hyperlink
- Edit: select the cell with the link and press Ctrl + K again; the same dialog opens as “Edit Hyperlink”.
- Select without opening the link: click the cell and hold the mouse button until the pointer changes, or move to the cell with the arrow keys.
- Remove: right-click the cell and choose Remove Hyperlink, or select a range and use Home ➜ Clear ➜ Remove Hyperlinks.
- Mac: the shortcut is Command + K.
Add a Hyperlink with a Formula
You can also create a link with the HYPERLINK function. It’s handy when the address is in another cell or when you build links for a whole list. The following formula links to the address in A2 and shows the text in B2:
=HYPERLINK(A2,B2)
To link to a cell in the same workbook, start the address with #, like this:
=HYPERLINK("#Sheet2!A1","Go to Sheet2")
Frequently Asked Questions
Why does Excel turn my web address into a link automatically?
AutoCorrect does that. Press Ctrl + Z right after typing to undo the link, or turn off File ➜ Options ➜ Proofing ➜ AutoCorrect Options ➜ AutoFormat As You Type ➜ Internet and network paths with hyperlinks.
Can I link to another sheet with Ctrl + K?
Yes. In the Insert Hyperlink dialog box, choose Place in This Document, pick the sheet and type the cell reference.
Why does my hyperlink to a file stop working?
The file was moved or renamed, or the link points to a path that other users can’t reach. Edit the link with Ctrl + K and point it to the new location.