Excel - How to Print to One Page - No more taping sheets together! - Episode 1569

2,694 views · Published 3 July 2012 · 3:19 · Indexed 16 November 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: Print to One Page
Welcome back to the Don't Fear the Spreadsheet podcast, where we tackle all your Excel questions and make you an expert in no time. I'm Bill Jelen, also known as MrExcel, and in today's episode, we'll be discussing how to print a report to one page wide.

Our question comes from Tyler Nash, who is having trouble with his report printing on multiple pages. The left half of the report prints on pages one through three, while the right half prints on pages four through six. This can be a frustrating issue, but fear not, Tyler, we have a simple solution for you.

In the past, I've seen people resort to using scotch tape to piece their report together, but that's not a practical or efficient solution. Instead, we can use the Scale to Fit feature under the Page Layout tab. By selecting "1 page wide," we can force everything to fit on one page. In older versions of Excel, this setting would also shrink the report to fit on one page, but in Excel 2007 and 2010, it simply adjusts the width while keeping the height as is.

If you're using Excel 2007, you can also use the little round icon in the top left corner and select Print and Print Preview to see the page breaks. In Excel 2010, you can go to File and then Print to see the print preview. This will show you where the page breaks are and allow you to adjust the width accordingly. It's important to note that the page breaks are not just there to show you the center of the report, but rather to indicate where the report will be split into multiple pages.

So, the next time you're struggling with printing a report to one page wide, just remember to use the Scale to Fit feature and adjust the width to 1 page. And if you're new to spreadsheets, be sure to check out my book "Don't Fear the Spreadsheet," which is designed for beginners and will make Excel for Dummies look like it was written for rocket scientists. Thanks for tuning in, and don't forget to subscribe for more Excel tips and tricks.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Print to One Page Wide
(00:35) Left and right halves of report printing on separate pages
(01:04) Using the Page Layout tab to adjust settings
(01:14) Setting to fit to 1 page wide
(01:46) Displaying page breaks
(02:05) Using print preview to see page breaks
(02:32) Misconceptions about page breaks
(02:56) Solution to printing issue
(03:06) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Displaying page breaks
Don't Fear the Spreadsheet
Don't Fear the Spreadsheet book
Episode 5
Excel 2003 vs 2007/2010
Page Layout tab
Print to One Page Wide
Scale to Fit
Spreadsheet printing problem


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153379/

You've tried Printing your Report from the Excel Workbook that you've toiled over and instead of one neatly arranged and printed page, you've ended up with several pages of cut off Data! Now what? Tape? Staples? And will my Reports always print like this? How can I get all of my Data to Print on one page? Follow along with Episode #1569 to learn how to change your Settings, display 'Page Breaks' and end up with the result you really want to achieve.

"Don't Fear The Spreadsheet: A Beginner's Guide To Overcoming Excel's Frustrations" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen http://www.mrexcel.com/dftss_home.html

"This Book Makes Excel For Dummies™ Look Like It Was Written For Rocket Scientists!"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel