Viewers: in countries Watching now:
In Excel 2010 New Features author Bob Flisser demonstrates the powerful new characteristics and capabilities in Excel 2010. This course covers Excel's Backstage view, improved sharing and collaboration capabilities, its graphics features, and enhanced data analysis and visualization tools. Exercise files accompany the course.
Printing is an easier task in 2010 and the previous versions, and of all of the features that Microsoft changed in this version, this one really went through some of the biggest changes. I think it's really for the better. Now, to get to printing, fairly easy, you can go to the File tab here, and then go down to Print. I'm just going to escape out of here, because you can also press Ctrl+P, and that's something that hasn't changed in years and years. So notice more than half of the screen is taken up by Print Preview.
Now, I think that is really great, because in the 2007 version nobody really knew where the Print Preview screen was. And in the older versions, the Print Preview screen wasn't really very useful. It was there, but couldn't really do very much. So here what they are doing is they're putting this Print Preview right in the same screen as Printing. So let's go through some of the options that are here. This is your default Printer. If you have other printers configured and you want to choose them, you can simply choose any other printer that you have, or if you have Adobe Acrobat and whatnot.
If you want to get to printer-specific properties, then you can click here on this Printer Properties link, and this brings you into the properties that are specific to your printer. So if you have an HP LaserJet 4200, you're going to see this particular screen. If you have another printer, a Canon, or Lexmark, you are going to see other screens. So this is kind of handy to have. You might also decide okay, what part of this workbook do I want to print? And if you click this dropdown, you can choose, well just the one sheet if have active, if you have multiple sheets that are active, or you can Print Entire Workbook or the Selection.
None of that is really changed, but the way they present it to you has changed a lot. If you going to print multiple copies, you can Collated or not Collated. Now, here's something else, before we look at this Orientation. Let's go over here to Page Layout, and this is something also they change in this version. I think it's - well, long overdue, but it's a great feature here. Under Orientation, you see this is Landscape. Now, let's go back. I'll just press Ctrl+P and come back in here. Now this is Landscape Orientation. Well, what you used to happen in old versions is you might have Landscape set up in the document, Portrait set up here in the Print dialog box, and then when you print, you might get half the stuff cut off, or you are not seeing things on the page the way you expect them to be.
When I change this to Portrait here, and I go back to Page Layout here and go to Orientation, check it out; it changes to Portrait. So this is a really great feature, and of course, we can do this a reverse. If I go here and choose Landscape - I'll just press Ctrl+P again - here it's back to Landscape. So it changes to what you want instead of having the two parts of the program fighting with each other, which is great. And here, what Paper Size do you want? Kind of self-explanatory. Do you want Letter Size, Legal size and so on.
I'll leave it with that. And with Margins also this has different options for margins, and I am just going to leave the default there. Now Scaling, they have this also in previous versions, but they made this a little easier, as well. Scaling, do you want it to Fit to a Page, do you want it Fit to One Page wide or one page tall and so on. And again, this is the small worksheet, so I am going to leave No scaling here. Now, maybe you're feeling a little nostalgic, and you like the old method of spelunking through all of these multiple levels of dialog boxes to print.
Well, you can still do that. Go down here to Page Setup, and here is the old-fashioned Page Setup dialog box, and there's everything that we have here, but just in this less intuitive interface: Portrait and Landscape, here's your Scaling, Margins. We had all that on there. Headers/Footers, oh God! You don't have to do this anymore, do you? But you can still do it if you want. And go to the Sheet tab and Print titles and all these you can do it in easier ways in Excel. So I am just going to cancel out, and that's really all there is to it.
Once you're here and you decide how many copies you want, choose how many copies you want and then click Print and your worksheet has then printed out.
There are currently no FAQs about Excel 2010 New Features.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.