Try selecting the cells from which the hyperlinks are to be removed and run
this macro:

Sub hypergone()
Selection.Hyperlinks.Delete
End Sub
--
Gary's Student


"Laura" wrote:

> How do you remove hyperlinks in an Excel file? I tried getting answers from
> Help, but the instructions didn't help me. In one of the answers it said
> to right click on the hyperlink that I wanted to remove and select Remove
> Hyperlink, which I tried but there was no such option on my menu.
>
> Another answer involved typing 1 in a blank cell, then copying it, and then
> I don't know what the heck it was talking about!! It was way too complicated
> for me!
>
> Isn't there a simple way to remove hyperlinks?
>
> Thanks.
>
>