1
00:00:01,750 --> 00:00:04,630
Let's start off with some useful printing options.

2
00:00:04,920 --> 00:00:05,650
So let's say.

3
00:00:05,680 --> 00:00:08,710
I have this report, I want to get it printed.

4
00:00:08,860 --> 00:00:13,510
First thing I'm going to do is to take a look at it in print preview.

5
00:00:13,510 --> 00:00:19,360
You can get there by going to your quick access toolbar and using print preview and print.

6
00:00:19,360 --> 00:00:25,630
If you don't have this option here, click on this dropdown and add it by putting a checkmark here.

7
00:00:25,630 --> 00:00:30,130
What it does when you click it, you go to the printing options.

8
00:00:30,130 --> 00:00:34,180
Another way to get here is to go to File > Print.

9
00:00:34,210 --> 00:00:39,510
Now immediately, I notice this report is going to be printed on two pages.

10
00:00:39,520 --> 00:00:41,220
This is not what I want.

11
00:00:41,320 --> 00:00:44,140
I want it to fit on one page.

12
00:00:44,170 --> 00:00:51,070
I can make the adjustments either directly here in this view. Or, I can go to the worksheet and make the

13
00:00:51,070 --> 00:00:52,780
adjustments directly there.

14
00:00:52,960 --> 00:00:55,240
You pretty much have the same options.

15
00:00:55,300 --> 00:00:58,120
You just have to pick the way you feel most comfortable with.

16
00:00:58,510 --> 00:01:00,310
So I'll show you both.

17
00:01:00,310 --> 00:01:04,860
Here let's say I want it to reduce the margins to save up some space.

18
00:01:04,900 --> 00:01:08,030
I can switch this from normal to narrow.

19
00:01:08,650 --> 00:01:15,340
It's still fitting on two pages though. I can change the orientation directly from here and select landscape

20
00:01:15,400 --> 00:01:16,870
instead of portrait.

21
00:01:16,890 --> 00:01:22,060
Now this is again not something I want. To make this fit on one page,

22
00:01:22,060 --> 00:01:27,210
I need to go to scaling here and I can select fit sheet on one page.

23
00:01:27,220 --> 00:01:33,310
Now let me show you the options and the page layout side and there's some useful ones there too.

24
00:01:33,730 --> 00:01:37,620
So let's go to page layout. This is where you're gonna find the printing options.

25
00:01:37,660 --> 00:01:40,770
These are what we saw in backstage view.

26
00:01:40,870 --> 00:01:46,180
Now if you click on this tilted arrow here, you get two more options.

27
00:01:46,180 --> 00:01:48,350
Some of it is what you see here.

28
00:01:48,460 --> 00:01:51,250
Some of it are stuff that they couldn't fit here.

29
00:01:51,250 --> 00:01:55,420
So you have additional options available in here. For example,

30
00:01:55,450 --> 00:02:03,700
one option I personally use a lot is the margins and that's how I want my report to be centered on the page.

31
00:02:03,700 --> 00:02:09,229
Because by default the report is always centered to the top left hand side.

32
00:02:09,250 --> 00:02:15,660
Sometimes I want it to be centered horizontally and vertically so it sits in the middle of the paper.

33
00:02:15,670 --> 00:02:20,330
So these are the options that you need under margins, horizontally, vertically.

34
00:02:20,380 --> 00:02:23,510
And I got to it by going to more options here.

35
00:02:23,560 --> 00:02:30,520
Now you can also get to this from backstage view and I'll show you how in a second. But before we go

36
00:02:30,520 --> 00:02:34,520
back to backstage view, let's just check some more options here.

37
00:02:34,540 --> 00:02:37,330
By default, reports don't print grid lines.

38
00:02:37,330 --> 00:02:42,580
If you want grid lines to be printed, put a check mark for printing of grid lines.

39
00:02:42,580 --> 00:02:48,460
The other thing I like about this view is that I can immediately see the percentages associated

40
00:02:48,460 --> 00:02:49,420
with scale.

41
00:02:49,420 --> 00:02:54,820
Remember when we fit this to one page, we basically made it shrink.

42
00:02:54,820 --> 00:02:59,710
You don't want it to shrink too much so that everyone can read it.

43
00:02:59,710 --> 00:03:03,780
Now how can you influence this percentage and increase it further.

44
00:03:03,790 --> 00:03:09,770
So one way we did was to adjust the margins. But there is only so much you can do with margins.

45
00:03:09,790 --> 00:03:15,790
Another way is to reduce the space so maybe hide any rows or columns that you don't need.

46
00:03:15,940 --> 00:03:20,410
So the more condensed your report gets, the higher this percentage is going to get.

47
00:03:20,410 --> 00:03:23,950
So this already jumped up to 80 percent.

48
00:03:23,980 --> 00:03:25,930
Now it's up to 82 percent.

49
00:03:26,130 --> 00:03:29,230
Okay so let's just go and see how this report looks.

50
00:03:29,260 --> 00:03:31,120
I can get to print preview from here

51
00:03:31,120 --> 00:03:33,320
but let me also show you another option.

52
00:03:33,340 --> 00:03:40,180
Remember when we were in this view, we can also directly go to print preview or directly print from there.

53
00:03:40,600 --> 00:03:42,310
So now grid lines were activated.

54
00:03:42,310 --> 00:03:47,590
This is how the report is going to look and it still fits on one page.

55
00:03:47,590 --> 00:03:49,570
Now remember how I centered this.

56
00:03:49,600 --> 00:03:52,830
I told you I'm going to show you how that works from backstage view.

57
00:03:52,960 --> 00:04:02,020
You can get there by going to custom scaling options and you come to the same dialog box we saw before.

58
00:04:02,020 --> 00:04:02,240
Okay.

59
00:04:02,260 --> 00:04:09,310
So this wraps up some useful printing options. But what if we wanted to print only a selection? So we

60
00:04:09,310 --> 00:04:13,620
didn't want to print everything, we just wanted to print parts of this dataset.

61
00:04:13,720 --> 00:04:19,589
And also what if we wanted to print this on two separate pages and not on one page?

62
00:04:19,600 --> 00:04:21,820
Let's take a look at this in the next lecture.