1
00:00:01,120 --> 00:00:08,380
Now let's take a look at how we can print parts of a sheet and how we can add page breaks for full control.

2
00:00:08,380 --> 00:00:09,930
This way we can decide where we want

3
00:00:09,930 --> 00:00:13,510
the first page to end and the second page to start.

4
00:00:13,510 --> 00:00:16,810
This is the type of report we're dealing with.

5
00:00:16,810 --> 00:00:21,550
So in the first step, let's say we're just interested to print parts of this.

6
00:00:21,550 --> 00:00:26,270
We just want the list of apps and sales for 2019.

7
00:00:26,320 --> 00:00:34,410
One way to do this is to highlight the area you want printed and go to file, print, change this dropdown

8
00:00:34,600 --> 00:00:36,400
to print selection.

9
00:00:36,400 --> 00:00:40,070
The moment you do that, it shows you what you've selected on the Excel side

10
00:00:40,180 --> 00:00:41,520
and that's what is going to print.

11
00:00:41,530 --> 00:00:43,110
It's one of one.

12
00:00:43,120 --> 00:00:49,900
So notice when I go back to active sheet, it's actually by default going to print this on four

13
00:00:49,900 --> 00:00:50,740
separate sheets.

14
00:00:50,740 --> 00:00:55,300
Now what if you always wanted to just print those two columns

15
00:00:55,300 --> 00:01:01,360
whenever someone pressed print. You don't want them to remember to highlight and then go select print

16
00:01:01,360 --> 00:01:02,190
selection.

17
00:01:02,230 --> 00:01:04,200
You just want him to be able to press print

18
00:01:04,269 --> 00:01:11,830
and it only prints those two columns. The way you can set this is to go to page layout, highlight the

19
00:01:11,830 --> 00:01:18,950
area that you want, and then set the print area by clicking on print area and then set it.

20
00:01:19,000 --> 00:01:23,170
This forces the print area to always only be this area.

21
00:01:23,590 --> 00:01:28,810
Now anytime we go to print preview we only see what we selected.

22
00:01:28,810 --> 00:01:36,530
Notice this side is set to print active sheets. It sees the active sheet as only these two columns.

23
00:01:36,640 --> 00:01:39,150
It completely ignores everything else.

24
00:01:39,190 --> 00:01:42,220
So that's the advantage of setting your print area.

25
00:01:42,610 --> 00:01:46,810
Let's remove this print area, clear print area.

26
00:01:46,810 --> 00:01:52,990
Now let's say I want to print this full document and I want to have my table in one page and the two

27
00:01:52,990 --> 00:01:54,990
charts on another page.

28
00:01:55,000 --> 00:01:59,200
How can a make Excel format this properly for me.

29
00:01:59,230 --> 00:02:02,320
Well I have some options here from scale to fit.

30
00:02:02,320 --> 00:02:09,960
I could say try to fit this on one page and the height should be probably two pages and I can try

31
00:02:09,970 --> 00:02:15,910
one page. Scale is really low which means everything is going to be super small.

32
00:02:15,910 --> 00:02:19,540
If I go to print preview I don't really want it like this.

33
00:02:19,540 --> 00:02:22,340
I want them sitting on their own pages.

34
00:02:22,400 --> 00:02:29,810
Now let's also change the orientation of this and see if that improves. That reduces the scale even further.

35
00:02:29,830 --> 00:02:35,680
How do I get Excel to actually fit the page breaks to where I want?

36
00:02:35,770 --> 00:02:39,630
This is where you can insert your own page breaks.

37
00:02:39,850 --> 00:02:43,630
What I'm going to do is just set this back to automatic.

38
00:02:43,840 --> 00:02:47,850
Let's go and insert a page break right here.

39
00:02:47,950 --> 00:02:50,890
Now let's go and take a look at how this is going to look.

40
00:02:50,890 --> 00:02:55,120
Until now the scale is still set to 54 percent.

41
00:02:55,180 --> 00:02:58,800
We don't want that scaling so let's change that.

42
00:02:58,810 --> 00:03:02,830
This part looks good but this part doesn't look good.

43
00:03:02,830 --> 00:03:04,990
It's cutting through one of my charts.

44
00:03:04,990 --> 00:03:08,820
I want both charts to fit on one page.

45
00:03:08,830 --> 00:03:12,570
This is where you can directly control the page breaks.

46
00:03:12,640 --> 00:03:17,910
To do that go to the view tab and click on page break preview.

47
00:03:17,950 --> 00:03:23,130
This takes you out of normal view and shows you how Excel is planning to print.

48
00:03:23,320 --> 00:03:30,880
The dark blue borders are the ones that we've set and the dashed ones are the ones that Excel' set

49
00:03:30,880 --> 00:03:31,640
for us.

50
00:03:31,640 --> 00:03:36,970
Now this one I'm not so happy about so I'm going to pull it that way because I want it to force the

51
00:03:36,970 --> 00:03:41,480
page break to be here so the full chart can fit in.

52
00:03:41,510 --> 00:03:46,930
Now I can also reduce that column and notice here behind there's another page break.

53
00:03:47,020 --> 00:03:49,210
That's where it was cutting my chart.

54
00:03:49,270 --> 00:03:54,460
I'm going to push that down as well to make this part fit

55
00:03:54,460 --> 00:04:00,810
on the second page. And I can even expand this further as well and then adjust my charts.

56
00:04:00,820 --> 00:04:05,200
So it takes a little bit of adjustment to get it fit the way you want.

57
00:04:05,200 --> 00:04:08,000
Now let's go back to normal view.

58
00:04:08,110 --> 00:04:12,040
We can see the other page breaks have adjusted.

59
00:04:12,040 --> 00:04:16,760
Let's go to print preview and we can see everything fits well.

60
00:04:17,079 --> 00:04:21,579
So that's how you can use page breaks to get full control over your printouts.