Learn how to fit all your columns and rows on to one page in Excel, INCLUDING why Page Break’s not working. Scaling your data to suit your printout requirement can save a lot of time, and a lot of paper! In this tutorial you will learn how to fit your Excel sheet on one page for printing. You’ll also learn why Insert, Page Break may not be working.

Timestamps:
mm:ss
00:00 How to print Excel spreadsheet on one page
01:42 Using the Show Margins preview to adjust the margins and column widths
02:32 Scaling the Excel worksheet to print to only one page
03:18 Adjusting the Scaling options
03:57 Understand why Insert, Page Break isn’t working
05:13 Adjust the print area using the Page Break Preview

Topic #41 in the ‘Steps to becoming Proficient in Excel’ workbook.

Read the full text article here: https://www.excelatwork.co.nz/2021/05/05/how-to-print-excel-spreadsheet-on-one/

Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/

VERSION FRIENDLY
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork

Please take the opportunity to connect and share this video with your friends and family if you find it useful.