deleting lots of hyperlinks in Excel 2007

[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

 

[Daniel.C]

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

 

[Lori]

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.

 

[Jane]

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.

 

[Jane]

Many thanks

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.

 

[Dave Peterson]

You sure that the hyperlink was deleted?

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