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:
- 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.
- 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.
- The image below shows page 2 of the PDF file with its data.
- This image shows page 3 of the PDF file with its data.
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.