Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

LinkBack Thread Tools Display Modes
Old 07-21-2010, 12:44 PM
ripcurlksm ripcurlksm is offline Windows 7 Office 2007
Join Date: Jul 2010
Posts: 1
ripcurlksm is on a distinguished road
Default Excel Tables to MS Word


I have a project where I am getting 1,500 Excel tables. The tables need to be formatted and colored to look pretty, then imported into Word and laid out, and create a table of contents for each table title. I am going to deliver (1) a Word doc with a table of contents and 1,500 pretty tables, and (2) an Excel file with a straight list of pretty tables.

I currently get 1,500 tables that look like this:

I take a table design and "Copy > Paste Special > Format" 1,500 times, which keeps the data but styles the background. (some tables have more rows than others so i have to go back and touch up 50% of the tables and it comes out looking like this:

I then copy all the rows in Excel and paste it into Word. I highlight the entire selection of table data and adjust the columns that get squished to even them out. I highlight all 1,500 table names and style them as a "heading", so I can make a table of contents. I also insert page breaks throughout the entire document to prevent tables from being cut off and partially displayed on the next page. The word doc looks like this:

My questions/comments:

Is there any way I can improve this process? I know that I can make a macro to import data from Excel to Word and it will automatically style it. The benefit to this is also if data changes in Excel, you only have to update one document. The downside to this is that it appears you have to make a lot of selections and import the tables to be styled one-by-one. Is this so? I need the Excel tables and Word tables to be styled. The way I am currently doing it seems okay, but Im curious if there is a better way? Can I insert "headings" in Excel and will it carry over to Word to make the table of contents easier to make? Is there anything I am missing that will let me take a ton of unstyled tables, apply a design to them and export them with a table of contents with page numbering?
Reply With Quote
Old 09-07-2011, 04:35 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road

I am not sure if you have had a response to your post. However perhaps the best way to achieve what you want is to create links to your excel tables. That way you should not have to do any tidying up in your Word document as the format will be as your excel tables.
Hope this helps.
Good luck.
Reply With Quote
Old 09-09-2011, 04:59 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,800
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold

If the data are suitably laid out in a single Excel workbook, a mailmerge should be able to handle it. Simply format a table in the Word mailmerge main document with the required layout, mergefields, fonts and Styles. Then execute the mailmerge (a catalogue/directory mailmerge might be best) and add a TOC afterwards.
Paul Edstein
[MS MVP - Word]
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading in Cells in Word Tables Cindy Word Tables 1 01-04-2013 02:38 PM
Word tables nbudd Word Tables 1 05-09-2010 06:31 AM
Linking Excel Pivot Tables in a Word Document wmarsh3561 Word Tables 0 11-17-2009 06:29 AM
Excel Tables, Text Box wrapping, Form Locking all4als Word Tables 0 11-03-2009 02:26 PM
How to transfer Word 2003 Tables to Excel? steeleye Word Tables 1 07-10-2009 04:18 PM

All times are GMT -7. The time now is 09:04 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft