deleting lots of hyperlinks in Excel 2007
 

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

deleting lots of hyperlinks in Excel 2007
 

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

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

deleting lots of hyperlinks in Excel 2007
 

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" wrote:

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

deleting lots of hyperlinks in Excel 2007
 

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.

"Daniel.C" wrote:

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

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

deleting lots of hyperlinks in Excel 2007
 

Many thanks

"Lori" wrote:

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" wrote:

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

deleting lots of hyperlinks in Excel 2007
 

You sure that the hyperlink was deleted?

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

Jane wrote:

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.

"Daniel.C" wrote:

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

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




--

Dave Peterson