- 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.
previous post