Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Making printing easier

From: Excel 2010 New Features

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.

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.

Show transcript

This video is part of

Image for Excel 2010 New Features
Excel 2010 New Features

25 video lessons · 10750 viewers

Bob Flisser
Author

 

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

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.


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.

Join now "Already a member? Log in

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
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.