Did you know that you can convert an entire Excel workbook to a single PDF. In this post I will teach you how to do that. First open your excel workbook. And the click on the “File” menu.
Then click on the “Save As” and browse for the folder.
Save As dialog box will open like this.
Give a suitable name for the PDF file from the file name field. And select PDF from the save as type field.
When you select the PDF, few more options will be available at the bottom of the Save As dialog box. Click on the options button.
When you click on the Options button excel will open Options window. Select entire workbook option from “Publish what” section (Default setting is Activesheet(s)). Then click OK. Options window will be closed.
Now click on the “Save” button of the “Save As” dialog box. Excel will convert all the tabs in the Excel workbook to a single PDF file.
