Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, November 19, 2007 – Permalink –

Smart Tags

Don't hide


In Excel, if you type a stock ticker symbol, the options offered on the Smart Tag are:


  • Stock quote from MSN MoneyCentral

  • Company report from MSN MoneyCentral

  • Recent news on MSN MoneyCentral

  • Insert a refreshable stock price

  • Remove the Smart Tag

  • Smart Tag options (This brings up the Smart Tags tab on the AutoCorrect menu.)


Complete tasks quickly with Smart Tags




How to turn on smart tags.

Smart tag functionality is turned off by default. Before you can use smart tag functionality, you must turn on smart tag recognition. To do this, follow these steps, as appropriate for the version of Excel that you are running.


Microsoft Office Excel 2007

  1. Click the Microsoft Office Button, and then click Excel Options.

  2. Click Proofing.

  3. Click AutoCorrect Options.

  4. In the AutoCorrect dialog box, click the Smart Tags tab.

  5. Click to select the Label data with smart tags check box.

  6. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.

  7. Click OK to close the Excel Options dialog box.





Microsoft Office Excel 2003 and earlier versions of Excel

  1. On the Tools menu, click AutoCorrect Options.

  2. In the AutoCorrect dialog box, click the Smart Tags tab.

  3. Click to select the Label data with smart tags check box.

  4. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.




Smart tag functionality

OfficeZealot.com:
SmartTagz



See all Topics

Labels: , ,


<Doug Klippert@ 7:40 AM

Comments: Post a Comment