How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)

There are three worksheets in our Excel workbook. Sheet1 is the first worksheet, with its data shown in the following picture. Excel sheets as One PDF Using the ‘Save As’ Option" width="668" height="505" />Sheet2 is the second worksheet, with its information in the following screenshot. Excel sheets as One PDF Using the ‘Save As’ Option" width="667" height="503" />And here is the third worksheet, Sheet3. Excel sheets as One PDF Using the ‘Save As’ Option" width="667" height="503" />Steps:

• Go to the File tab.

Excel sheets as One PDF Using the ‘Save As’ Option" width="623" height="502" />

• When the Save As dialog box appears, specify a folder where the new file will be saved.
• Choose PDF from the Save as type dropdown list.
• Click on Options.

Excel sheets as One PDF Using the ‘Save As’ Option" width="690" height="385" />

Excel sheets as One PDF Using the ‘Save As’ Option" width="672" height="483" />

• Click on Save. You will be able to save the whole workbook as one PDF.

• This saves multiple Excel sheets as one PDF. The image below shows page 1 of the PDF file with its data.

Excel sheets as One PDF Using the ‘Save As’ Option" width="676" height="532" />

• The image below shows page 2 of the PDF file with its data.

Excel sheets as One PDF Using the ‘Save As’ Option" width="677" height="532" />

• This image shows page 3 of the PDF file with its data.

Excel sheets as One PDF Using the ‘Save As’ Option" width="679" height="533" />

Method 2 – Using the Export Option to Save Multiple Excel Sheets as One PDF

Steps:

• Select Export and choose Create PDF/XPS Document.
• Click on the Create PDF/XPS button.

• When the Publish as PDF/XPS dialog box appears, specify a folder where the new file will be saved.
• Choose PDF from the Save as type dropdown list.
• Click on Options.

• Click on Publish. You will save the whole workbook as one PDF.

• The image below shows page 1 of the PDF file with its data.

• This image shows page 2 of the PDF file with its data.

• Here’s page 3 of the PDF file with its data.

Download the Practice Workbook

Download this practice workbook to follow along while reading this article.