1
00:00:00,940 --> 00:00:03,600
How about printing larger data sets?

2
00:00:03,610 --> 00:00:09,310
How could we get the data to fit properly on the printed pages so we can always tell what the header

3
00:00:09,310 --> 00:00:11,830
is that that number belongs to?

4
00:00:11,830 --> 00:00:16,390
So here I have some sample profit development data for these apps.

5
00:00:16,420 --> 00:00:22,550
They go from January 2019 all the way to December 2020.

6
00:00:23,030 --> 00:00:27,440
Notice they take up a lot of space in the rows as well as the columns.

7
00:00:27,460 --> 00:00:33,900
If I go to print preview, this is gonna print on four pages which is not bad.

8
00:00:34,150 --> 00:00:36,460
But check this out. On the last page here

9
00:00:36,460 --> 00:00:39,880
I have no clue what this 800 belongs to.

10
00:00:39,880 --> 00:00:45,010
I need to get the headers on both the rows side as well as the column side

11
00:00:45,160 --> 00:00:50,140
repeated on each single page. There is an option for this.

12
00:00:50,200 --> 00:00:55,730
Let's go to page layout, to page set up and let's go to more options here.

13
00:00:55,750 --> 00:01:01,030
Select sheet, right here we need to select the rows to repeat on the top.

14
00:01:01,030 --> 00:01:05,960
Whatever we select here is going to be repeated on every single page.

15
00:01:05,980 --> 00:01:12,760
We definitely want to have our months there and we also want to get our columns repeated. Because remember

16
00:01:12,760 --> 00:01:16,210
on the last page we don't see the columns either.

17
00:01:16,210 --> 00:01:20,220
Now let's go back to print preview and see how this looks.

18
00:01:20,230 --> 00:01:21,510
First page is nice.

19
00:01:21,730 --> 00:01:24,820
Second page, we get our headers here.

20
00:01:24,820 --> 00:01:30,670
Third page, we get our headers and we get our columns repeated. And the last page

21
00:01:30,670 --> 00:01:33,200
we know what that 800 belongs to.

22
00:01:33,200 --> 00:01:38,050
Now one thing I don't like about this is this page here where I selected the entire column.

23
00:01:38,110 --> 00:01:45,100
I can also see that writing that I had on top. I don't want this in my report. It's enough to see profit

24
00:01:45,100 --> 00:01:46,180
development.

25
00:01:46,180 --> 00:01:50,420
So how can I get rid of that without deleting it?

26
00:01:50,530 --> 00:01:52,570
I can set my print area.

27
00:01:52,600 --> 00:01:59,970
I'm just going to highlight the data only and the header that I want, go to print area and set it.

28
00:02:00,010 --> 00:02:07,970
Now let's go to print preview. This page looks great and everything fits properly.

29
00:02:07,970 --> 00:02:13,670
Now one adjustment to this is to add page numbers. Whenever you're printing something that's more

30
00:02:13,670 --> 00:02:20,120
than two pages, it's good practice to add page numbers to it. And you can do it really quickly by going

31
00:02:20,120 --> 00:02:21,810
to Page Layout view.

32
00:02:21,840 --> 00:02:27,240
There are different ways you can get there. A fast way is to go down here and click on page layout.

33
00:02:27,240 --> 00:02:28,540
So this is the default.

34
00:02:28,550 --> 00:02:29,990
It's the normal view.

35
00:02:29,990 --> 00:02:33,540
This is the Page Layout view. In this view,

36
00:02:33,560 --> 00:02:36,680
you can see how your printed page is going to look

37
00:02:36,800 --> 00:02:43,190
and you can easily add headers and footers. So let's just click here to activate the header and footer

38
00:02:43,190 --> 00:02:44,100
options.

39
00:02:44,150 --> 00:02:51,660
You can type directly in there and you can use some of these elements that are directly available.

40
00:02:51,680 --> 00:02:53,800
For example, you can put the file path.

41
00:02:53,810 --> 00:02:55,490
You can put the file name.

42
00:02:55,490 --> 00:03:02,450
You can add a logo and you can put the current date or the current time. Now to add the page numbers

43
00:03:02,450 --> 00:03:03,700
we need these two.

44
00:03:03,710 --> 00:03:05,580
Let's do that in the footer.

45
00:03:05,580 --> 00:03:08,060
So I'm just going to scroll down here.

46
00:03:08,060 --> 00:03:11,200
Go back to header and footer and click on page number.

47
00:03:11,210 --> 00:03:14,450
It's also nice to see how many pages are in total.

48
00:03:14,510 --> 00:03:20,290
So I'm going to add a space  type "of" and put in number of pages.

49
00:03:20,600 --> 00:03:25,500
This way I see the current page and how many pages there are in total.

50
00:03:25,610 --> 00:03:27,570
How do I go back to normal view?

51
00:03:27,590 --> 00:03:29,420
I just have to click here.

52
00:03:29,420 --> 00:03:33,120
Another way of getting there is to go to the view tab here.

53
00:03:33,140 --> 00:03:38,420
Notice from page layout I can switch to normal view also here.

54
00:03:38,450 --> 00:03:46,460
Now let's go back to print preview and we see one of four, two of four, and four of four.