If you work with stock quotes in Excel 2002, you can easily insert an automatically updating stock price quote for a specific company into your spreadsheet. Once you have your spreadsheet open, complete the following steps:

1. From the Tools menu, click AutoCorrect options.


2. Click the Smart Tags tab and place a check beside Label data with smart tags.


3. Click OK.


4. Type in a recognized U.S. financial symbol (such as MSFT) in a cell. Make sure the symbol is done in all caps.


5. Click outside of the cell.


6. Place your mouse cursor over the purple triangle in the lower-right corner of the cell. Click the arrow.


7. Click Insert refreshable stock price.


8. Select whether to insert the stock price on a new worksheet or in a specific area on your current worksheet.

You can refresh a stock quote price at any time by right clicking anywhere within your worksheet and selecting Data Range Properties. Enter a value for how often the stock quote price should be refreshed. For example, you can enter in 60 to have the price updated every hour.