Copy data from a Web page

Microsoft Office Excel 2003

Show All Show All

Copy data from a Web page

This procedure requires Microsoft Internet Explorer 4.1 or later.

  1. In your Web browser, select the data you want to copy.
  2. On the Edit menu, click Copy. If your browser doesn't have this command, see your browser's Help for information on copying.
  3. Switch to Microsoft Excel.
  4. Click in the upper-left corner of the worksheet area where you want the copied data to appear.
  5. On the Edit menu, click Paste.
  6. If the data does not appear as you expect, click Paste Options Button image and select one of the following options:
    • Keep Source Formatting    Makes no changes.
    • Match Destination Formatting    Matches the existing cell formatting.
    • Create Refreshable Web Query    Gives you the opportunity to create a query to the Web page you copied from. This gives you the opportunity to refresh the data should the Web page change later.