Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, learn how to print from Excel and the different print options in Microsoft Excel 2016.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016.
In this section we’re going to take a look at printing and the time is almost certain to come when you’re going to want to print out one or more of your worksheets. And one important point I need to make at the outset is that exactly what you can do when you’re printing will to some extent depend on your printer. Now modern printers attached to most people’s home or work PCs tend to be very capable but if you have an older printer then some of the things that I’m going to talk about in this section may not be possible for you.

Now the first thing I want to point out is that when you print something, supposing I just printed this worksheet, the top 50 movies worksheet, what Excel prints by default is just the content of the cells that have got something in them. It doesn’t print sort of thousands of columns and thousands of rows that are empty. So you don’t have to worry too much about thinking well if I hit the Print button am I going to get all this empty stuff printed as well. Having said that you also can have very tight control over what is printed. So if I wanted to print those empty columns I could. I’d just have to do one or two things to achieve that.

Now the next thing to point out is that as with many other things related to Excel there is a sort of default, straightforward, one click version and that’s what we’re going to look at first. And then you have the option of selecting some specific features for printing and making the print happen in a certain way.

So one very quick option for printing is on the Quick Access Toolbar if you’ve got this button enabled. You will see that mine says Quick Print and then in brackets afterwards it gives the name of the device that it would print this worksheet to if I just clicked this Quick Print button. If you have the Quick Print button enabled on your Quick Access Toolbar you should see a Tool Tip similar to that. But in your case it will give the name of either your printer or some other option for printing. I’ll explain what I mean by that in a moment.

So one option is to click and it will print but that’s not quite the option I’m going to go for because what I’m actually going to do is to go into Backstage View and then go to the Print Page because I want to explain some of the settings on the Print Page. I very rarely just hit the Quick Print button because I almost always need to check the Print Settings on this page in Backstage View.

Now first of all on the right I have a preview of how my print would look if I just hit Print now. There is a big Print button there which would do the equivalent of what that Quick Print button does on the Quick Access Toolbar. So if I just hit that button now what I would see on my printer is what’s on the right. Just below and to the left of the page on the right there is a little Page Control. So it currently says Page 1 of 2, current page. So it means I would see two pages. There are just four movies on the second page. Most of them fitted on the first page. So I probably wouldn’t like that anyway. I’d probably want to squeeze everything onto one page but I’ll come back to that in a moment.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.