How to insert "wide" Excel table into Word

Question

Hello everyone,

I have made a really wide excel table for financial plans. It is currently 59 rows high and 123 columns wide. This means there is absolutely no chance to insert into one page in MS Word.

The orientation of my papers in MS Word (and MS Excel as well) is landscape and I would like to import it the way so it would look the same as if I printed it. In MS Excel I set the first 3 columns to repeat on every page and also it is only 1-page height document. If I printed it, there would be 8 landscaped pages with the same first 3 columns on every page and the rows will shrink into one page.

I have no idea how can I import it this way into MS Word. When I import it, it either goes off the paper (to the right), or it weirdly spreads across 300 pages (down) with bad formatting.

Is there a way, how can it be imported as a connected excel table that fits 1 page (height), but splits the table onto 8 pages (width) with repeating columns at the beginning? I've made a simplified scheme to make it more clear (there are 2 independent tables in the picture below):

Answer 1

You can make rows repeat in Word, but not columns. Here's how to set up header rows, In case this helps with a workaround:

1. Select the area in Excel and copy it.
2. In Word, choose Edit>Paste Special and paste as Formatted Text (RTF). The Excel sheet is turned into a Word table.
3. On the first page, select the rows to repeat and choose Table>Layout>Repeat Header Rows.

Answer 2

Hi David,

We would like to inform you that as of now, there is no out-of-the-box option to insert the print layout of Excel into Word. You can just copy and paste limited number of columns at a time as a possible workaround.

You can refer to this thread with a similar issue for more information and suggestions.

Regards,

Justin