Pasting Cells from Excel into a Word Table

[nhbcai]

Hi guys,

I want to paste cells from Excel into an existing table in Word. All the 'how-tos' I have read only say how to paste Excels cells into a 'new' table in Word, not an existing one.

If I copy a few cells in Excel, then try to paste them into an appropriate part of an existing table in Word, all the Excell Cells get pasted into the one cell in the Word table, not over the same range, using the selected cell as the top left corner, which is how it 'should' work (in my opinion, anyway, after all, when copying and pasting in the other direction, from a Word table to Excel, the cells from the Word table do not all get copied into the one Excel cell, they are copied to a range, using the cell selected for the paste as the top-left corner of the range.

So, to clarify, I want to (for example) copy fifty cells in a column in Excel, (say, A2-A51), and paste them into a large table in Word, with A2 going into the cell in the word table that I have selected with my mouse, and cell A3 then goes into the cell below in the word table, and so on.

Anyone know how to do this?

 

[Macropod]

Hi nhbcai,

That's how copying & pasting works - if you want to paste just the values, you need to do so individually. If you're doing this regularly for the same Excel range, perhaps you sould consider copying & pasting the data into a new table once, using the 'paste link' method. From then on, any changes to the Excel data will automatically update in Word without the need for further copying & pasting. Alternatively, you could write a macro to take the values from Excel and write them to the cells in Word.