Today, in Episode #1290, Bill looks at Chapter 8 of his book, ""Rev Up to Excel 2010: Upgraders Guide to Excel 2010" where the topic is Print Preview in Excel 2010 - Find it; Use it; Tweak it!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Rev up to Excel 2010, Chapter 8, Print Preview.
Hey, welcome back to MrExcel netcast.
I'm Bill Jelen.
People switch over to Excel 2010, one of the first questions they have is well, where the heck is Print Preview, and to get to Print Preview have to go to the backstage view File, and then choose Print and Print Preview is over there on the right hand side.
Now, there's some good things about having Print Preview here in backstage view because you could change various settings you can go from portrait orientation to landscape orientation or you know, change from normal margins to wide margins and see what that's going to look like right on the page.
All right! So, you know, that's good and the buttons that used to be in Print Preview.
So, you can make the screen smaller here the buttons that used to be in Print Preview are still there, you can turn on the margins or you can zoom in.
So, we have those same buttons that we had before, but if you really just want Print Preview, you're going to have to add it to the quick access toolbar.
So, right click, Customize Quick Access Toolbar on the left hand side choose All Commands.
It's not in popular commands and we go down to.
Now, there's two of them, be careful we're going to go down to Print Preview Full Screen, that's the old one that we know and love, click Add, click OK.
And now, you have print preview full screen brings up the whole screen print preview like we had before.
All right! So, a couple of try it in the backstage view, but if you just don't like it particularly in landscape, it doesn't look that well you'll want to use print screen fulls or print preview full screen, pick up you'll want to use print preview full screen.
Now, chapter 8 is all about keyboard shortcuts.
So, let me give a keyboard shortcut tip here if you're a big fan of doing Alt+F1, in order to get the most recent file Alt+F1 to open the most recent file.
Let me do that again slow Alt+F, see it gives us one, two, three, four, that's not turned on by default.
That's another setting at the bottom of the recent pane, go down there and say quickly access this number of recent workbooks and you can scroll up to five or six or seven, Alt+F1 through F5 or Alt+F1 through Alt+F5 will work.
There you have a couple of different tips as we're finishing up the new Excel 2010 interface as we go further through the book will get through some of the great new features in Excel 2010.
I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Rev up to Excel 2010, Chapter 8, Print Preview.
Hey, welcome back to MrExcel netcast.
I'm Bill Jelen.
People switch over to Excel 2010, one of the first questions they have is well, where the heck is Print Preview, and to get to Print Preview have to go to the backstage view File, and then choose Print and Print Preview is over there on the right hand side.
Now, there's some good things about having Print Preview here in backstage view because you could change various settings you can go from portrait orientation to landscape orientation or you know, change from normal margins to wide margins and see what that's going to look like right on the page.
All right! So, you know, that's good and the buttons that used to be in Print Preview.
So, you can make the screen smaller here the buttons that used to be in Print Preview are still there, you can turn on the margins or you can zoom in.
So, we have those same buttons that we had before, but if you really just want Print Preview, you're going to have to add it to the quick access toolbar.
So, right click, Customize Quick Access Toolbar on the left hand side choose All Commands.
It's not in popular commands and we go down to.
Now, there's two of them, be careful we're going to go down to Print Preview Full Screen, that's the old one that we know and love, click Add, click OK.
And now, you have print preview full screen brings up the whole screen print preview like we had before.
All right! So, a couple of try it in the backstage view, but if you just don't like it particularly in landscape, it doesn't look that well you'll want to use print screen fulls or print preview full screen, pick up you'll want to use print preview full screen.
Now, chapter 8 is all about keyboard shortcuts.
So, let me give a keyboard shortcut tip here if you're a big fan of doing Alt+F1, in order to get the most recent file Alt+F1 to open the most recent file.
Let me do that again slow Alt+F, see it gives us one, two, three, four, that's not turned on by default.
That's another setting at the bottom of the recent pane, go down there and say quickly access this number of recent workbooks and you can scroll up to five or six or seven, Alt+F1 through F5 or Alt+F1 through Alt+F5 will work.
There you have a couple of different tips as we're finishing up the new Excel 2010 interface as we go further through the book will get through some of the great new features in Excel 2010.
I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
