Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Info transfer from Excel into Word tables?

Apr 17, 2014 5:51AM PDT

I have been given the task to extract data from an excel sheet and put each row of info into a table. So far I have been just using copy and paste.

I have a lot of rows sadly and this will take days done by copy and pasting. Is there anway to tell word to extract data from an excel sheet and put it into tables a certain way?

Discussion is locked

- Collapse -
Clarification Request
How many rows, columns, landscape or portrait ? You could
Apr 17, 2014 9:35AM PDT

also highlight data in the SS and paste it as a PIC/table in Word doc.

VAPCMD

- Collapse -
Answer
Re: Excel to Word
Apr 17, 2014 6:01AM PDT

I just copy-paste the whole sheet.That's one click and ctrl-c in Excel, then ctrl-V in Word. What's keeping you from doing the same?

Kees