Welcome toExcel2007.Tips.Net
Helpful Links
Car Tips
Money Tips
School Tips
WordTips (ribbon) Tips
Newest Tips
Controlling How Excel Adjusts Capital Letters
Numbers Mysteriously Divided by 100
Displaying Comment Boxes where You Want Them
Turning the Formula Bar On and Off
Subscribe
Controlling Hyperlink Activation
Summary: Does it bother you when you enter a URL and it becomes "active" as soon as you press Enter? Here's how you can turn off this activation so that your URLs remain as regular text.When you enter a Web address or a LAN server address of a file into an Excel cell, it automatically converts to a hyperlink when you leave the cell. This is part of the "Web-aware behavior" of Excel, but it may be bothersome—particularly if you are working with large lists of URLs.
If you want to turn off the automatic conversion, you can follow these steps:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click Proofing at the left of the dialog box.
- Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box.
- Make sure the AutoFormat As You Type tab is selected. (Click here to see a related figure.)
- Clear the Internet and Network Paths With Hyperlinks check box.
- Click OK.
Related Tips:
Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!