excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Car Tips
Money Tips
School Tips
WordTips (ribbon) Tips

Newest Tips

Controlling How Excel Adjusts Capital Letters

Numbers Mysteriously Divided by 100

Counting Unique Names

Copying Filtering Results

Centering Your Worksheet Data

Displaying Comment Boxes where You Want Them

Turning the Formula Bar On and Off

 

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:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Click Proofing at the left of the dialog box.
  3. Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box.
  4. Make sure the AutoFormat As You Type tab is selected. (Click here to see a related figure.)
  5. Clear the Internet and Network Paths With Hyperlinks check box.
  6. 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!