Software

Ask something
Discussion Locked

how do I delete hyperlinks in excel

0 helpful
6 replies

by rfidgeon 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have seen where there are ways of deleting multiple hyperlinks in a Word document using Ctrl-A and Ctrl-Shift-F9 but this doesn't seem to work in Excel. Any hints?

6 replies

by dklippert

Right click
Choose Hyperlink> Remove Hyperlink

Ctrl+K, Alt+R

or if you have a "Windows" keyboard hit the key on the right side of the board next to the Ctrl key + H + R

by rfidgeon

the right-click>remove hyperlink works on one at a time. But I have a couple of spreadsheets with literally hundreds of links I want to remove, hopefully at once. None of the other hints seemed to work. Ctrl-k brought up "insert hyperlink", alt-r merely copied the first cell with link, into any other cells selected. Ctrl+h+r brings up a find and replace box, doesn't work. I have a "windows" keyboard and am working on Office2000 on Win2k Pro. ???

by dklippert

Select all of the Hyperlinks. Right click the selection. Choose Hyperlink. In the lower left corner of the Edit Hyperlink box you'll see the Remove Link button.
Ctrl+K brings up the same dialog box. With the box still open you can either click the Remove link button or use the accelerator key Alt+r.

by dklippert

If you want a macro try:

Sub RemoveHyperlinks()
Cells.Hyperlinks.Delete
End Sub

The link will be removed leaving text.

by rfidgeon

Thanks for the help. The macro worked fine, but for some reason I am not getting the "edit hyperlink" window using the other hints. I can only get the "insert hyperlink" window unless I only select one link at a time. It may just be the setup of Office and Win2k I am using at work. Anyway, thanks again, it definitely saved me a lot of time.

This discussion is closed to new replies.