Show All

Hide All

You can use smart tags (smart tags: Data recognized and labeled 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.) to perform actions in Microsoft Excel that you'd usually open other programs to perform. For example, if you type a U.S. financial symbol such as MSFT in a cell, the Smart Tag Actions button provides a list of smart tag actions you can perform. The purple triangle in the corner of a worksheet cell indicates smart tags.

Smart tag indicators

Smart Tag Actions button

1. Make sure smart tags are turned on.

   How?

   1. On the Tools menu, click AutoCorrect options.
   2. Click the Smart Tags tab, and select the Label data with smart tags check box.
2. Move the insertion point over the purple triangle in a cell until Smart Tag Actions appears.
3. Click the arrow next to Smart Tag Actions to see the actions you can perform, and then select an action.