Excel in Depth 36 - Page Layout View

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 14, 2010.
Excel 2007 introduced the new Page Layout View. Take a tour of this view.
maxresdefault.jpg


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!
 

Forum statistics

Threads
1,213,557
Messages
6,114,288
Members
448,563
Latest member
MushtaqAli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top