Copy Excel data into an existing Word Table
I have created a table in Word with approximately 16 columns. The data in the first row is basically my header/template for my table. The rest of the rows are blank. I have an excel table that I want to copy just the first 4 columns of data and x number of rows into my Word table I have set up. When I try to do this, the paste function either embeds an object or all the data appears in the first column and so on.
I need the data from the rows in Excel to be placed nicely in the first 4 columns, x number of rows and leave the other 12 columns blank.
I hope that makes sense, does anyone have an idea on how to copy from Excel and paste into an existing Table in Word?
|