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

 

 

Method 1 – Save Multiple Excel Sheets as One PDF Using the ‘Save As’ Option

There are three worksheets in our Excel workbook. Sheet1 is the first worksheet, with its data shown in the following picture.

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

Sheet2 is the second worksheet, with its information in the following screenshot.

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

And here is the third worksheet, Sheet3.

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

Steps:

  • Go to the File tab.

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

  • 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.
  • Choose PDF from the Save as type dropdown list.
  • 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

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

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

  • 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

  • This image 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 Convert Excel to PDF without Converter


Method 2 – Using the Export Option to Save Multiple Excel Sheets as One PDF

Steps:

  • Go to the File tab.

Using ‘Export As PDF’ in Excel

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

Using ‘Export As PDF’ in Excel

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

  • Click on Publish. You will save the whole workbook as one PDF.

Using ‘Export As PDF’ in Excel

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

Using ‘Export As PDF’ in Excel

  • This image shows page 2 of the PDF file with its data.

Using ‘Export As PDF’ in Excel

  • Here’s page 3 of the PDF file with its data.

Read More: How to Convert Excel to PDF with All Columns


Download the Practice Workbook

Download this practice workbook to follow along while reading this article.

Download the PDF file.


Related Articles

<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

2 Comments
  1. Extremely clear and precise instructions.
    Thank you

    • Hello Bryan,

      You are most welcome. Thanks for your appreciation. Keep learning Excel with us.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo