You can control automatic changes to your worksheet with smart tags. A smart tag is a button that pops up on the screen when you perform certain Excel operations, as described in Table 20.1.
Figure 20.11 shows an example of a smart tag button.
How It Works
After you perform a fill operation, such as dragging the fill handle, this smart tag provides options for filling cells.
After you insert cells, rows, or columns, this smart tag provides formatting options.
After you paste data, this smart tag specifies how moved or pasted items should display. For example, original formatting, with or without formatting, or with different formatting.
Smart Tag Actions
Lists information options for a cell that contains data recognized by Excel, such as a stock symbol.
If you assign an invalid formula to a cell, this smart tag lists error checking options.
When you see a smart tag, hover the mouse pointer over the smart tag button and click the down arrow next to the button to display a menu. Choose an option on the menu to modify the previous operation or obtain additional information.
To display labels for smart tags, you need to turn on the smart tags feature. To do so, choose Tools, AutoCorrect Options. Click the Smart Tags tab, and select the Label data with smart tags check box (see Figure 20.12). Select any smart tags in the Recognizers list. If you want to embed the smart tags in the workbook, select the Embed smart tags in this workbook check box. Then click OK.
When you roll the mouse pointer over a cell that contains a date, financial symbol, or a person's name from a recent Microsoft Outlook email, you will see the Smart Tag. Click the Smart Tag down arrow to see a list of options.
With the Smart Tag Actions and Trace Error smart tags, Excel displays a smart tag indicator in a cell to let you know that the smart tag is available. A smart tag indicator is a small triangle that appears in one of the corners of the cell. When you select a cell with a smart tag indicator, Excel displays the smart tag.