When you type in a URL into a cell, Excel automatically creates a clickable hyperlink, which may not always be what you want. Some people find this behavior annoying. Luckily, you can easily disable it by changing Excel’s AutoCorrect settings.
To Stop Automatic Creation of Hyperlinks
- Click the File tab on the Ribbon.
- Click Options to display the Excel Options window.
- Click Proofing in the left pane.
- Click the AutoCorrect Options button to display the AutoCorrect dialog box.
- Click the AutoFormat As You Type tab.
- Under the Replace As You Type area, uncheck the checkbox next to Internet And Network Paths With Hyperlinks.
- Click OK.
Now if you don’t want to turn off this feature but still want the option of entering some URLs as text and not hyperlinks, enter the URL into a cell as a label. That is to say, precede the URL with an apostrophe, such as: ‘http://microsoft.com. Excel will then recognize it as text rather than a link.