Forum Discussion

David Dechamplain's avatar
David Dechamplain
Copper Contributor
Sep 18, 2018

exporting or printing in PDF format in Exel

I have an excel workbook that I have been using for years for invoicing.  This first page of the workbook has a portrait layout, the remaining 4 pages are in landscape.  I've tried exporting to pdf a...
excel
Hani Gazzaz's avatar
Hani Gazzaz
Copper Contributor
Oct 11, 2018

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

 

  • mathetes's avatar
    mathetes
    Silver Contributor
    Nov 19, 2019

    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. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 11, 2018

    Hi Hani,

     

    Sorry, but I never worked with Excel for Mac, perhaps someone else could help.

Resources