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

Get FREE Advanced Excel Exercises with Solutions!

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.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

Sheet2 is the second worksheet, its data are shown in the following image.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

Sheet3 is the third worksheet, its data are shown in the following image.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

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.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

  • 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.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

  • When the Options dialog box appears, check Entire Workbook. Click on OK.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

  • 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.

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

  • Now, 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

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

Save Multiple Excel sheets as One PDF Using the ‘Save As’ Option

Read More: How to Save Excel as PDF on One Page (3 Easy Methods)


Similar Readings


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.

Using ‘Export As PDF’ in Excel

  • 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.

Using ‘Export As PDF’ in Excel

  • 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.

Using ‘Export As PDF’ in Excel

Finally, you will be able to save multiple Excel sheets. The image below shows page 1 of the PDF file with its data.

Using ‘Export As PDF’ in Excel

Now, the image below shows page 2 of the PDF file with its data.

Using ‘Export As PDF’ in Excel

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

Saquib Ahmad Shuvo

Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo