Transfer of landscape Excel to portrait Word
Solvedm@rina Posted messages 27335 Registration date Status Modérateur Last intervention -
How to insert a 3-page Excel document in landscape orientation into a portrait Word document, as I want these 3 pages to remain in landscape mode, while the portrait Word format only accommodates half of it!
If I need to go through the Layout tab in Word (as the Office help suggests), I haven't found it in my Office 365 Word.
Thank you
7 réponses
I thank the person or the admin who kindly sent me a response from the AI, which seems perfectly suited to my case. Unfortunately, in the top ribbon of Word, I did not find the "Text Object File" option and therefore could not choose the "Excel Document" option.
I have the latest version of Office 365
Polorock
Hello
In Word, you insert a section break before inserting the Excel tables (Page Layout tab, Page Breaks button => Section Break => Next Page).
In this new section, you select the Landscape option, still under the Page Layout tab, Orientation button.
And then, the easiest part, you copy and paste your Excel tables, choosing the right format (either Excel table, image, or text, ...).
If you need to enter text again in Portrait format, you insert a new section break and select the Portrait option.
m@rina
Just a small issue, m@rina, the 3-page landscape table prints perfectly in my Word in portrait, but it is missing 3 elements:
1. The title of the table just above the 1st page, which is present in the original doc
2. The header row for the columns at the top of the 2nd and 3rd pages, while this row prints fine at the top of the 1st page
How can I recover these 2 "disappearances"... if it's possible?
Thanks a lot
I have the answer to my question 2: I forgot to repeat the first row of my table on pages 2 and 3, sorry, and that solved the issue.
For 1, I think I v