Remove link fr a column of entries
 

I know how to remove a link from a single cell. Right click, hyperlink,
remove hyperlink.
I have a column of cells and it is very cumbersome to remove cell by cell.
Is there any way to remove all cells in one action.?
TIA, Rasoul Khoshravan

You can do this with a macro:

Sub RemoveHLinks()
Selection.Hyperlinks.Delete
End Sub

Just select the column first. If you aren't familiar with macros, look here
for some intro material:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

tj


"Rasoul Khoshravan Azar" wrote:

I know how to remove a link from a single cell. Right click, hyperlink,
remove hyperlink.
I have a column of cells and it is very cumbersome to remove cell by cell.
Is there any way to remove all cells in one action.?
TIA, Rasoul Khoshravan