August 8, 2007

How to copy table from Firefox to Excel

To paste the whole table:

Step 1: Hold down the CTRL key and click just outside the boarder of your grid. Either just above the grid, or on one of the sides. The entire grid should become highlighted.

Step 2: CTRL+C

Step 3: Open Excel and hit CTRL+V. You should get the entire grid pasted and formatted the same way you see it in Firefox.

Here is a good URL to practice with

To Paste a subset of a table, you will need to paste one column at a time:

Step 1: Ctrl+drag over the column you want in Firefox (yes, 1 column at a time).

Step 2: Paste into Excel. It will paste as a row, not a column. Don't worry - we'll get back to this. Repeat Steps 1 & 2 for as many cols of data that you need.

Step 3: After you have all the data you need into Excel (in rows), select them all and copy. Now move a few cells down and choose "Paste Special" - you'll see a few new options now. Choose "Transpose" in that dialog. This will turn the rows into columns.

No comments:

Post a Comment