![]() |
Exporting Excel Tables
I am trying to figure out a way to export an excel table into Word. The table
is approximately 40 columns long. I would ideally like to export it as a link, so when I change aspects of it in Excel, the Word file is also updated. The problem I encounter is that I have too many columns in my table, and when the table is imported all the columns after column 5 are lost somewhere in the right margin of the page. Is there a way to import a linked table and have it "wrap" along multiple pages in the Word document? I am using Excel 2003. |
Exporting Excel Tables
Do as follows: Click viewtoolbars and select customize, then click the
commands tab, in the left pane scroll down to tools and in the right scroll until you see a camera icon. Then just grab it with the mouse and drag it to one of your menu toolbars, then close the dialogue box. This will give you a snapshot than can be resized but it also links to the original workbook and updates -- Regards, Peo Sjoblom "Astrid" wrote in message ... I am trying to figure out a way to export an excel table into Word. The table is approximately 40 columns long. I would ideally like to export it as a link, so when I change aspects of it in Excel, the Word file is also updated. The problem I encounter is that I have too many columns in my table, and when the table is imported all the columns after column 5 are lost somewhere in the right margin of the page. Is there a way to import a linked table and have it "wrap" along multiple pages in the Word document? I am using Excel 2003. |
All times are GMT +1. The time now is 01:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com