how to convert multi-pg excel docs to pdfs

lmp

macrumors newbie
Original poster
Aug 17, 2007
3
0
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
 

macfaninpdx

macrumors regular
Mar 6, 2007
198
0
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?
 

lmp

macrumors newbie
Original poster
Aug 17, 2007
3
0
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.
 

MisterMe

macrumors G4
Jul 17, 2002
10,650
28
USA
Calm down and go through this carefully. On mine, Preview shows 45 pages when I print a test workbook.
 

lmp

macrumors newbie
Original poster
Aug 17, 2007
3
0
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.
 

NoBoMac

Moderator
Staff member
Jul 1, 2014
2,542
931
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.
 

NoBoMac

Moderator
Staff member
Jul 1, 2014
2,542
931
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:

NoBoMac

Moderator
Staff member
Jul 1, 2014
2,542
931
Doh! Didn't notice.

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