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



  Friday, August 07, 2015 – Permalink –

Stock Answer

Built in service



You can easily insert an automatically updated stock quote for a specific company in a spreadsheet.

Here are the instructions:

  1. On the Tools menu, click AutoCorrect options.
    (Use the Office button and Excel Options in 2007+)
  2. Click the Smart Tags tab and place a check beside Label data with smart tags.
  3. Click OK.
  4. Type in a Stock symbol (such as MSFT) in a cell.
    (The symbol must be 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.




See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:20 AM

Comments: Post a Comment