Let's start off with some useful printing options.
So let's say.
I have this report, I want to get it printed.
First thing I'm going to do is to take a look at it in print preview.
You can get there by going to your quick access toolbar and using print preview and print.
If you don't have this option here, click on this dropdown and add it by putting a checkmark here.
What it does when you click it, you go to the printing options.
Another way to get here is to go to File > Print.
Now immediately, I notice this report is going to be printed on two pages.
This is not what I want.
I want it to fit on one page.
I can make the adjustments either directly here in this view. Or, I can go to the worksheet and make the
adjustments directly there.
You pretty much have the same options.
You just have to pick the way you feel most comfortable with.
So I'll show you both.
Here let's say I want it to reduce the margins to save up some space.
I can switch this from normal to narrow.
It's still fitting on two pages though. I can change the orientation directly from here and select landscape
instead of portrait.
Now this is again not something I want. To make this fit on one page,
I need to go to scaling here and I can select fit sheet on one page.
Now let me show you the options and the page layout side and there's some useful ones there too.
So let's go to page layout. This is where you're gonna find the printing options.
These are what we saw in backstage view.
Now if you click on this tilted arrow here, you get two more options.
Some of it is what you see here.
Some of it are stuff that they couldn't fit here.
So you have additional options available in here. For example,
one option I personally use a lot is the margins and that's how I want my report to be centered on the page.
Because by default the report is always centered to the top left hand side.
Sometimes I want it to be centered horizontally and vertically so it sits in the middle of the paper.
So these are the options that you need under margins, horizontally, vertically.
And I got to it by going to more options here.
Now you can also get to this from backstage view and I'll show you how in a second. But before we go
back to backstage view, let's just check some more options here.
By default, reports don't print grid lines.
If you want grid lines to be printed, put a check mark for printing of grid lines.
The other thing I like about this view is that I can immediately see the percentages associated
with scale.
Remember when we fit this to one page, we basically made it shrink.
You don't want it to shrink too much so that everyone can read it.
Now how can you influence this percentage and increase it further.
So one way we did was to adjust the margins. But there is only so much you can do with margins.
Another way is to reduce the space so maybe hide any rows or columns that you don't need.
So the more condensed your report gets, the higher this percentage is going to get.
So this already jumped up to 80 percent.
Now it's up to 82 percent.
Okay so let's just go and see how this report looks.
I can get to print preview from here
but let me also show you another option.
Remember when we were in this view, we can also directly go to print preview or directly print from there.
So now grid lines were activated.
This is how the report is going to look and it still fits on one page.
Now remember how I centered this.
I told you I'm going to show you how that works from backstage view.
You can get there by going to custom scaling options and you come to the same dialog box we saw before.
Okay.
So this wraps up some useful printing options. But what if we wanted to print only a selection? So we
didn't want to print everything, we just wanted to print parts of this dataset.
And also what if we wanted to print this on two separate pages and not on one page?
Let's take a look at this in the next lecture.