Microsoft KB Archive/288958

= How to remove smart tags from a workbook in Excel =

Article ID: 288958

Article Last Modified on 2/6/2007

-

APPLIES TO


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

-



This article was previously published under Q288958



SUMMARY
This article explains how to remove smart tags from a workbook in Microsoft Excel.



MORE INFORMATION
To remove a single smart tag in a cell, follow these steps:
 * 1) Position the mouse pointer over the cell until the Smart Tag Actions button appears.
 * 2) Click the arrow on the Smart Tag Actions button, and then click Remove this Smart Tag.

To remove all smart tags that are associated with a specific recognizer, follow these steps:
 * 1) Start Excel, and then open the workbook from which you want to remove the smart tags.
 * 2) On the Tools menu, click AutoCorrect Options.

Note In Microsoft Office Excel 2007, click the Microsoft Office Button, click Proofing, and then click AutoCorrect Options.
 * 1) On the Smart Tags tab, click to clear the check boxes of the smart tags recognizers that you want to remove under Recognizers, and then click OK.
 * 2) If it is necessary, click to clear the Embed smart tags in this workbook check box, and then click OK.
 * 3) Close and then reopen the workbook for your changes to take effect.

To remove all smart tags in a workbook, follow these steps:
 * 1) Start Excel, and then open the workbook from which you want to remove the smart tags.
 * 2) On the Tools menu, click AutoCorrect Options.

Note In Excel 2007, click the Microsoft Office Button, click Proofing, and then click AutoCorrect Options.
 * 1) On the Smart Tags tab, click to clear the Label data with smart tags check box.
 * 2) If it is necessary, click to clear the Embed smart tags in this workbook check box, and then click OK.
 * 3) Close and then reopen the workbook for your changes to take effect.

Smart tags are built into Microsoft Office XP programs to provide easy access to actions that are based on data in a cell. Smart tags in a cell are indicated by a purple triangle in the lower-right corner.

Additional query words: OfficeKBHowTo inf XL2002 buttons tags smart icons purple triangle tagged labels labelled lables labled drop down i circle disable get rid of turn off don't want to see go away in corner cell list appears XL2003 XL2007

Keywords: kbexpertisebeginner kbhowto kbinfo KB288958

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.