By To make a web page query in Excel 2016, you click the From Web command button on the Data tab of the Ribbon or press Alt+AFW. Excel then opens the New Web Query dialog box containing the Home page for your computer’s default web browser (Internet Explorer 10 in most cases). To select the web page containing the data you want to import into Excel, you can:. Type the URL web address in the Address text box at the top of the Home page in the New Web Query dialog box. Use the Search feature offered on the Home page or its links to find the web page containing the data you wish to import.
When you have the web page containing the data you want to import displayed in the New Web Query dialog box, Excel indicates which tables of information you can import from the web page into the worksheet by adding a yellow box with an arrowhead pointing right. To import these tables, you simply click this box to add a check mark to it. Selecting the table of data to import on the Yahoo! Finance web page. After you finish checking all the tables you want to import on the page, click the Import button to close the New Web Query dialog box.
![Excel import data from web Excel import data from web](/uploads/1/2/5/6/125633069/579503483.jpg)
Excel brings this data from the Volume Leaders table on the Yahoo! Finance web page into the worksheet as cell ranges rather than as an Excel Table.
![Access import excel table Access import excel table](/uploads/1/2/5/6/125633069/366505898.jpg)
If you then want to be able to sort or filter this imported financial data, you need to select one of its cells and then select the Format as Table button on the Home tab to format them and add the requisite AutoFilter buttons. When formatting data as a table, you remove all external connections to the data on the website. You can make web queries only when your computer has Internet access.
Import a Table From Microsoft Excel Formatting tables in Microsoft Word 8 Formatting Tips for Perfect Tables in Microsoft Word 8 Formatting Tips for Perfect Tables in Microsoft Word A table is more than a mere grid of cells.
Therefore, if you’re using Excel 2016 on a portable device that can’t currently connect to the web, you won’t be able to perform a new web query until you’re in a place where you can connect.