bulk removal of hyperlinks

T

Tim

How can I remove any and all hyperlinks in a column of data ? The only
thing I can find is removal one cell at a time ?

Thanks, Tim
 
D

Dave Peterson

Select the range that should have the hyperlinks removed
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then back to excel to check.
 
M

MartinW

Hi Tim,

Another way is to copy an empty cell
Select your entire column
Then Edit>Paste Special,
Check Add and OK out.

Make sure the cell you copy is truly empty

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open specific hyperlink (accept) automatically in email with outlook 0
How do I remove numerous Hyperlinks all at once within a worksheet 3
Activating hyperlinks 3
Will not auto open .jpg 1
Moving Hyperlinks 2
How can I remove ALL hyperlinks in a document in Excel 2003? 2
Automatting hyperlink removal 3
Bulk removal of Hyperlinks 2

Top