I want to disable the auto hyperlink feature.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hyperlinks within Excel 3
Hyperlinks changed by Excel again! 5
Hyperlink to specific page in a pdf 1
How would I change all hyperlinks at once? 1
Adding a hyperlink to a picture in Excel 2007 3
Excel hyperlink problems 4
Hyperlinks are disabled in my excel spreadsheet 1
Removing hyperlinks in Excel by multiplying by 1 is very obtuse 2

Back
Top