Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Convert Multiple Excel Sheets to a Single PDF File Manually

From an earlier post we learnt how to convert one excel sheet to a PDF manually. If you want to know how, then please check this post.

Save an Excel Sheet as PDF

This Excel tutorial explains how to convert multiple sheets from your excel workbook to a one single PDF file manually. So you can convert sheets you wish from your excel file to a one PDF file. Assume we have an Excel file with 5 sheets like this.

If we want to convert only Sheet 1 and Sheet 3 to one PDF file, then these are the steps we need to follow.

First we need to select Sheet 1 and Sheet 3. You can select multiple sheets from excel file by clicking on sheet names while pressing Ctrl key on your keyboard.

Now we have selected Sheet 1 and Sheet 3. Next we need to click on the “File” menu.

Then click on the “Save as”

Next click on the “Browse”

It will open the “Save as” dialog box like this.

Now browse for the folder you want to save the file. Next enter a suitable name to the “File name” field. After that click on the “Save as type” dropdown. Select PDF from the list.

Once you select the PDF from the list, Save as dialog box will show you some more options. So click on the “Options” button at the bottom.

When you click on that button, “Options” window will open like this. Then make sure that the “Active sheet(s)” option is selected under the “Publish what” section.

Now click ok. It will close the “Options” window. Then click the “Save” button in the “Save as” dialog box. Selected sheets will be converted to a one pdf file successfully. So this is how we can convert multiple excel sheets to a one PDF file manually. Also you can convert an entire workbook to a single PDF file as well. Check this post if you want to know how.

Convert an Entire Workbook to a Single PDF File

Contact Form


Email *

Message *