Look Who it Was Random video

Excel - Fit To One Printed Page Using Page Layout View - Episode 1192

1,591 views · Published 24 March 2010 · 2:27 · Indexed 17 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Fitting Data onto One Page | Adjusting Margins, Orientation, and Scale to Fit.

Welcome back to the MrExcel netcast! In this episode, we'll be discussing a question sent in by Mary about fitting data onto one page. I suggested using the new Page Layout View in Excel 2007, which can be found next to the Zoom slider. This view allows you to quickly see where the page breaks will be, making it easier to adjust your data accordingly.

Mary's data was too wide to fit on one page, so we changed the orientation to Landscape and adjusted the margins to Narrow. This helped fit the data onto one page, but Mary needed more room for certain columns. This is where the Scale to Fit feature comes in. By selecting "Fit to 1 page wide" in the Page Layout section, we were able to fit about 36 rows of data onto one page.

However, it's important to be careful when using Scale to Fit. As you make columns wider, the font will become smaller and eventually unreadable. So, it's best to use this feature sparingly and only when necessary. Another helpful tip is to use the Custom Margins option to adjust the top and bottom margins if needed.

Overall, the Page Layout View is a great tool for working with data while also being able to see where page breaks will occur. And with the ability to change orientation and margins, it's easier than ever 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! Don't forget to check out our sponsor, MrExcel.com, for all your Excel needs. 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) Using Page Layout View
(00:28) Adjusting Orientation and Margins
(00:47) Using Scale to Fit for Width
(01:09) Potential Issues with Scale to Fit
(01:41) Benefits of Page Layout View
(02:00) Customizing Margins
(02:10) 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 margins in Excel
Changing orientation in Excel
Customizing margins in Excel
Editing margins in Excel 2003
Excel 2007 Page Layout View
Excel Page Break Preview
Fit data on one page in Excel
Font size when using Scale to Fit in Excel
Making columns wider in Excel
Scaling 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/1152802/

More from this channel