how to convert multi-pg excel docs to pdfs

Discussion in 'Mac Apps and Mac App Store' started by lmp, Aug 17, 2007.

  1. lmp macrumors newbie

    Joined:
    Aug 17, 2007
    #1
    Can anyone help me with how to convert an excel document with multiple worksheets to a pdf document on the mac so that all the sheets convert?
    Right now I have to convert each worksheet as it's own pdf and then merge them together to make one pdf.:(

    Thanks
     
  2. macfaninpdx macrumors regular

    Joined:
    Mar 6, 2007
    #2
    I'm not in front of my mac, so I can't check right now... but can't you just set it so it prints the entire workbook and then save as a PDF? What I mean is, if you print the entire workbook won't it print a worksheet on each page? If so, then when you select Save as PDF from the print dialog, each worksheet will be preserved as a page on the PDF document, right?
     
  3. lmp thread starter macrumors newbie

    Joined:
    Aug 17, 2007
    #3
    Print Dialog box

    Yes, I have set Print Dialog checkbox for Entire Workbook and it indicates in the preview that all of the pages are there but when I save as it only saves the last page of my document.
     
  4. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #4
    Calm down and go through this carefully. On mine, Preview shows 45 pages when I print a test workbook.
     
  5. lmp thread starter macrumors newbie

    Joined:
    Aug 17, 2007
    #5
    I calmly tried this again and am still getting the same results. I also see multiple pages in my preview when I select Entire Workbook but when I Save As, I only get the last page as a pdf.
     
  6. NoBoMac macrumors 68000

    Joined:
    Jul 1, 2014
    #6
    Which "Save as" are you using? If it's Excel's native option, probably why. For example, if you save a workbook as a csv file, the active sheet gets saved. You need to go to the Print dialog and select the "PDF" drop-down at the lower left. That should "print" all the sheets as a PDF file.
     
  7. NoBoMac, Aug 13, 2018
    Last edited: Aug 13, 2018

    NoBoMac macrumors 68000

    Joined:
    Jul 1, 2014
    #7
    EDIT: just tried to do this myself, and yes, Excel is pretty dumb on how they do this. Each sheet gets exported as an individual PDF file when "Workbook" is selected in "Save As". Best bet would be to use the Print option of generating a PDF file.
     
  8. campyguy macrumors 68040

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #8
    There, fixed that for you as IMO "past tense" given the 11-or-so years that have whizzed by...
     
  9. NoBoMac macrumors 68000

    Joined:
    Jul 1, 2014
    #9
    Doh! Didn't notice.

    Odd thing, this popped up in the latest posts feed for some odd reason.
     
  10. BrianBaughn macrumors 603

    BrianBaughn

    Joined:
    Feb 13, 2011
    Location:
    Baltimore, Maryland
    #10
    I think I've notice that before

    Maybe you can help them with their iPhone 1, too!
     

Share This Page