Excel Tutorial
Excel Auto Correct and Smart Tags
AutoCorrect
By default, Microsoft Excel corrects common spelling errors that are specified in the AutoCorrect dialog box. You can change the spelling options for automatic corrections, and you can turn them on or off.Change spelling options for automatic corrections
- On the Tools menu, click AutoCorrect Options.
- On the AutoCorrect tab, do any of the following:
- To add a new AutoCorrect entry, type the text that you want in the Replace and With boxes, and then click Add.
- To edit an AutoCorrect entry, click it in the list, type the text that you want in the With box, and then click Replace.
- To delete an AutoCorrect entry, click it in the list, and then click Delete.
To enter capitalization exceptions, click Exceptions, and then do any of the following:
- To prevent AutoCorrect from automatically capitalizing words that follow an abbreviation, click the First Letter tab, and then, in the Don't capitalize after box, type the abbreviation, including the period. The new abbreviation will appear in the list.
- To prevent AutoCorrect from automatically correcting a word that contains a mixture of uppercase and lowercase letters, click the INitial CAps tab, and then type the word in the Don't correct box.
Turn automatic corrections on or off
- On the Tools menu, click AutoCorrect Options.
- On the AutoCorrect tab, do any of the following:
- To allow or prevent specific corrections, select or clear the corresponding check box for the option.
- To allow or prevent all automatic corrections, select or clear the Replace text as you type check box.
Smart Tags
Smart tagsrecognize and label Data as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.
You can save time by using smart tags to perform actions in Microsoft Excel that you'd usually open other programs to perform.
The purple triangles in the corners of cells on your worksheet indicate the smart tags.
How smart tags work
Excel recognizes certain types of data that it labels with smart tags. The type of actions you can take depend on the data that Excel recognizes and labels with a smart tag.
For example, if you recently sent mail to "Nate Sun", and you type the name into a cell on an Excel worksheet, the name is recognized and given a smart tag with actions you can take including Send Mail, Schedule a Meeting, Open Contact, or Add to Contacts.
The smart tag indicators appear in the cell on your worksheet as you type. They may also appear when you open a previously saved document. Note :Smart tags are turned off by default in Excel.
How to use smart tags
When Excel recognizes types of data, the data is marked with a smart tag indicator - a purple triangle in a worksheet cell. To find out what actions you can take with a smart tag, move the insertion point over the text with a smart tag indicator until Smart Tag Actionsappears, and then click the arrow next to the button to see a menu of actions.
If you save an Excel document that contains smart tags as a Web page, some tasks can be performed on the Web by using Microsoft Internet Explorer 5 or later. You can also use smart tags in your Outlook e-mail messages and in Microsoft Word.
How to get more smart tags
You can click More Smart Tags (on the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab) to go to Web sites to find new smart tags and actions. You might find additional smart tags created by Microsoft, by third-party companies, or by Information Technology (IT) professionals, who may design smart tags and actions for the specific products or services that you work with. Note :The types of smart tags that come with Excel vary with the language that is enabled.