Hyperlinks are great! I love to use them and I sometimes use them in Excel. Hyperlinks can be very useful in your Excel worksheet (i.e., links to data, other workbooks, documents, Websites, e-mail addresses, etc.)
Even though hyperlinks are often useful in your worksheets though, it can be downright aggravating when you enter data (i.e., site address, e-mail address) and a hyperlink is created where you did not want one.
Oh, of course, you can click the Undo command or click CTRL + Z after the hyperlink has been created, to quickly disable the hyperlink, but I see that as a waste of time and keystrokes and everyone knows I do not like that at all!
So, if you are like me, you do not want those hyperlinks created in your worksheets automatically.
Follow the steps below to learn how to prevent this:
- On the File tab of your Ribbon, click Options | Proofing | AutoCorrect Options.
- On the AutoFormat As You Type tab, deselect Internet and network paths with hyperlinks option.
- Click OK.
The only caveat to this is that the steps above will disable the automatic creation of hyperlinks for ALL workbooks, which means that Excel will not create hyperlinks for you automatically any longer.
If you only need hyperlinks some of the time you can still have them but not automatically:
- On the Insert tab of your Ribbon, click Hyperlink or click CTRL + K.