ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting Excel Tables (https://www.excelbanter.com/excel-discussion-misc-queries/160541-exporting-excel-tables.html)

Astrid

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.



Peo Sjoblom

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