Welcome toExcel2007.Tips.Net
Helpful Links
Excel2007 Tips
Gardening Tips
Pest Tips
Pet Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
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:
Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change. Check out Word 2007 Styles and Templates today!