Removing hyperlinks in Excel (2010 and later)

Excel will automatically add a hyperlink to, for example, an email address you have entered on a spreadsheet for reference.  Problem is, the hyperlink is never used and if accidently “rolled over” will open the default mail app to send an email.  Can be frustrating.

The solution is simple.  Click on any cell in the workbook.  Use the Ctrl + A keys to select all.  At the top and to the right side of the ribbon, find Auto Sum.  Look below to find clear and click to Remove Hyperlinks.  This will clear all hyperlinks in the worksheet.

If you need to keep any hyperlinks, then after selecting all cells, hold the Ctrl key down and click on the cell(s) that you want to keep hyper-linked.