How to print multiple Excel sheets into a single PDF file?

Question

I am trying to print multiple sheets from the same Excel workbook into ONE PDF file. But it frequently prints them separately or only the first sheet.

I selected all the sheets and made them have the same page setup. I am working on Tiger and from the Print dialogue, I click on the left-hand bottom button, "Save PDF" and from there I choose "Save PDF-X".

Anyone have another solution for me?

score 2 · Answer 1 · answered Jun 09 '10 at 13:35

2

Select Multiple sheets using Ctrl and then print using pdf writer to get one single file vijay

answered Jun 09 '10 at 13:35

Vijay

21

score 1 · Answer 2 · answered Jan 25 '10 at 12:29

Just print the excel sheets into separate PDF files and join them using Adobe Acrobat Professional, if you have it. If not, don't sweat it: there's the brilliant open source PDF toolkit. Here's a short tutorial explaining how combine multiple PDFs.

It's very simple:

pdftk sheet1.pdf sheet2.pdf cat output sheets_all.pdf

Note that you can use wildcards and that the order of input determines the page ordering.

score 1 · Accepted Answer · edited Jul 13 '11 at 19:39

1

I tried multiple times to give the two separate sheets the same page margins and page properties, but it didn't help me one bit.

I fixed this with an Automator task that took me quite a while to work out, but once it worked, it helped me a lot.

Thanks for all the answers, though I really did specify in my question that I did do all the suggested solutions before posting.

edited Jul 13 '11 at 19:39

random

15,201

answered Apr 12 '10 at 13:56

Anriëtte Myburgh

522

score 1 · Answer 4 · answered Apr 13 '11 at 10:36

1

Select the sheets you want in your pdf file (make sure you print preview / set print areas in each sheet that you want to print) and "save as" pdf. Makes a pdf file with all selected worksheets.

answered Apr 13 '11 at 10:36

Catnz

11

score 0 · Answer 5 · answered Jan 25 '10 at 13:21

0

As Paul suggested, you could join them together after printing, f.e. also using pdfsam. As an alternative you can use PDFCreator which does support to create a query of documents and join them together.

answered Jan 25 '10 at 13:21

Bobby

9,032

score 0 · Answer 6 · answered Jan 25 '10 at 13:55

Is there any kind of "options" button in the Save As dialogue? On Excel 2007 / Windows the Save As pdf dialogue has an options button which then allows you to save only the selection, the active sheet, the selected sheets, the whole workbook etc. I have no idea if this is available on your version of Office for Mac.

score 0 · Answer 7 · edited May 05 '13 at 17:19

0

When saving the doc, selection option and all workbook instead of active sheet

Select and Drag all the PDFs into preview.
Select all in sidebar.
Print and Save As PDF.

edited May 05 '13 at 17:19

Sathyajith Bhat

62,374

answered Mar 12 '10 at 15:20

How to print multiple Excel sheets into a single PDF file?

7 Answers7