How to merge multiple sheets into 1 PDF file in Excel 2013

When using Office 2007 version and below when you want to convert into a PDF file, you add Add-On but now with Office 2013 with just a few simple steps, you can combine multiple sheets in Excel into one PDF file.

Step 1: Open the Excel file containing the data to merge. For example, there are 3 sheets 1, 2, 3.

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 1

Step 2: Right-click on any one Sheet and select Select All Sheets .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 2

Step 3: On the card File -> Save As .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 3

Step 4: A dialog box appears and select Browser to select a folder to save the file.

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 4

Step 5: A dialog box appears -> name the file, under Save as Type -> PDF . Finally, click Save .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 5

The result after merging 3 sheets into 1 PDF file:

Good luck!