Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Product Information
Help and How-to
Choose your version
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Additional Resources
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Get a stock quote
 
  1. Make sure that smart tags (smart tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.) are turned on.

    ShowHow to turn on smart tags

    1. Click the Microsoft Office Button Button image, and then click Excel Options.
    2. Click Proofing, and then click AutoCorrect Options.

      The AutoCorrect dialog box appears.

    3. Click the Smart Tags tab, and then select the Label data with smart tags check box.

      4. ShowIssue:  I don’t see any smart tags in the Recognizers list

      If you don’t see a list of smart tags in the Recognizers list (on the Smart Tags tab in the AutoCorrect dialog box), the Smart Tags add-in must be installed. To install the add-in, do the following:
      1. On your computer's system disk, locate the following folder:

        \Program Files\Common Files\Microsoft Shared\Smart Tag

      2. Run the program SmartTagInstall.exe.
    4. Click OK twice.
  2. Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Be sure to type the symbol in uppercase letters.
  3. Click outside the cell.
  4. Move your mouse pointer over the purple triangle in the lower-right corner of the cell, and then click the arrow next to the Smart Tag Actions Button image button 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.

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

advertisement
Printer-Friendly VersionPrinter-Friendly Version