If you are looking for some special tricks to save multiple Excel sheets as one PDF, you’ve come to the right place. In Microsoft Excel, there are numerous ways to save multiple Excel sheets as one PDF. In this article, we’ll discuss two methods to save multiple Excel sheets. Let’s follow the complete guide to learn all of this.
How to Save Multiple Excel Sheets as One PDF: 2 Easy Methods
We will use two effective and tricky methods to save multiple Excel sheets as one PDF in the following section. This section provides extensive details on the two methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.
1. Save Multiple Excel Sheets as One PDF Using ‘Save As’ Option
Here, we will demonstrate how to save multiple sheets as one PDF with Save As option. Let us first introduce you to our Excel worksheet so that you are able to understand what we are trying to accomplish with this article. There are three worksheets in our Excel workbook. Sheet1 is the first worksheet, its data are shown in the following picture.
Sheet2 is the second worksheet, its data are shown in the following image.
Sheet3 is the third worksheet, its data are shown in the following image.
Let’s walk through the steps to find out how to save multiple Excel sheets as one pdf.
📌 Steps:
- Firstly, go to the File tab.
- Next, select Save As and click on the Browse option.
- When the Save As dialog box appears, specify a folder where the new file will be saved, then choose PDF from the Save as type dropdown list, and then click on Options.
- When the Options dialog box appears, check Entire Workbook. Click on OK.
- Finally, click on Save. As a result, you will be able to save the whole workbook as one PDF.
- Finally, you will be able to save multiple Excel sheets as one pdf. The image below shows page 1 of the PDF file with its data.
- Now, the image below shows page 2 of the PDF file with its data.
- The image below shows page 3 of the PDF file with its data.
Read More: How to Convert Excel to PDF without Converter
2. Utilizing ‘Export’ Option to Save Multiple Excel Sheets as One PDF
We can also save multiple sheets as one PDF with the Export option. Let’s walk through the steps to find out how to save multiple Excel sheets.
📌 Steps:
- Firstly, go to the File tab.
- Next, select Export and select Create PDF/XPS Document. Finally, click on Create PDF/XPS button.
- When Publish as PDF/XPS dialog box appears, specify a folder where the new file will be saved, then choose PDF from the Save as type dropdown list, and then click on Options.
- When the Options dialog box appears, check Entire Workbook. Click on OK.
- Finally, click on Publish. As a result, you will be able to save the whole workbook as one PDF.
Finally, you will be able to save multiple Excel sheets. The image below shows page 1 of the PDF file with its data.
Now, the image below shows page 2 of the PDF file with its data.
The image below shows page 3 of the PDF file with its data.
Read More: How to Convert Excel to PDF with All Columns
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Download the PDF file.
Conclusion
That’s the end of today’s session. I strongly believe that from now you may save multiple Excel sheets as one PDF. If you have any queries or recommendations, please share them in the comments section below.
Keep learning new methods and keep growing!
Related Articles
- How to Convert Excel to PDF without Losing Formatting
- Export Excel to PDF with Hyperlinks
- How to Save Excel as PDF on One Page
- How to Create a Fillable PDF from Excel
- How to Deal with Margin Problem While Converting Excel to PDF
- [Fixed!] Excel to PDF Size Problem While Printing
- [Fixed!] Excel to PDF Hyperlinks Not Working
- How to Save Excel as PDF without Cutting Off
<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
