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.

Answer 1

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

Then create your PDF as usual.