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. Save Multiple Excel sheets as One PDF Using the ‘Save As’ OptionSheet2 is the second worksheet, with its information in the following screenshot. Save Multiple Excel sheets as One PDF Using the ‘Save As’ OptionAnd here is the third worksheet, Sheet3. Save Multiple Excel sheets as One PDF Using the ‘Save As’ OptionSteps:

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

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

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

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

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

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

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

Steps:

Using ‘Export As PDF’ in Excel

Using ‘Export As PDF’ in Excel

Using ‘Export As PDF’ in Excel

Using ‘Export As PDF’ in Excel

Using ‘Export As PDF’ in Excel

Download the Practice Workbook

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