Forum Discussion
exporting or printing in PDF format in Exel
Hi David,
With such options
is saves correctly, sample is attached
SergeiBaklan where is this setting, I can't find it. Tks,
In Save As select PDF type and click More options
Here Options... shall appear
where you may select desired setting
Hi Sergei,
How could I do this solution on my Excel for Mac, the Office 365 Subscription.
In print preview I could see the page formatting Okay. But when I try to Save As PDF, it ignores the formatting and saves on several pages in one file.
Thank you,,
Hani
Hani Gazzaz Interesting. I can make a single document in Word, but not in Excel, printing pages in both Portrait and Landscape mode. In Word, I inserted a "Section Break" between the pages. Excel offers page breaks, but not Section Breaks.
As a work-around, a PDF editor such as PDF Expert would allow you to save as PDF (from Excel) the portrait page and landscape page separately, then integrate them into a single PDF document. It's not terribly time-consuming, but for use on infrequent occasions at least enables the desired result. And PDF Expert is available in the Apple App Store.
Hi Hani,
Sorry, but I never worked with Excel for Mac, perhaps someone else could help.
Sergei, You are an angel my friend! Thank you soo much - that was much easier and painless then I could have imagined.
Cheers, Dave
David, you are welcome
