Stop Automatic Creation of Hyperlinks in Excel
Posted by Roger Hyttinen on
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.
Here’s how:
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.
Looking for more Excel tips? Check out our new Excel guide "Excel 2016: Up To Speed" - available as an ebook on Amazon, Kobo, and Apple iBooks