How To Copy A Word Table to Excel worksheet?

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 on the table in the document and choose the item labeled “Select” on the ribbon under “Table Tools” => “Layout” tab. You can also select the entire table by clicking on the + icon, that appears when you mouse over the top left corner of the table.
  • Click “Copy” on the ribbon under the tab labeled “Home” or press Ctrl + C on the keyboard.
  • 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 on the ribbon or Ctrl + V on the keyboard. 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 pasted 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.

Leave a Reply

Your email address will not be published. Required fields are marked *