Clear, practical technology insights About · Contact

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.

Author: Micah Soto1 minutes read

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

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

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

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

images 1 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 1 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 1 of How to merge multiple sheets into 1 PDF file in Excel 2013

The result after merging 3 sheets into 1 PDF file:

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

Good luck!

Was this article helpful?

Your feedback helps us improve.

Discussion

Reader Comments 0

Sign in with email or Google to join the discussion.