Excel 2007 introduced the new Page Layout View. Take a tour of this view.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 36 - Page Layout View!
Well, you know I always joke with Excel 2007, they said “All of the commands will always, always, always be at the top of the screen.” Every command at the top of the screen, you'll never have to look for floating commands, except these three commands at the bottom.
OK, and you might remember something called Page Break Preview mode, Page Break Preview in Excel 2003 had this weird thing with the blue lines, that show where the page breaks were going to be.
Was never a fan of that, it just takes up a lot of memory.
What is really new, though, here in Excel 2007 in Excel 2010, is Page Layout View.
I have to tell you, I really like page layout view, because it shows me my worksheet.
It shows me where the margins are going to be, it shows me where the headers and footers are going to be, and if I scroll outside the used region, I can still keep adding more data.
It's not like it's grayed out on there, it welcomes me to add more data.
A few things you can do, you see that there's three zones up here for a header, and then three zones at the bottom for footers, and you can click in any of those to edit.
When you do that, you're going to get a brand new tab, the Header & Footer tab, so this offers a variety of canned(?) headers, or you can build your own as before.
Alright, so Page Layout View, brand new in Excel 2010.
If you're looking up here, you know, in the ribbon it's there under View, but it's always available with these three icons down at the bottom.
The first one is Normal, second one, Page Layout, third one, the old Page Break Preview.
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 36 - Page Layout View!
Well, you know I always joke with Excel 2007, they said “All of the commands will always, always, always be at the top of the screen.” Every command at the top of the screen, you'll never have to look for floating commands, except these three commands at the bottom.
OK, and you might remember something called Page Break Preview mode, Page Break Preview in Excel 2003 had this weird thing with the blue lines, that show where the page breaks were going to be.
Was never a fan of that, it just takes up a lot of memory.
What is really new, though, here in Excel 2007 in Excel 2010, is Page Layout View.
I have to tell you, I really like page layout view, because it shows me my worksheet.
It shows me where the margins are going to be, it shows me where the headers and footers are going to be, and if I scroll outside the used region, I can still keep adding more data.
It's not like it's grayed out on there, it welcomes me to add more data.
A few things you can do, you see that there's three zones up here for a header, and then three zones at the bottom for footers, and you can click in any of those to edit.
When you do that, you're going to get a brand new tab, the Header & Footer tab, so this offers a variety of canned(?) headers, or you can build your own as before.
Alright, so Page Layout View, brand new in Excel 2010.
If you're looking up here, you know, in the ribbon it's there under View, but it's always available with these three icons down at the bottom.
The first one is Normal, second one, Page Layout, third one, the old Page Break Preview.
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
