How to Remove a Hyperlink in Excel 2010

Microsoft Excel 2010 is capable of adding hyperlinks to text that you have entered into cells in your worksheet. These links can either be added manually, or they can be generated automatically, depending upon the type of data that you have entered. Links can then be clicked to take you to the specified location, or to open an email window if the link was on an email address.

But hyperlinks in your spreadsheet might not always be desired, and you may find that you wish to remove one that is currently in your spreadsheet. Fortunately this can be accomplished with a few short steps by following our tutorial below.

 

How to Get Rid of a Hyperlink in Excel 2010

The steps in the guide below will remove an existing hyperlink from a cell in your Excel 2010 spreadsheet. These steps will work for a single hyperlink. Other existing hyperlinks in the spreadsheet will not be affected when you use these steps to remove your selected hyperlink.

This guide includes two versions of the steps needed to remove a link. The first section provides short, concise directions for removing the link. The second section includes more detail, as well as screenshots.

 

Quick Steps

  1. Locate the cell containing the hyperlink that you want to remove.
  2. Right-click the cell, then click the Remove Hyperlink option at the bottom of the menu.

 

Steps with Pictures

Step 1: Locate the cell that contains the hyperlink that you wish to delete.

locate the cell with the hyperlink

 

 

Step 2: Right-click the cell, then select the Remove Hyperlink option from the bottom of the shortcut menu.

right-click the cell, then click the remove hyperlink button

 

 

You can also remove a hyperlink by selecting the cell, then pressing Ctrl + K on your keyboard. This will bring up the Edit Hyperlink window. You can then click the Remove Link button at the bottom of this window. The Edit Hyperlink window is also accessible by clicking Insert at the top of the window, then clicking the Hyperlink button in the Links section of the navigational ribbon.

click remove link on the edit hyperlink window

 

 

Is Excel 2010 automatically adding a hyperlink whenever you enter a Web address or email address? learn how to stop this behavior by disabling the automatic hyperlink option.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.