Printing from Excel - 3 useful things to know Windows 11 - What You Need To Know Previous Article Latest Azure Certifications Next Article Tips for helping data fit on one page, or better manage how it looks across multiple pages. Printing from Excel - 3 useful things to know When printing from excel, there are common issues that arise. The most common is having data fit on one page, or better manage how it looks across multiple pages. Before printing anything from excel, check these 3 things to reduce multi-page issues. 1: Check your paper size The US standard for excel is Letter size. If you are printing in Europe the standard paper size in your devices is the ‘A’ system. Often A4. On the Layout Ribbon, check your paper size is changed from Letter to A4 2: Optimize the fit of your data Over time the amount of space used up by different columns or rows in excel can drift. To give your data it’s ‘best fit’. Click the triangle between col A and row 1 to highlight whole sheet. On the home ribbon, choose the format dropdown and auto fit column widths and/or heights 3: Turn on ‘Print Titles’ This feature ensures that if data does need to be spread across a few sheets that the headings of the data are repeated as needed. To create print titles. Select the Page Layout Ribbon Click on the Print Titles button Select the Rows to Repeat at Top field Point to the left of the row you want to use as a Print Title. The cursor changes to an arrow. Select the row. The reference is added to the Rows to repeat at top field. Select OK. Happy Exceling! Popular Excel Courses Essentials & Basic Formulas Functions Including Pivot Tables Automating Excel with Macros & Analysis tools Excel VBA View all Excel Courses Wednesday, October 27, 2021 / Author: Liam Phelan / Number of views: 936 / Comments: 0 / Print Categories:ExcelMicrosoft Office Tags:Excel Related articles Data Visualisation with Excel & Power BI How to Import Data from PDF into Excel Excel Tips and Tricks from our Experts Excel Courses for Advanced Users Our Best Excel Quick Tips & Shortcuts