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.
0 kommentar(er)
