Add and Remove Hyperlinks in Excel

HomeExcel BasicsAdd and Remove Hyperlinks in Excel

A hyperlink in Excel is a link to a specific file, document, location, web, and email address. By using the hyperlink users can go to a specific file, document, or location.

By adding a web or email address to the hyperlink, users can navigate to an internet web page or can send an email to a specified email address just by clicking on that link.

Hyperlinks are easy to recognize as these are underlined blue or purple-colored highlighted text.

We have mentioned some quick and easy steps for you to add and remove hyperlinks in Excel.

Add Hyperlink to an Existing Workbook

Adding hyperlinks in Excel is very easy and quick. Users can add hyperlinks manually to Excel.

Excel also automatically creates a hyperlink when users enter any web address or email address in a cell.

  1.  First, go to the “Insert” tab and then click on the “Link” icon under the “Link” group.
    1-insert-tab
  2. Or, right click on the cell, where you want to add the hyperlink, and then click on the “Link” option from the pop-up menu.
    2-link-option-for-hyperlink
  3. Or, press the CTRL + K shortcut from the keyboard.
  4. Once you follow any of the above steps, you will get the “Insert Hyperlink” window opened.
  5. After that, select the “Existing File or Web Page” option and then select the location where that file or document is placed.
  6. Now, select the file or document and then enter the text in the “Text to display” column which you want to display as a hyperlinked name, and click OK.
    3-insert-hyperlink-window

Add Hyperlink to a Specific Sheet of an Existing Workbook

  1. First, select the “Existing File or Web Page” option and then select the location where that file or document is placed
  2. After that, select the file or document and then click on the “Bookmark” button.
    4-add-hyperlink-to-a-specific-sheet
  3. Now, select the specific sheet and the targeted cell of that existing sheet and click OK.
    5-select-the-targeted-cell

Add Hyperlink to a Specific Sheet of the Current Workbook

  • First, select the “Place in This Document” option and you will get all the sheets of the current workbook
  • After that, select the specific sheet and the targeted cell and click OK.
hyperlink-to-current-workbook

Add Hyperlink to a Web Address

  • First, open the web page in the browser and copy the web address and paste it into the “Address” column in the “Insert Hyperlink” window.
  •  After that, enter the text in the “Text to display” column that you want to display as a hyperlinked name, and then click OK.
hyperlink-to-a-web-address

Add Hyperlink to Open a New Workbook

  • First, select the “Create New Document” option and enter the name of the new workbook in the “Name of new document” column.
  • After that, enter the text in the “Text to display” column that you want to display as a hyperlinked name.
  •  Now, click on the change button if want to change the saving location of the new workbook and click OK.
open-a-new-workbook

Add Hyperlink to an Email Address

  • First, select the “E-mail Address” option and then enter the email id in the “E-mail address:” column and enter the email subject in the “Subject” column.
  • After that, enter the text in “Text to display” which you want to display as a hyperlinked name, and click OK.
  • You can even directly enter the email address in the cell and Excel will auto-create the hyperlink to that email.
hyperlink-to-an-email-address

Remove Hyperlinks in Excel

Removing hyperlinks from Excel is way easy and quick than adding or creating the hyperlinks. Excel allows users to remove the hyperlinks just in two clicks as mentioned below.

  1. To remove a hyperlink from a cell, right click on a cell containing a hyperlink and then click on “Remove Hyperlink” from the pop-up menu.
    10-remove-hyperlink
  2. To remove hyperlinks from multiple cells, select the cells together and right click and select “Remove Hyperlinks” from the pop-up menu.
    11-remove-multiple-hyperlinks
  3. To remove the hyperlinks, form the current worksheet, select the whole worksheet by pressing CTRL+A from the keyboard.
  4. Now, go to the “Home” tab and click on the “Clear” icon drop-down arrow and then select “Remove Hyperlinks”.
    12-remove-hyperlinks-using-clear