Save excel as pdf changing its orientation to horizontal

Question

I have an excel sheet with too many columns, so when I save it as a PDF the file its in too many pages and its not easy to read . I need to save the sheet as pdf but before I want to change its orientation to horizontal so I can read the pdf with no problem. Is the same you can do when you print but I want it when I save an excel file as pdf. Is there any option I can choose?

 I dont mind if someone gives me a code for a macro using my selection as an object.

score 20 · Accepted Answer · answered May 05 '15 at 05:53

20

Under the "Page Layout" tab, click the "Orientation" option and then select "Landscape."

Then create your PDF as usual.

answered May 05 '15 at 05:53

Mathew Carrick

324
2
2

This answer doesn't work with Office Excel 2021. Maybe this used to work on older versions of Excel. – Sander Bouwhuis Feb 26 '23 at 07:16

score -4 · Answer 2 · answered May 13 '15 at 19:34

-4

You can save Excel files in PDF, even without using Excel. I use a program Universal Document Converter (http://www.print-driver.com/how-to/save-excel-as-pdf). This program allows you to quickly and easily create print-ready PDF-files on the basis of the original spreadsheets Excel.

answered May 13 '15 at 19:34

Dick Robertson

1

please describe how the user can get the desired orientation – Brino May 13 '15 at 19:42

Save excel as pdf changing its orientation to horizontal

2 Answers2