Need to delete all hyperlinks on Excel document
 

I have a column within which every cell is a hyperlink and want to undo them
all at once

Need to delete all hyperlinks on Excel document
 

Select all, then edit / Copy and Edit / Paste Special values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"WDTAHTM" wrote in message
...
I have a column within which every cell is a hyperlink and want to undo
them
all at once