Toggle sidebar Toggle sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

how to convert multi-pg excel docs to pdfs

L

lmp

macrumors newbie
Original poster
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
 
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?
 
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.
 
Calm down and go through this carefully. On mine, Preview shows 45 pages when I print a test workbook.
 
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.
 
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.
 
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.
 
Last edited:
Doh! Didn't notice.

Odd thing, this popped up in the latest posts feed for some odd reason.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back