Add and Remove Hyperlinks in Excel

puneet-gogia-excel-champs

- Written by Puneet

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.

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.
    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.
    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.
    insert-hyperlink-window
  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.
    add-hyperlink-to-a-specific-sheet
  3. Now, select the specific sheet and the targeted cell of that existing sheet and click OK.
    select-the-targeted-cell
  1. First, select the “Place in This Document” option and you will get all the sheets of the current workbook
  2. After that, select the specific sheet and the targeted cell and click OK.
hyperlink-to-current-workbook
  1. 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.
  2.  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
  1. First, select the “Create New Document” option and enter the name of the new workbook in the “Name of new document” column.
  2. After that, enter the text in the “Text to display” column that you want to display as a hyperlinked name.
  3.  Now, click on the change button if want to change the saving location of the new workbook and click OK.
open-a-new-workbook
  1. 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.
  2. After that, enter the text in “Text to display” which you want to display as a hyperlinked name, and click OK.
  3. 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

Removing hyperlinks from Excel is way easy and quick than adding or creating 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.
    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.
    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”.
    remove-hyperlinks-using-clear
Last Updated: October 29, 2023

Leave a Comment