Get a stock quote

1. Make sure smart tags are turned on.

   How?

   1. Click AutoCorrect options on the Tools menu.
   2. Click the Smart Tags tab, and select the Label data with smart tags check box.
2. Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Type the symbol in capital letters.
3. Click outside of the cell.
4. Move your mouse cursor over the purple triangle in the lower-right of the cell, and then click the arrow next to Smart Tag Actions to see a list of options.
5. Click Insert refreshable stock price.
6. In the Insert Stock Price dialog box, choose whether to insert the stock price on a new worksheet or in a specific area of your current worksheet.

   The data that is returned may fill a large portion of your worksheet.

Note   You can also use an add-in to insert a function that retrieves stock quotes and stock data. For more information, see the Microsoft Office Web site. The hyperlink in this topic goes to the Web. You can switch back to Help at any time.