#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
You can paste the Excel data into a new table, then drag it from there into the destination table.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
copy, formatting, table |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
data from Excel into Word table | ragesz | Word Tables | 1 | 09-29-2013 06:14 PM |
Modifying an existing table in Word | janewayb | Word Tables | 1 | 04-08-2013 06:17 PM |
Cannot copy ->paste table structure but data pastes ok | kangz | Word | 1 | 04-24-2012 04:05 AM |
How to copy automatically data from Excel file to Word file? | fuchsd | Word | 6 | 10-25-2011 05:52 AM |
Excel data to Word table | Jaymond Flurrie | Word VBA | 2 | 02-27-2011 07:42 PM |