Buzz
When using Office versions before 2007, you needed to install an additional Add-On to convert to PDF. However, with Office 2013, you can easily merge multiple sheets in Excel into one PDF file with just a few simple steps.
Step 1: Open the Excel file containing the data you want to merge. For example, here we have 3 sheets named 1, 2, 3.
Step 2: Right-click on any sheet and select Select All Sheets.
Step 3: Go to the File tab -> Save As.
Step 4: A dialog box appears, select Browser to choose the folder to save the file.
Step 5: A dialog box appears -> name the file, in the Save as Type section -> PDF. Finally, click Save.
The result after merging 3 Sheets into 1 PDF file:
Wishing you all success!
