Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
I have a Word 2007 template for a monthly report that includes a formatted
table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
If this is something that you do each month, it would be worthwhile linking
the content of each cell in the Word table to the corresponding cell in Excel. Then all you will need to do is select the table and press F9 to update the fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message news I have a Word 2007 template for a monthly report that includes a formatted table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
#3
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
I guess that is what I will have to do. I was hoping to avoid it. :-)
"Doug Robbins - Word MVP" wrote: If this is something that you do each month, it would be worthwhile linking the content of each cell in the Word table to the corresponding cell in Excel. Then all you will need to do is select the table and press F9 to update the fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message news I have a Word 2007 template for a monthly report that includes a formatted table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
#4
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
You only have to do it once.
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message ... I guess that is what I will have to do. I was hoping to avoid it. :-) "Doug Robbins - Word MVP" wrote: If this is something that you do each month, it would be worthwhile linking the content of each cell in the Word table to the corresponding cell in Excel. Then all you will need to do is select the table and press F9 to update the fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message news I have a Word 2007 template for a monthly report that includes a formatted table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
#5
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
The alternative is to format the Excel table as you have it in Word and link
the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: You only have to do it once. "Barrie" wrote in message ... I guess that is what I will have to do. I was hoping to avoid it. :-) "Doug Robbins - Word MVP" wrote: If this is something that you do each month, it would be worthwhile linking the content of each cell in the Word table to the corresponding cell in Excel. Then all you will need to do is select the table and press F9 to update the fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message news I have a Word 2007 template for a monthly report that includes a formatted table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
#6
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel data to Word table template
Now you tell me! :-)
"Graham Mayor" wrote: The alternative is to format the Excel table as you have it in Word and link the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: You only have to do it once. "Barrie" wrote in message ... I guess that is what I will have to do. I was hoping to avoid it. :-) "Doug Robbins - Word MVP" wrote: If this is something that you do each month, it would be worthwhile linking the content of each cell in the Word table to the corresponding cell in Excel. Then all you will need to do is select the table and press F9 to update the fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barrie" wrote in message news I have a Word 2007 template for a monthly report that includes a formatted table. When I delete the data and try to copy and paste the updated rows and columns from Excel 2007, it all wants to go into the top left cell. Of course, I can copy over the data as a table but then I lose my formatting. How should I be going about this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Excel data to Word table | 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 | |||
Excel data into Word table | Mailmerge | |||
Copying an Excel data table into Word | Page Layout |