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.

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.

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

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

images 2 of How to merge multiple sheets into 1 PDF file in Excel 2013
Images 2 of How to merge multiple sheets into 1 PDF file in Excel 2013

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

images 3 of How to merge multiple sheets into 1 PDF file in Excel 2013
Images 3 of How to merge multiple sheets into 1 PDF file in Excel 2013

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

images 4 of How to merge multiple sheets into 1 PDF file in Excel 2013
Images 4 of How to merge multiple sheets into 1 PDF file in Excel 2013

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

images 5 of How to merge multiple sheets into 1 PDF file in Excel 2013
Images 5 of How to merge multiple sheets into 1 PDF file in Excel 2013

The result after merging 3 sheets into 1 PDF file:

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

Good luck!

3.8 | 6 Vote
« PREV : How to insert math...
How to convert dots... : NEXT »