Formatting of excel worksheets in word

[Guest]

I am trying to copy an excel worksheet into word (its part of a regular
report and hence needs to be easily repeatable) but continually run into
problems.

The worksheet spans multiple pages and will need header rows displayed on
each page in the word doc.
If I copy/paste, the worksheet is always far larger than the word page and I
am unable to format table via table properties/preferred width - it seems
unable to bring the width down to the value I specify (to fit A4 landscape
page)
If I copy/paste as picture it cannot span multiple pages

If excel set up has an influence
Excel spreadsheet page setup is formatted for landscape and single page
width (results in approx 4 sheets)

 

[Guest]

One possibility would be to set up ranges in Excel and then copy/paste link
(if you want the data to update when Excel changes) or copy/paste the ranges
into Word, one range per page. I tend to use copy/paste link using Picture,
but Microsoft Excel Worksheet Object also works. Obviously, in this case you
would need to add the headers manually to Excel in the top row of each range
and adjust any formulas to account for the text rows.

 

[Ed]

If it's practical, you might consider adding extra sheets to your Excel
workbook and formatting them as tables that will fit one page of your Word
document. If your main table (assumed to be on Sheet1) header spans (for
example) A1:C8, then Sheet2!A1:C8, Sheet3!A1:C8, and Sheet4!A1:C8 will all =
Sheet1!A1:C8. Then Sheet2!D1:J8 (or however much fits on one Word page)
will = Sheet1!D1:J8, while Sheet3!D1:J8 will = Sheet1!K1:S8, and so forth.
Copying the tables on Sheets 2 - 4 should then give you one Word page of
your data table.

HTH
Ed