How to remove smart tags from a workbook in Excel

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.
  3. 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.
  4. If it is necessary, click to clear the Embed smart tags in this workbook check box, and then click OK.
  5. 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.
  3. On the Smart Tags tab, click to clear the Label data with smart tags check box.
  4. If it is necessary, click to clear the Embed smart tags in this workbook check box, and then click OK.
  5. 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.
Propriedades

ID do Artigo: 288958 - Última Revisão: 29 de abr de 2008 - Revisão: 1

Comentários