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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920