How To Copy A Word Table to Excel worksheet?
August 2, 2009
No Comment
Earlier we saw how to create a Word Table in Microsoft word 2007. This article describes the steps to copy a Word table to an Excel 2007 Worksheet.
How To Copy Word Tables To Excel?
- On your Microsoft Word 2007 document, select the rows and columns of the table you want to copy.
- If you want to select the entire table, click the table, point to Select on the Table menu, and then click Table. You can also select the entire table by clicking on the + icon, that appears if you mouse over the top left corner of the table
- Click Copy on the Standard toolbar or press Ctrl + C
- Switch to your Microsoft Excel worksheet, where you want to paste the table
- Click on the upper-left corner of the worksheet area where you want to paste the table.
- Click Paste or Ctrl + V. Remember that Excel pastes the contents of each cell in the Word table to a separate Excel cell and Cells from the copied table will replace any existing cells in the area.
- To adjust the formatting, click Paste Options next to the data, and then click Match Destination Formatting to use any formatting that was previously applied to the Excel cells, or Keep Source Formatting to match the formatting of the Word table as closely as possible.
If you want to split the data in the Excel cells further, for example to divide first and last names so they’re in separate cells, use the Text to Columns command on the Data menu and proceed as per the guiding dialog boxes.
