Word Table into Excel Spreadsheet

R

Rachel

Hi All,
I have created a table in Word and would like to transfer
this into a Excel Spreadsheet for further editing.
I have tried to copy all the columns in the table and
paste them but the data in the table comes out in the
wrong place, i.e. rows not lined up correctly.
Does anyone know if it is possible to do this?
Thanks in advance for any help.
Rachel
 
P

Paul

Rachel said:
Hi All,
I have created a table in Word and would like to transfer
this into a Excel Spreadsheet for further editing.
I have tried to copy all the columns in the table and
paste them but the data in the table comes out in the
wrong place, i.e. rows not lined up correctly.
Does anyone know if it is possible to do this?
Thanks in advance for any help.
Rachel

In Word, select the entire table. (To do this, click somewhere in table and
use Table > Select Table.)
Copy this.
Switch to Excel.
Select the cell where you want the top left of your table to be.
Use Paste. This should paste your entire table, cell by cell, as it was in
Word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top