Excel Rev Up - My Favorite Margins: Episode 1285

610 views · Published 10 November 2010 · 1:58 · Indexed 12 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Setting Custom Margins in Excel.

Welcome back to the MrExcel podcast. In this episode, we're diving into Chapter 7 of the Rev Up to Excel 2010 book, where we'll be discussing Custom Margins. Now, I know we've covered Page Layout view in previous episodes, so today we're going to focus specifically on setting your favorite margins.

Whenever I start a new workbook, I always find myself going into the Page Setup and adjusting the margins to fit as much data as possible on the spreadsheet. I prefer a quarter inch margin on the left and right, and a quarter inch at the top, even though my high school English teacher may not approve. However, I do have to reluctantly go to half an inch at the bottom to accommodate the footer. These are my go-to margins, and I find myself using them every single time.

Now, instead of going through the Page Setup dialog every time, I have a handy shortcut for you. After you've set your favorite margins, the next time you start a new spreadsheet, simply go to the Margins drop down and select "Last Custom Setting". This will automatically apply your preferred margins without having to go through the dialog again. It's a simple two-click process that will save you time and hassle in the long run.

Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe and hit the notification bell to stay updated on all our latest episodes. We'll see you next time 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) Custom Margins in Excel
(00:15) Setting Custom Margins 
(00:30) Favorite Margins 
(01:00) Avoiding the Dialog Launcher 
(01:20) Using Last Custom Setting 
(01:30) 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:
Chapter 7
Custom Margins
Dialog launcher
Last Custom Setting
Margins tab
Page Layout view
Page Setup
Page Setup shortcut
Rev Up to Excel 2010
Spreadsheet margins


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


Chapter 7 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" is all about the 'Page Layout View'  introduced in Excel 2007. Today, in Episode #1285, Bill is going to focus on Excel 2010's ability to remember the 'Last Custom Margins' used.

More from this channel