Start learning with our library of video tutorials taught by experts. Get started

Excel 2010 New Features
Illustration by Neil Webb

Making printing easier


From:

Excel 2010 New Features

with Bob Flisser

Video: Making printing easier

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.

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
Excel 2010 New Features
1h 51m Appropriate for all May 12, 2010

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.

Topics include:
  • Using the Slicer feature for dynamic PivotTable filtering
  • Sharing workbooks via e-mail, the Excel Web App, and SharePoint
  • Using Paste Preview for more effecient copying and pasting
  • Inserting Sparklines to see patterns in data
  • Taking advantage of enhancements to the Conditional Formatting feature
  • Analyzing data from multiple sources using the PowerPivot for Excel add-in
  • Maintaining file compatibility with older versions
Subject:
Business
Software:
Excel
Author:
Bob Flisser

Making printing easier

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.

Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2010 New Features.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

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.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked