Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Paste Excel data to Word table
I have data in Excel 2003 that I'd like to paste into a Word 2003 table,
replacing any rows that already exist beneath the heading row. I want to keep the Word table format unchanged since the column headings, widths, etc. are just right. I've tried all Paste Special options, but I can't get it to work. The column widths in the Word table always end up changing, or other formatting problems occur. I've tried Excel and Word 2007 and also can't get it right. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Paste Excel data to Word table
Hi Gregg,
You'll need to set Word and Excel up to use the same column widths for this. Do note, though, that Excel doesn't give as much control over column widths as you can get in Word. Because of that, you might have to adjust the column widths in Word to match what Excel can deliver. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Gregg" wrote in message ... I have data in Excel 2003 that I'd like to paste into a Word 2003 table, replacing any rows that already exist beneath the heading row. I want to keep the Word table format unchanged since the column headings, widths, etc. are just right. I've tried all Paste Special options, but I can't get it to work. The column widths in the Word table always end up changing, or other formatting problems occur. I've tried Excel and Word 2007 and also can't get it right. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Paste Excel data to Word table
Thank you for taking the time to respond. I see how I can manipulate column
widths in Excel to basically get this done. I'll probably bring the column headings over from Excel as well to avoid having to match widths exactly. Thanks again! "macropod" wrote: Hi Gregg, You'll need to set Word and Excel up to use the same column widths for this. Do note, though, that Excel doesn't give as much control over column widths as you can get in Word. Because of that, you might have to adjust the column widths in Word to match what Excel can deliver. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Gregg" wrote in message ... I have data in Excel 2003 that I'd like to paste into a Word 2003 table, replacing any rows that already exist beneath the heading row. I want to keep the Word table format unchanged since the column headings, widths, etc. are just right. I've tried all Paste Special options, but I can't get it to work. The column widths in the Word table always end up changing, or other formatting problems occur. I've tried Excel and Word 2007 and also can't get it right. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste table from Excel to Word | Tables | |||
Update Excel table in Word automatically from data in Excel | Tables | |||
Update Excel table in Word automatically from data in Excel | Microsoft Word Help | |||
I can't paste Excel data into Word as a table - any ideas? | Tables | |||
paste excel data to word problem | Microsoft Word Help |