1
00:00:00,770 --> 00:00:05,020
In the previous lecture we took a look at Excel's header and footer options.

2
00:00:05,240 --> 00:00:09,920
In this lecure, we're going to expand on it a little bit and I also want to show you a trick you can

3
00:00:09,920 --> 00:00:15,940
use to apply the header and footer of an existing sheet to many sheets in one go.

4
00:00:16,040 --> 00:00:21,270
So previously we used the Page Layout view to add a header and a footer.

5
00:00:21,320 --> 00:00:28,580
You can also do that from the page layout tab by going to more page setup options here and selecting

6
00:00:28,580 --> 00:00:29,840
header and footer.

7
00:00:29,870 --> 00:00:33,270
Here you can define a custom header and a custom footer.

8
00:00:33,290 --> 00:00:35,710
The view here is from the old Excel.

9
00:00:35,720 --> 00:00:41,510
It's not as user friendly as the Page Layout view. But you have all the options available so you can

10
00:00:41,840 --> 00:00:44,420
type something directly in here.

11
00:00:44,420 --> 00:00:51,500
You can also insert pictures, you can bring in your logo and you can insert time, page numbers, everything

12
00:00:51,500 --> 00:00:53,900
directly from here. For the footer,

13
00:00:53,930 --> 00:01:03,680
let's go in and add the page numbers and the number of pages in my report. Which is this icon right here.

14
00:01:03,710 --> 00:01:04,900
Let's go with okay.

15
00:01:05,180 --> 00:01:07,740
Now let's go to page layout tab as well.

16
00:01:07,830 --> 00:01:10,670
So remember one option is to get to it here.

17
00:01:10,670 --> 00:01:15,010
Another option is to go to view and click on page layout.

18
00:01:15,050 --> 00:01:19,030
So just what we added before it's available to us right here.

19
00:01:20,270 --> 00:01:23,020
Now let's also add a logo.

20
00:01:23,310 --> 00:01:28,910
Select on header and footer, click on picture and import a picture.

21
00:01:28,910 --> 00:01:33,170
So I have this one here, click on insert and it's right there.

22
00:01:33,490 --> 00:01:33,760
Okay.

23
00:01:33,770 --> 00:01:41,560
If we go to print preview we can see our logo, the report, and the page number.

24
00:01:41,680 --> 00:01:45,530
In this case we haven't formatted it yet to print properly.

25
00:01:45,530 --> 00:01:49,740
We need to fix the rows and the columns to be repeated.

26
00:01:49,790 --> 00:01:55,970
So do you remember where that option was? Page layout, more options.

27
00:01:56,080 --> 00:02:04,140
Which one was it? Sheet. Rows to repeat at top, row five, columns to repeat.

28
00:02:04,180 --> 00:02:06,570
That's the first column and click on ok.

29
00:02:06,620 --> 00:02:14,480
We can already see in the page layout view the way our printouts are going to look.

30
00:02:14,530 --> 00:02:16,690
Now we don't want this one up here.

31
00:02:16,690 --> 00:02:25,340
We can fix the print area to only our data set or in this case I'm just going to hide it from view.

32
00:02:26,760 --> 00:02:27,060
OK.

33
00:02:27,100 --> 00:02:35,170
Now that we applied our header and footer to our report. What if we want to copy it to our other pages?

34
00:02:35,320 --> 00:02:39,440
So this one here doesn't have any headers or footers.

35
00:02:39,440 --> 00:02:40,390
Let's take a look.

36
00:02:40,390 --> 00:02:45,420
There is nothing here. To apply this one to the other pages.

37
00:02:45,490 --> 00:02:48,580
What you need to do is select the pages you want.

38
00:02:48,580 --> 00:02:49,860
I'm just going to go with these,

39
00:02:49,990 --> 00:02:54,100
Select them, go to the page where you have the header and footer done.

40
00:02:54,130 --> 00:02:55,500
So that's this one.

41
00:02:55,690 --> 00:03:03,270
Activate the header or the footer, just click anywhere inside and then click away.

42
00:03:03,280 --> 00:03:09,280
Now let's just deselect everything, go and check print preview.

43
00:03:09,280 --> 00:03:10,680
We have our header there.

44
00:03:10,720 --> 00:03:11,980
We have our footer there.

45
00:03:12,090 --> 00:03:12,380
Right.

46
00:03:12,400 --> 00:03:14,020
Everything got copied.

47
00:03:14,020 --> 00:03:16,780
Something is missing though, our logo.

48
00:03:16,780 --> 00:03:19,720
That one didn't get copied automatically.

49
00:03:19,720 --> 00:03:27,100
So for the logo, it looks like what we need to do is to highlight everything and actually bring in our

50
00:03:27,100 --> 00:03:28,990
logo again.

51
00:03:28,990 --> 00:03:30,520
I'm going to remove it.

52
00:03:30,520 --> 00:03:32,740
It's actually gone from here.

53
00:03:32,740 --> 00:03:40,390
Now go to header and footer again, go to picture and import that logo. But notice while I'm doing this

54
00:03:40,720 --> 00:03:43,140
all of these are highlighted as well.

55
00:03:43,150 --> 00:03:44,480
I'm going to click away.

56
00:03:44,890 --> 00:03:46,070
Let's select.

57
00:03:46,180 --> 00:03:52,660
Now let's check if that logo is there. The logo is there.

58
00:03:52,670 --> 00:03:58,250
So in case you're using a picture just make sure you select your sheets and then import the logo.