Click the arrow on the lower-right corner of the Page Setup section, then click on the Header/Footer tab. Sheets that are saved in portrait tend to have columns that fall outside of the final print area, which can make your document very difficult to navigate and read.Īdditionally, you can add a header and footer to your final layout. Take note that most Excel spreadsheets are more readable in landscape orientation than in portrait, unless you have very few columns. These work mostly the same as they do in a Word document, so set them based on how you want your finished PDF to look like.
If you’re using Office 2008 or later, navigate to the Page Layout tab.
Here’s how to turn your spreadsheet into a presentable and printable PDF document. Your file should be readable and understandable, without random stray columns on other pages or cell sizes that are too small to read.
However, when it comes to turning these files into PDF documents that can be read, printed, or distributed to others, it’s something that you should be conscious of.
We often don’t think of Excel spreadsheets as documents with borders, pages, and margins. However, converting an Excel file to a PDF can be a bit tricky. For example, if you wish to send out only a specific portion of a larger sheet, or you don’t want it to be editable. There are many scenarios when you may want to save an Excel document as a PDF file instead of a spreadsheet.