How do I remove numerous Hyperlinks all at once within a worksheet

C

Cheryl J

I have a worksheet that has numerous hyperlinks attached to many of the
cells. I would like to remove all Hyperlinks associated with this worksheet.
Is there a way to do this without doing one cell at a time? I have many
hundreds.
 
D

Dave Peterson

Select the range to remove the hyperlinks from (all the cells on the worksheet
if you want)

Then hit alt-f11 to get to the VBE
hit ctrl-g
type this:
selection.hyperlinks.delete
and hit enter

Then back to excel to check.
 
S

Shane Devenshire

Hi,

No VBA necessary -
1. Select an empty cell and press Ctrl+C (copy)
2. Select all the hyperlinks and choose Edit, Paste Special, Add
 
T

TK

Hi,

select any other cell(non-hyperlink), click Format Painter on Home ->
Clipboard and select all the hyperlink cells.

Check the excel sheet.

-TK
 

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

Top