deleting lots of hyperlinks in Excel 2007

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
having to do each one manually. Does anyone know a short cut that will
delete them all in a few key strokes? Many thanks in anticipation
 
Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel
 
Click Edit-Find and in the options choose the format from a cell with a
hyperlink, click find All, select all cells by pressing ctrl+A then press
delete.
 
Thanks for your prompt reply. I found by selecting a cell without a
hyperlink then using the FORMAT PAINTER and highlighting the column, it
removed all the hyperlinks.
 
Many thanks

Lori said:
Click Edit-Find and in the options choose the format from a cell with a
hyperlink, click find All, select all cells by pressing ctrl+A then press
delete.
Click to expand...
 
You sure that the hyperlink was deleted?

Or was the cell formatted so it look like the hyperlink was deleted?
 

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

Hyperlinks in Excel 2007 1
Adding a hyperlink to a picture in Excel 2007 3
Activating hyperlinks 3
ADRMS Breaks Excel Hyperlinks (when read only) 1
Open specific hyperlink (accept) automatically in email with outlook 0
Deactivate email hyperlinks in Excel 2007 3
Change hyperlink throughout excel 1
Moving hyperlinks from 2003 to 2007 1

Back
Top