Results 1 to 2 of 2

Thread: Excel Spreadsheet to PDF with multiple orientations

  1. #1
    Neophyte Glory1978's Avatar
    Join Date
    Oct 2020
    Posts
    1
    Articles
    0
    Excel Version
    365

    Excel Spreadsheet to PDF with multiple orientations



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am working with Excel spreadsheets that have 20-25 pages. Some are portrait, some are landscape. I now need to create a PDF of this file for distribution. I do have Acrobat Pro X on my computer so I can 1) print to Adobe PDF or 2) print to Microsoft Print to PDF. The problem is I am being asked to save multiple files based on the orientation. This was never a problem before installing Windows 10 and Office 365. I used to be able to Print to PDF and it would automatically pdf the pages based on the orientation of the individual worksheets. Please tell me there is something I haven't set up properly or I am missing something. I do not have the time to print 30 spreadsheets into multiple files and then piece them back together. That is not an efficient use of time.

    My apologies if this has been covered already. I just joined the forum and tried to search on "orientation" to see if there was a thread but didn't find any.

    Thanks,
    Lori

  2. #2
    Neophyte spillerbd's Avatar
    Join Date
    Apr 2016
    Location
    Collierville, TN
    Posts
    3
    Articles
    0
    Excel Version
    Office365, Office 2016
    Each Worksheet in the Excel Workbook would need to have the Orientation correctly set. If you use the page Header/Footers in the page set up, make sure you set orientations one worksheet at a time.
    I do recommend using the Export as PDF instead of the Print to Microsoft PDF. Pay attention to the Options when using this method. (Its even better used in Word.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •