How to Remove Hyperlinks in Microsoft Excel 2007

There are advantages to using hyperlinks in Excel worksheets; however, there are times when you may prefer that the links not not display or not function at all. With Microsoft Excel 2007, removing hyperlinks from view is super easy.

Instructions

Difficulty: Moderate

1. Open the Microsoft Excel 2007 workbook that has hyperlinks you want to remove.
2. Remove Single Link To remove a single link, right click the cell that the link is in, and from the pop-up menu, click on Remove Hyperlink.
3. If you need to remove multiple hyperlinks, select them. If the links are scattered through the worksheet, you can select the cells by holding down on the CTRL key as you click each cell to highlight it.
4. Styles - Normal On the Home tab, in the Styles group, click on Cell Styles. From the drop down menu, click on Normal. The hyperlinks no longer displays, so it is REMOVED FROM VIEW. However, hovering your mouse over the text, you will see that the link is still functional. See Step 5 to learn how to completely delete hyperlinks from cells.
5. To completely DELETE multiple hyperlinks, in any empty cell, type in the number 1 (it can be deleted later).
6. Copy Cell Right click the cell where you typed the number 1 and then click on Copy.
7. Perform Step 3, i.e., select the cells with hyperlinks that you want to delete.
8. Paste Special On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special.
9. Multiple Under Operation, click on Multiply, and then click OK.
10. Lastly, perform Step 4 to apply the Normal Cell Style. The hyperlinks are deleted. You can now delete the number 1 used to perform this task.