How to Convert a Table From Word to Excel 2007

Whether you are writing a report or creating a presentation, a table can quickly summarize data for the reader. After you have created a table in Word, you can convert it into Excel and add, reformat or manipulate it as needed. Converting a table from Word to Excel requires copying and moving between Microsoft Office applications rather than saving in a different format.

Instructions

1

Open the Word document with a table you want to convert. Open Excel to a blank worksheet.

2

Select the table from the Word document by hovering your mouse over the top left corner of the table until you see a square and clicking it. This should highlight the entire table. If you do not want to select the entire table, select just the rows or columns you want to copy.

3

Press "Ctrl" and "C" on your keyboard to copy the selection.

4

Switch to the Excel worksheet.

5

Click an empty cell where you want the top left corner of your table to be.

6

Press "Ctrl" and "V" to copy the table as is. It will copy all the original formatting of your Word table, including lines and fonts. To copy the table without formatting, click the down arrow under the "Paste" button on the Home tab and select "Paste Special." Choose "Text" from the menu to paste the table without formatting.

7

Save the Excel document.