Using Smart Tags

Smart Tags help you integrate actions typically performed in other programs directly in Excel. For example, you can insert a financial symbol to get a stock quote, add a person's name and address in a worksheet to the contacts list in Microsoft Outlook, or copy and paste information with added control. Excel analyzes the data you type in a cell and recognizes certain types that it marks with Smart Tags. The types of actions you can take depend on the type of data in the cell with the Smart Tag.

Change Smart Tag Options

graphics/one_icon.jpg

Click the Tools menu, and then click AutoCorrect options.

graphics/tow_icon.jpg

Click the Smart Tags tab.

graphics/three_icon.jpg

Select the Label Data With Smart Tags check box.

graphics/foure_icon.jpg

Select the check boxes with the Smart Tags you want.

graphics/five_icon.jpg

Click the Show Smart Tags As list arrow, and then select a display option.

graphics/six_icon.jpg

To check the worksheet for new Smart Tags, click Check Workbook.

graphics/seven_icon.jpg

To add more Smart Tags, click More Smart Tags, and then follow the online instructions.

graphics/eight_icon.jpg

Click OK.

graphics/02inf38.jpg

graphics/02inf39.jpg

Get a Stock Quote Using a Smart Tag

graphics/one_icon.jpg

Click a cell where you want to insert a stock quote.

graphics/tow_icon.jpg

Type a recognized financial symbol in capital letters .

graphics/three_icon.jpg

Click outside the cell, and then point to the purple triangle in the lower-right corner of the cell to display the Smart Tag button. The purple triangle in the corner of a cell indicates a smart tag is available for the cell contents.

graphics/foure_icon.jpg

Click the Smart Tag button, and then click the list arrow next to the button.

graphics/five_icon.jpg

Click Insert Refreshable Stock Price.

graphics/six_icon.jpg

Click the On A New Sheet option or the Starting At Cell option, and then click OK.

graphics/seven_icon.jpg

A new worksheet is inserted containing the stock information.

graphics/02inf40.jpg

graphics/02inf41.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net