O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Acquiring Web Data with Smart Tags

Another useful capability in Excel 2003 is that of bringing information from the Web that is related to the contents of a worksheet cell. The technology that accomplishes this is called Smart Tags.

The clearest example of how Smart Tags work is with stock symbols, the abbreviations of company names on stock market tickers. You can turn on Smart Tags and have Excel look for known stock symbols (such as Microsoft’s stock symbol, MSFT) and connect to a Web site that has information related to that symbol.

To turn on Smart Tags, on the Tools menu, click AutoCorrect Options to display the AutoCorrect dialog box. In the AutoCorrect dialog box, click the Smart Tags tab to display the Smart Tags tab page.

Select the Label ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required