This tip is # 1 in a series of a Tip a Day for December 2015. Tips range from the obvious to the simple to some more complex tips. Hopefully there is something you find helpful!
Does it annoy you when Excel automatically creates hyperlinks to anything that looks like a web address? When you first hit enter on the cell after inputting the address, you can press Ctrl+z to undo the insertion of the hyperlink. However, if you’re after more than a piecemeal approach, and want Excel to stop doing it all together, here’s how you do it.
- Go to File -> Options -> Proofing
- Click the “AutoCorrect Options…” button
- Go to the “AutoFormat As You Type” tab
- Untick the top radio box: “Internet and network paths with hyperlinks”
Note, this tip also works with Word!