Remove hyperlink in excell 2003

P

patti

HI
I know that their is an EASY way to remove hyperlinks....
I have a whole bunch of emails on a spreadsheet... how without doing like
macos and stuff how do I remove the links????
 
D

Dave Peterson

Kinda VBAish...

select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete
 
P

patti

Dave,
I could have sworn that I thought I could right click & remove the links
that way??
 
D

Dave Peterson

Go back to Excel and you'll see that you removed all the hyperlinks that were in
that selected area.

And you can rightclick and remove the hyperlink from the cell--but it's one cell
at a time.
 
P

patti

actually I found it...
highlight the area
click on edit
click clear and formats...
and the hyperlinks are gone..

thanks :)
 
D

Dave Peterson

Did you try clicking on that cell?

If there was a hyperlink in that cell to start, I think it's still there--but
the format has been changed (not blue underlined), but the link is still there.

If there was no hyperlink to start, then there still won't be one <bg>.
actually I found it...
highlight the area
click on edit
click clear and formats...
and the hyperlinks are gone..

thanks :)
Click to expand...
 
Top