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.

Difficulty: Moderate

Instructions

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.

[firstmalone]

on 10/26/2009 You may also 1) copy a clean cell, 2) select the hyperlinked cells (for an entire column Ctrl+Space Bar), 3) Paste Special - Formats (Alt+H, V, S, t, Enter)

[itecol]

on 12/17/2008 Excellent Tips.
For Removing Hyperlinks completely from a list of entires, another easy way is select and copy all cells and then use Paste Values from the clipboard drowp down options.

[AutumnLeavz]

on 6/12/2008 Thanks for these wonderful tips!