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.
Sheet2 is the second worksheet, with its information in the following screenshot.
And here is the third worksheet, Sheet3.
Steps:
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-4.png)
![](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-6.png)
- 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.
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-7.png)
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-8.png)
- Click on Save. You will be able to save the whole workbook as one PDF.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-9.png)
- This saves multiple Excel sheets as one PDF. The image below shows page 1 of the PDF file with its data.
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-10.png)
- The image below shows page 2 of the PDF file with its data.
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-11.png)
- This image shows page 3 of the PDF file with its data.
![Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-12.png)
Method 2 – Using the Export Option to Save Multiple Excel Sheets as One PDF
Steps:
![Using ‘Export As PDF’ in Excel](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-4.png)
- Select Export and choose Create PDF/XPS Document.
- Click on the Create PDF/XPS button.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-13.png)
- 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.
![Using ‘Export As PDF’ in Excel](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-14.png)
![](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-15.png)
- Click on Publish. You will save the whole workbook as one PDF.
![Using ‘Export As PDF’ in Excel](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-16.png)
- The image below shows page 1 of the PDF file with its data.
![Using ‘Export As PDF’ in Excel](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-10.png)
- This image shows page 2 of the PDF file with its data.
![Using ‘Export As PDF’ in Excel](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-11.png)
- Here’s page 3 of the PDF file with its data.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/how-to-save-multiple-excel-sheets-as-one-pdf-12.png)
Download the Practice Workbook
Download this practice workbook to follow along while reading this article.