I want to disable the auto hyperlink feature.

T

Ted

I have a spreadsheet with lots of hyperlink-like data (but that are not actually hyperlinks) that is edited frequently. It is very frustrating when excel decides to auto-format the data into a hyperlink, especially because right clicking on it and picking "remove hyperlink" also removes ALL formatting for that cell.

How can I disable the auto hyperlink feature?

(I already searched the forum and there are other messages which looked hopeful but the threads cannot be displayed)
 
D

Debra Dalgleish

You can type an apostrophe at the start of the entry, and Excel won't
create a hyperlink. For example: 'Lunch@Noon

The apostrophe won't be visible in the worksheet.
 
Top