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

Chapter 21. Sharing Information Between ... > Copying a Web Table to an Excel Work...

Copying a Web Table to an Excel 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 Web browser. After you paste the Web table into a worksheet, you can edit and format the table data like any other Excel information.

Copy a Web Table to an Excel Worksheet

Open your Web browser.

In the Address bar, type the location of the Web page with the page 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 Vertically.

Drag the table data from the Web browser window to the location on the worksheet where you want the table data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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