How to easily remove hyperlinks from multiple cells?
An option would be to let a VBA Macro do the donkey work.
Press Alt-F11, double-click This Workbook
, then copy this code into the resulting window (essentially only one line of code!):
Sub RemoveHyper()
Selection.Hyperlinks.Delete
End Sub
Press Alt-F11 to go back to your spreadsheet, select all the cells with hyperlinks, then do Alt, T, M, M (or Alt-F8) and select the RemoveHyper Macro, then select Run.
When you're done, if you want to remove the Macro, either save the file as .xlsx, or press Alt-F11 and remove the code.
Follow these steps:
- In any empty cell, type in the number
1
(it can be deleted later). - Right click the cell where you typed the number
1
and then click onCopy
. - Select the cells with hyperlinks that you want to delete.
- On the
Home
tab, in theClipboard
group, click the down arrow and then click onPaste Special
. - Under
Operation
, click onMultiply
, and then clickOK
. - On the
Home
tab, in theStyles
group, click onCell Styles
. From the drop down menu, click onNormal
. - Now the hyperlinks are deleted. You can now delete the number
1
used to perform this task.
Select all cells you want to clear from hyperlinks, then click the "Home" tab in the ribbon at the top of Excel. In the "Editing" group, click on the "Clear" pull-down arrow and select "Clear Formats".
UPDATE:
Select all cells you want to clear from hyperlinks, right click and "Cut" or use Ctrl+X. Now open up a notepad window and paste it there. Now select all the lines with content from notepad and right click "Cut" or use Ctrl+X. Now select the top cell of the just cut column in Excel and right click "Paste" or use Ctrl+V.