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 on 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 is 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.
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.
- Locate the cell containing the hyperlink that you want to remove.
- 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.
Step 2: Right-click the cell, then select the Remove Hyperlink option from the bottom of the shortcut menu.
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.
Now that you know how to remove hyperlinks in Excel 2010, you can use these steps to remove clickable links that you don’t want in your spreadsheets.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.