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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Download the PDF file.
2 Easy Methods to Save Multiple Excel Sheets as One PDF
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 Save Excel as PDF on One Page (3 Easy Methods)
Similar Readings
- Excel VBA to Print As PDF and Save with Automatic File Name
- How to Convert Excel to PDF without Converter (5 Effective Methods)
- Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)
- Print to PDF Using Macro Button in Excel (5 Macro Variants)
- Excel VBA: ExportAsFixedFormat PDF with Fit to Page (3 Examples)
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: Export Excel to PDF with Hyperlinks (2 Quick Methods)
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.
Don’t forget to check our website ExcelDemy for various Excel-related problems and solutions. Keep learning new methods and keep growing!
Related Articles
- Excel Macro to Save as PDF with Filename from Cell Value (2 Examples)
- Print Range to PDF with VBA in Excel (5 Easiest Examples)
- How to Save Excel as PDF without Cutting Off (4 Suitable Ways)
- Print to PDF and Email Using VBA in Excel (2 Useful Cases)
- How to Convert Excel to PDF without Losing Formatting (5 Effective Ways)
- Excel VBA: Create Invoice and Save PDF Format (with Quick Steps)
- How to Convert Excel to PDF with All Columns (5 Suitable Ways)