Excel “Print to PDF” creating multiple files

microsoft excelprint to pdf

I am trying to print a workbook to pdf, but for some reason, it is attempting to save to multiple files. About 10 pages want to save in 2-3 pages per file, then the rest (another 15) save to the remaining file, totalling ~6 separate files. This happens with both Adobe and CutePDF Writer.

How can I print the entire workbook into one file?

Best Answer

I understand you are trying to print the entire workbook instead of just one worksheet (see screenshot). If that's the case, the default Excel behavior is to send each and every worksheet separately to the printer. That causes the PDF writer to create a separate file.

Excel - Print entire workbook

The solution is quite simple and I borrowed it from this site - thanks Helen Bradley! Follow these steps:

  • Select all worksheets (right click in any worksheet tab and click "Select All Sheets"
  • Select "File", "Print..." and "Print Active Sheets" to PDF.

For some magic reason Excel now appends all output to the printer instead of sending each and every worksheet separately. This creates one PDF file with all worksheets in it.

Related Question