Look Who it Was Random video

Excel - Scale Worksheet to Fit when Printing - Episode 1192

1,596 views · Published 18 March 2010 · 2:27 · Indexed 26 September 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Scale Worksheet to Fit when Printing.

Welcome back to the MrExcel netcast! In this episode, we're tackling a common issue faced by many Excel users - fitting data onto one page. Our viewer, Mary, reached out to us for help and we're here to share some tips and tricks to make this task easier.

First off, we'll be using the new Page Layout View in Excel 2007. This view allows you to see where the page breaks will be, making it easier to adjust your data accordingly. To access this view, simply click on the Page Layout button next to the Zoom slider.

Now, let's say you've adjusted the page orientation and margins, but your data still won't fit on one page. This is where the Scale to Fit feature comes in handy. By selecting "Fit to 1 page wide" in the Page Layout section, you can fit about 36 rows of data onto one page. However, be careful when using this feature as making columns wider will result in smaller font sizes.

To avoid this issue, we recommend using the Page Layout view to adjust your data and then changing the orientation and margins to fit everything onto one page. You can also customize the margins to your liking, just like in Excel 2003. These simple tricks will save you time and frustration when trying to fit data onto one page.

Thank you to Mary for sending in this question and thank you for tuning in to another netcast from MrExcel. See you next time!

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) Question from Mary about fitting data on one page
(00:16) Using Page Layout View to see page breaks
(00:28) Adjusting orientation and margins to fit data
(00:47) Using Scale to Fit for width, but be careful with font size
(01:41) Benefits of Page Layout View and adjusting margins
(02:08) 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:
Adjusting column width in Excel
Custom Margins in Excel
Excel 2007 Page Layout View
Excel Margins Narrow
Excel Orientation Landscape
Excel Page Break Preview
Fit data on one page
Fit to 1 page wide in Excel
Scale to Fit in Excel
Tips for fitting data on one page in Excel
Using Page Layout view in Excel


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

Mary asks about how to force a report to fit to one page wide. Episode #1192 takes a look at Layout mode, Scale to Fit, and orientation.

More from this channel