Save as pdf button excel

If you have multiple individual sheets within your Excel workbook, when you try to create a PDF and choose to print the Entire Workbook, each sheet will be saved as a different PDF file. Because of this, Excel assumes that each individual sheet has to be sent for printing separately, so it will send save as pdf button excel in the same way to the PDF printer which will prompt to create a PDF from each sheet. DPI printing value for all of them.


You will have to repeat these steps for each individual sheet in your workbook. However, if you have the same printing settings for each sheet in the workbook, you can change the Page Setup options for all sheets at once. Set the Print Quality to the DPI value you want and press OK so that Excel will record the fact that all pages have the same print settings. It’s important to press the OK button even if you don’t change anything, because this will “tell” Excel that all the sheets have the same page setup options.

Click on File then Print and see if you like the way the pages will show when printed to PDF. If you don’t have any changes to the printing options select the Print Entire Workbook option under Settings and novaPDF from the Printer name section and click Print to create the PDF file. Excel sheets printed to a single PDF would be to use novaPDF’s own merge option.

This will let you print the first sheet to a PDF document and after that print all the other sheets in that workbook to the same pdf. Legal Notices Terms of Use Support Policy Sitemap Forum Copyright Softland 2005 – 2017. This tutorial shows sample code for doing this. When the macro starts, it sets variables for the active sheet, and the active workbook.

Those will be used to set the default file name and folder. A time stamp will be added to the default name, in the format yyyymmdd_hhmm. In the format string shown below, a backslash is entered before the underscore, to indicate it is a literal character. Otherwise, Excel would interpret the underscore as the spacing character that is used in Excel number formatting.

scroll to top