下载并跟踪Excel 2007中的库存

This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.

本文由How-To Geek Blogs的技术博客MysticGeek撰写。

Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. If you are computing financial symbols, did you know there’s a way to have Excel automatically update those values online?

公司和个人使用Microsoft Excel来跟踪和计算几乎所有需要数字的内容。 如果您正在计算财务符号，您是否知道有一种方法可以让Excel自动在线更新这些值？

You can use smart tags in Excel to keep track of your stock quotes.  (Keep in mind you do need an Internet connection for this).  With this feature Excel will connect to MSN Money Central to download the information.

您可以在Excel中使用智能标记来跟踪股票报价。 (请记住，您确实需要Internet连接)。 借助此功能，Excel将连接到MSN Money Central以下载信息。

First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Make sure and place a check next to Financial Symbol.  Click OK twice to get back to your worksheet.

首先，我们需要通过单击Office按钮\ Excel选项\校对\自动更正选项并单击“智能标记”选项卡来启用智能单元功能。 确保并将检查放在“财务符号”旁边。 单击确定两次以返回到您的工作表。

Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters (in this instance I am using Microsoft).  Now hover the mouse over the lower left corner of the cell until the smart tag appears and click.  Select Insert refreshable stock price.

现在启用了智能标记，我们需要做的就是使用所有大写字母输入我们喜欢的股票代码(在这种情况下，我使用的是Microsoft)。 现在，将鼠标悬停在单元格的左下角，直到出现智能标记并单击。 选择插入可刷新的股票价格。

Now select where you would like the starting cell or you can also choose a new work sheet.  Click OK.

现在，选择您想要起始单元格的位置，也可以选择一个新的工作表。 单击确定。

Excel will go retrieve the information regarding the stock from MSN Money Central.  This will also include hyperlinks to additional information which will open in a separate browser.

Excel将从MSN Money Central检索有关股票的信息。 这还将包括指向其他​​信息的超链接，这些超链接将在单独的浏览器中打开。

Is this a feature you’d actually use?

这是您实际使用的功能吗？

翻译自: https://www.howtogeek.com/howto/microsoft-office/download-and-keep-track-of-stocks-in-excel-2007/