Select a sheet or multiple sheets you want to set the DPI for. To set the same Page Setup options for all individual Excel sheets: In Excel, the printed page will be landscape but your original Excel Resulting file, so for example if you set the page layout to landscape PDF file (not multiple PDFs) you need to set the same page setup optionsįor all of them (page setup in Excel modifies the print size of the In order to have all the individual sheets printed within a single Individual sheets have different page setups, so it sends them as
Happens because multiple sheets in your workbook have different dpi settings for printing. If you have multiple/individual sheets within your Excel workbook, when you try to create a PDF and choose to print the Entire Workbook, you will receive a PDF file containing only part of the Excel document or each sheet will be saved as a different PDF file.