There are two ways you can convert an Excel file to a PDF. Any change you make will be added to your final, converted Excel to PDF document.

In the Page Setup window, change any of the available options listed under the Print and Print Titles sections. You can also make further changes to your final Excel layout by pressing the Print Tiles button. You can also change the overall scale percentage (the amount of space the print area will use to fill up a page) using the Scale option box provided. Select a number of rows or columns within your print area, then set the Width or Height options under the Page Layout > Scale to Fit section to 1 page. If you have a vast amount of data in your print area (for instance, with a large number of rows or columns), you can change how many of them appear on a single page. With the data selected, click Page Layout > Print Area > Set Print Area. Select the columns and rows you wish to see in your PDF file using your mouse. Setting this also allows you to select the data you wish to save to your PDF file if you choose to print to a PDF file directly. When you select a print area in Excel, you determine the cells you wish to print. A4 is recommended in most cases as a common size to allow for printing. Press the Size button and select one of the page sizes from the drop-d0wn menu. These are based on typical physical paper sizes. The page size will have the biggest impact on how much Excel data you can fit onto a single page. You can do that by pressing the Orientation button and selecting one of the options available.

If you have a large number of columns, you may wish to switch this to Landscape instead. You may do this if you want less (or more) white space around the edges of your data.īy default, Excel is set to a Portrait page orientation. While the default page margins should be acceptable, press the Margins button and select one of the available options in the drop-down menu if you want to change them. All four elements can impact how your Excel file is displayed when converted to a PDF. To start, open your Excel spreadsheet and press the Page Layout tab on the ribbon bar.įrom here, you can determine the page margins, orientation, size, and overall print area. That’s why changing the page layout in Excel is the first thing you’ll need to do before you can save it as a PDF file. As a PDF is a document format that displays content across pages, it’s important to ensure that your Excel data can easily be displayed without the layout being broken. While page layouts and margins aren’t usually visible in Excel, they do exist. To save an Excel spreadsheet as a PDF, here’s what you need to do. Excel files, with its cell grid structure, have to be set up in a way that allows the data to be presented without losing its layout.

Kutools excel won't print to pdf