Excel 2007 introduced 'Page Layout View' and it has carried over to Excel 2010 - haven't seen it yet? In Episode #1268, Bill demonstrates the attributes of Page Layout View in Excel 2010. ..."Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
This Excel 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 screen.
You'll never have to look for the floating commands.
Except these three commands at the bottom, okay?
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 at, was never fan of that.
You just take up a lot of memory.
What is really new though here in Excel 2007 and 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. I'm not.
It's not like it's great out 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 gonna 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.
All right, so page layout view brand new in Excel 2010. If you're looking up here, you know in the...
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 region.
Oh hey, I wanna thank you for stopping by. See you next time for another netcast with 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 screen.
You'll never have to look for the floating commands.
Except these three commands at the bottom, okay?
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 at, was never fan of that.
You just take up a lot of memory.
What is really new though here in Excel 2007 and 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. I'm not.
It's not like it's great out 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 gonna 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.
All right, so page layout view brand new in Excel 2010. If you're looking up here, you know in the...
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 region.
Oh hey, I wanna thank you for stopping by. See you next time for another netcast with MrExcel.
