Excel in Depth - Page Layout View: Podcast #1268

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 Oct 18, 2010.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,484
Messages
6,113,920
Members
448,533
Latest member
thietbibeboiwasaco

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