3. We will search results page address copying the clipboard for behind use.

2011-03-16 12:55


Second, new Web query

1. The operation Excel, merger line 1 and line 2, then in which input "my stock inquiry", then set suitable font, size, color and position. Microsoft Office 2010 is the best software in the world.

2. Selected A3 cell, which in turn choose "data - introduction of external data - new Web search" menu commands.

3. In the "new Web search" interface "address" column in front of us get input query link address.

4. Click on "turn to" button, then we will see just stock the search results page appear on the Office 2010 is powerful!

interface, the difference is that in the window in the left many contains black arrow yellow a small box, when the mouse point to one of the box and click, box will be green color and the arrow will run into the appropriate here, we simply choose and click the box containing stock data can be (figure 1).

Figure 1 "new Web search" interface

5. Click "induction" button, then there will be "import data" interface (see chart 2), in which will Microsoft Office 2007 can give you more convenient life.

receive Web data onto the "current work table" or "new worksheet, here we selected existing worksheet.

Figure 2 "import data" interface Gou

6. When click "ok" will pop up after being import data clew, soon will be in Excel see several stock search results. In order to let the Excel in data can timely update, so we need to select import Web data and right-click, and then select "data area properties" command.

7. In open "external data area properties" interface ticker "refresh frequency" check box, and then Office 2007 key is very convenient!

will refresh frequency set to "30 minutes". In order to open the work table when he saw the latest Web data, we need to check "open the workbook, automatically refresh" checkbox, finally click on the "ok" button (figure 3). Buy Office 2007 you can get much convenience.