Many Lockergnome articles give great advice, but I’ve yet to see the answer to my original question, which was: How can I copy cells from Excel into an existing Word table?
Now that I know the answer, I figured I’d pass it along.
- In Excel, copy the cells you want as usual.
- In Word, select an area in your table the same size and shape as the data you are going to copy.
- Paste in the normal way.
If the area you selected in the Word document is too small, data will be omitted.
If the area you selected in the Word document is too large, then data items will be repeated as necessary to fill the available space.
My name is Tom Sharpe, and I’m a veteran computer person. I used to work at Manchester University in health informatics, starting with early mainframes and minicomputers and working my way through Apples and PETs to the IBM PC and its successors.
Having taken early retirement, I still had the conputer bug and did stints in NHS IT. Now I’m at the National Haemophilia Database using Access and SQL. I can be found on Twitter as BachAndByte.