-
Step 1
Open the Microsoft Excel 2007 workbook that has hyperlinks you want to remove.
-
Step 2
Remove Single LinkTo remove a single link, right click the cell that the link is in, and from the pop-up menu, click on Remove Hyperlink.
-
Step 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.
-
Step 4
Styles - NormalOn 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.
-
Step 5
To completely DELETE multiple hyperlinks, in any empty cell, type in the number 1 (it can be deleted later).
-
Step 6
Copy CellRight click the cell where you typed the number 1 and then click on Copy.
-
Step 7
Perform Step 3, i.e., select the cells with hyperlinks that you want to delete.
-
Step 8
Paste SpecialOn the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special.
-
Step 9
MultipleUnder Operation, click on Multiply, and then click OK.
-
Step 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.










Comments
firstmalone said
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 said
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 said
on 6/12/2008 Thanks for these wonderful tips!