So if I just hit that button now what I would see on my printer is what’s on the right. There is a big Print button there which would do the equivalent of what that Quick Print button does on the Quick Access Toolbar.
Now first of all on the right I have a preview of how my print would look if I just hit Print now. 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. 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’ll explain what I mean by that in a moment. But in your case it will give the name of either your printer or some other option for printing. If you have the Quick Print button enabled on your Quick Access Toolbar you should see a Tool Tip similar to that. 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.
So one very quick option for printing is on the Quick Access Toolbar if you’ve got this button enabled. And then you have the option of selecting some specific features for printing and making the print happen in a certain way. 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. I’d just have to do one or two things to achieve that. So if I wanted to print those empty columns I could. Having said that you also can have very tight control over what is printed. 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. It doesn’t print sort of thousands of columns and thousands of rows that are empty. 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. 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.
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. 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. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners.
0 kommentar(er)
