Save Excel Sheet as Landscape PDF

[Billy Baxter]

Hi,
I have a landscape oriented sheet which I would like to save as a pdf. It is 3 pages in excel but when I save as pdf it changes the print area to become 10 pages of portrait. Is there an easy way to simply save the sheet as it looks in excel ie 3 pages of landscape pdf.
Thanks in advance for any help,
Regards
Billy

 

[Akira181]

go to the Page Layout on the ribbon, make sure Orientation is set to landscape

Then File > Export > Create PDF > Publish

Should appear as the same layout in excel. On office 365 at least

 

[Billy Baxter]

go to the Page Layout on the ribbon, make sure Orientation is set to landscape

Then File > Export > Create PDF > Publish

Should appear as the same layout in excel. On office 365 at least

Hi,
Thanks for taking the time to reply. I have looked at this, I don't have the same options ie File>Export is not there however there is Share where you can share as PDF. It does exactly the same thing as when I Save As. I have an excel sheet in page layout view which is set to 3 landscape pages, it all fits ok. When I save as or Share as PDF it changes this into a 10 page PDF file. The pages in the PDF are landscape but it looks like it has taken the excel file information itself and split it down through the middle of the pages, it looks like there is plenty of room on either side in the pdf to put the rest of the information but there are just massive wide blank margins. Any other suggestions appreciated thanks.

 

[Akira181]

have print areas been set in portrait mode? might be why the PDF is splitting across the middle of the page

 

[Billy Baxter]

Hi Akira,
I've selected the whole area as the print area but no different, same thing happens.
Thanks for the suggestion
Billy