bulk removal of hyperlinks

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

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

Activating hyperlinks 3
removing more than one hyperlink 2
Open specific hyperlink (accept) automatically in email with outlook 0
How do I remove numerous Hyperlinks all at once within a worksheet 3
Hyperlinks 1
Excel Macro to hyperlink an archived worksheet to an index page 0
How to remove so many hyperlink in a single click? 4
Removing hyperlinks in bulk 8

Back
Top