In yesterday’s post, we looked at creating XML Web Queries using the From Web feature on the Ribbon. Excel also allows you to create Web Queries using the Copy and Paste commands to import data into a worksheet. This allows you to keep the formatting of the original Web page. The Paste Options button, which appears after executing the Paste command, allows you to choose to paste the data as a Refreshable Web Query. Once the data is imported, you can use the Refresh All button to quickly update the data in your workbook.
To Create a Refreshable Web Query
- Display the Web page whose data you wish to copy.
- Select the data and press the Ctrl + C combination.
- Switch to Excel and activate the cell where you wish to insert the data.
- Press the Ctrl + V keystroke combination
Or
Click the Paste button on the Home Ribbon. - Click the Paste Options button and click Create Refreshable Web Query.
- Click the Yellow Arrow next to the information you want to import.
- Click Import.
Similar Posts:
- Creating an XML Query in Excel
- Creating a SQL Query in Access 2007
- Enter Data into Noncontiguous Cells in Excel
- Quick Navigation in Excel using Ctrl and Arrow Keys
- Create a Parameter Query in Access
- Converting Formula Results to Values in Excel
- Transpose Rows and Columns in Excel
Comments on this entry are closed.