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.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Rev Up to Excel 2010, Chapter 7, Custom Margins.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Chapter 7 of the Rev Up to Excel 2010 book talks about Page Layout view but in this episode of the podcast I'm not going to cover that.
I think we've covered that before for the other books.
I want to talk about when you're setting Custom Margins specifically, you know, your favorite margins, every single time that I have a new workbook, let's just to do Control+N, I go into the Page Setup, I go back to the Margins tab and these margins, these default margins are always too wide. I'm trying to fit as much data as I can, going across the spreadsheets so always go to a quarter of an inch on the left and the right, I'm sure it's wrong according to my high school English teacher but I put a quarter of inch margin at the top. On the bottom I reluctantly go to have an inch because I need the footer to be at a quarter of an inch and those are my favorite margins...
every single time. I find that I always do that use the dialog launcher and go in and do that.
Well hey, I'm going to encourage you to avoid the dialogue launcher in this particular case because what I'm going to suggest is that after you have created those favorite margins and those are the margins you use all the time. The next time you have a spreadsheet, I'll just do Control+N again to get another workbook here. Now, you can go into that Margins drop down and where they used to offer Normal, Wide and Narrow, they now offer Last Custom Setting and check that out it's all of the settings that I had previously, choose that and we're good to go, we don't have to go through and visit the Page Setup dialog anymore, one click no two click access to your...
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Rev Up to Excel 2010, Chapter 7, Custom Margins.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Chapter 7 of the Rev Up to Excel 2010 book talks about Page Layout view but in this episode of the podcast I'm not going to cover that.
I think we've covered that before for the other books.
I want to talk about when you're setting Custom Margins specifically, you know, your favorite margins, every single time that I have a new workbook, let's just to do Control+N, I go into the Page Setup, I go back to the Margins tab and these margins, these default margins are always too wide. I'm trying to fit as much data as I can, going across the spreadsheets so always go to a quarter of an inch on the left and the right, I'm sure it's wrong according to my high school English teacher but I put a quarter of inch margin at the top. On the bottom I reluctantly go to have an inch because I need the footer to be at a quarter of an inch and those are my favorite margins...
every single time. I find that I always do that use the dialog launcher and go in and do that.
Well hey, I'm going to encourage you to avoid the dialogue launcher in this particular case because what I'm going to suggest is that after you have created those favorite margins and those are the margins you use all the time. The next time you have a spreadsheet, I'll just do Control+N again to get another workbook here. Now, you can go into that Margins drop down and where they used to offer Normal, Wide and Narrow, they now offer Last Custom Setting and check that out it's all of the settings that I had previously, choose that and we're good to go, we don't have to go through and visit the Page Setup dialog anymore, one click no two click access to your...
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
