Excel table in a Word document in landscape format
jenny31
-
Frany -
Frany -
Hello,
I need to insert an Excel table into a Word document (I have Office 2007), which I managed to do. But I have 3 problems.
1) My table does not fit in width: I want to set it to landscape format. I can do that, but it puts the entire Word document in landscape.
2) How do I freeze a column in Excel so that it stays in place when scrolling?
3) Once I have written my document, how do I convert it to PDF with the Excel table?
Thank you in advance for your answers, I am a novice in this matter.
I need to insert an Excel table into a Word document (I have Office 2007), which I managed to do. But I have 3 problems.
1) My table does not fit in width: I want to set it to landscape format. I can do that, but it puts the entire Word document in landscape.
2) How do I freeze a column in Excel so that it stays in place when scrolling?
3) Once I have written my document, how do I convert it to PDF with the Excel table?
Thank you in advance for your answers, I am a novice in this matter.
3 réponses
Hello
1) You insert your table, select it, then under the Layout tab, Layout group, click on the dialog box launcher (the small square located at the bottom right of the group). Check Landscape, and at the bottom: Apply to selection. Automatically, section breaks will be inserted before and after your table.
2) View tab, Window group, Freeze Panes button.
3) Since you have version 2007, you can directly save as a PDF with Save As.
m@rina
--
- "On the office forum, we ask questions about office work..."
- "Oh really??? "
1) You insert your table, select it, then under the Layout tab, Layout group, click on the dialog box launcher (the small square located at the bottom right of the group). Check Landscape, and at the bottom: Apply to selection. Automatically, section breaks will be inserted before and after your table.
2) View tab, Window group, Freeze Panes button.
3) Since you have version 2007, you can directly save as a PDF with Save As.
m@rina
--
- "On the office forum, we ask questions about office work..."
- "Oh really??? "
Frany
You're welcome!