How to Display a Smart Tag Button

Smart tags can help you format cell data faster.

Microsoft Excel 2007 includes a feature called smart tags. Smart tags are buttons that appear next to cells containing data that Excel recognizes, such as addresses and symbols. When you click on a smart tag button, a drop-down list of actions, such as the options to add an address or format your text, appears. You can display smart tag buttons in Excel 2007 by modifying the AutoCorrect Options and placing your mouse pointer over a cell containing recognizable data.

Things You'll Need

• Microsoft Excel 2007

Instructions

1. Click the "Microsoft Office" button and click the "Excel Options" button in the bottom right corner of the menu.

2. Click "Proofing" and then the "AutoCorrect Options" button. The AutoCorrect dialog box appears.

3. Click the "Smart Tags" tab.

4. Click the "Label data with smart tags" box if it doesn't contain a check mark.

5. Select "Button Only" from the "Show smart tags as" drop-down menu.

6. Click "OK."

7. Click or place the mouse pointer over a cell to see the smart tag button. The button appears only if Excel 2007 recognizes the data in the cell.

Tips & Warnings

• Microsoft Office 2010 doesn't support smart tags.

References

• Microsoft: Description of the Smart Tag Functionality in Excel
• ExcelTip.com: Changing Smart Tag Options
• Think: Enable Smart Tags in Microsoft Excel 2007