Deleting a Hyperlink

There's also the Clear commands in the Editing section of the Home tab. One of the options is Clear Hyperlinks along with Clear Contents, Clear All, etc. For instance, you can use Clear Hyperlinks followed by Clear Formats if you want to get rid of the hyperlink along with the hyperlink formatting.

Sorry should have mentioned, I'm using Excel 2013;

Is there a way to either remove the ability for Excel to 'automatically' create a hyperlink when the '@' symbol is used? If not, is there a way to removed the hyperlink while keeping the font formats in the given cell - for several cells at once?

Is there a way to either remove the ability for Excel to 'automatically' create a hyperlink when the '@' symbol is used? If not, is there a way to removed the hyperlink while keeping the font formats in the given cell - for several cells at once?

Richard,

Check out this tip of Allen's:
http://excel.tips.net/T002373_Removing_Hyperlinks_without_a_Macro.html

Thanks, but that will delete everything. I only want to delete the hyperlink value itself, not the underlying data.

You can also delete cells containing hyperlinks by dragging an adjacent blank cell over it. If there is one. You do not get the "do you want to replace" message that way.
If the cell with the hyperlink contains a comment that has to be deleted separately.

Thanks Steve, but I don't have that option in Excel 2007. I only have that option on a line-by-line basis when there is a hyperlink on the line.

Similar issue. How do you remove all image placeholders / tags from a worksheet and leave the cell data and formatting undisturbed?

MidJack,
Select the whole column by clicking on the column letter, right click, remove hyperlinks.

So how do you easily remove hyperlinks in an entire column containing both hyperlinked and non-hyperlinked data?

Is there a way easier than Coping the entire column; then Paste Special-Values to another location; then do a Cut Paste back to the original location?