• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Publishing Data on the Web > Copying a Web Table to a Worksheet

Copying a Web Table to a Worksheet

You can copy tabular information on a Web page and paste or drag the information into an Excel worksheet. It's an easy way to transfer and manipulate Web-based table data using Excel. Excel simplifies access to table data by making it available to anyone with a browser. If you need to make changes to the table, you can use normal editing techniques in Excel.

Copy a Web Table to a Worksheet

Open your Web browser.

In the Address bar, type the location of the Web page with the table data you want to copy, and then press Enter.

Select the table data in the Web page you want to copy.

Open the Excel worksheet where you want to paste the table data.

Right-click the taskbar, and then click Tile Windows Vertically.

Drag the table data from the Web browser window to the location on the worksheet where you want the table data, and then release the mouse button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint