Microsoft KB Archive/291357

Knowledge Base

How to use the AutoCorrect Options buttons in Excel

Article ID: 291357

Article Last Modified on 1/31/2007

---

APPLIES TO

• Microsoft Office Excel 2007
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition

---

This article was previously published under Q291357

IN THIS TASK

SUMMARY

• How to Use AutoCorrect Options
• How to Understand AutoCorrect Hyperlink Functionality

REFERENCES

SUMMARY

With the AutoCorrect Hyperlinks button in Microsoft Excel, you can use several options that are related to the process of typing hyperlinks in a cell. Unlike the other recovery options, the AutoCorrect Hyperlinks button always appears below the lower-left corner of the cell where you type the address.

back to the top

How to Use AutoCorrect Options

When you click the AutoCorrect Hyperlinks button, three menu options become available:

Undo HyperlinkStop Automatically Creating HyperlinksControl AutoCorrect Options

When you type a Web address into a worksheet cell, the default AutoCorrect action is to convert the text of the Web address to a hyperlink that points to the address. The Undo Hyperlink command converts the hyperlink back to text. If you click this command in error, the menu provides a Redo Hyperlink command that allows you to convert the text back to a hyperlink.

When you click the Stop Automatically Creating Hyperlinks command, the hyperlink that provided the AutoCorrect Hyperlinks button is converted to text, and the Replace as you type option to replace Internet and network paths with hyperlinks is not selected. As a result, all subsequent Web addresses typed in Excel remain as text, program-wide. To force Excel to replace Internet and network paths with hyperlinks again, follow these steps:

1. On the Tools menu, click AutoCorrect Options.
2. In the AutoCorrect dialog box, click to select the Internet and network paths with hyperlinks check box on the AutoFormat As You Type tab, and then click OK.

The third menu option, Control AutoCorrect Options, allows you direct access to the AutoCorrect dialog box, so you may customize this and other AutoCorrect settings. This option is accessible by selecting AutoCorrect Options on the Tools menu as well.

back to the top

How to Understand AutoCorrect Hyperlink Functionality

The AutoCorrect Hyperlink button behaves differently than the other smart tag buttons in several ways. As mentioned earlier, its lightweight interface is significantly smaller than the other smart tag buttons. In addition, although the other buttons are available only until some action places another event on the undo stack, the AutoCorrect Hyperlink button remains available until the file is closed, or until the hyperlink is converted to text.

This button is removed from the cell only if the cell is converted to text and some action is added to the undo list. When this scenario occurs, the AutoCorrect Hyperlink button is removed from that cell. Only by re-entering the text in the cell do you make the button available again for that cell. All AutoCorrect Hyperlink buttons are removed when the file is closed. When the file is reopened, the AutoCorrect Hyperlink button is not displayed on any hyperlink text that is already in the file.

back to the top

REFERENCES

For more information about how to use AutoCorrect Hyperlink smart tags and other smart tags in Excel, click Microsoft Excel Help on the Help menu, type smart tags in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

291359 XL2002: How to Use Auto Fill Options Smart Tags

291358 HOW TO: Use the Paste Options Buttons in Excel 2002

291361 HOW TO: Use the Error Checking Options Button in Excel 2002

291363 XL2002: How to Use the "Insert Options" Button in Excel 2002

back to the top

Additional query words: OfficeKBHowTo inf XL2002 xl2003 XL2007

Keywords: kbgraphxlinkcritical kbhowtomaster KB291357

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.