Importing Table Data from the Web to a Spreadsheet
It is not very difficult once you know how:
- highlight and copy ctrl-c your web table
- open your spreadsheet, paste ctl-v into the spreadsheet
- you may have headers you want to delete, remove the whole row
- you can also delete any columns, remove the whole column
- to remove images: home > find & select > go to special > objects. All images will be selected, delete
- then you can manipulate your spreadsheet
- save your spreadsheet
To highlight an area, click on the top left box, manipulate to the bottom right box, hit shift enter