In the previous lecture we took a look at Excel's header and footer options.
In this lecure, we're going to expand on it a little bit and I also want to show you a trick you can
use to apply the header and footer of an existing sheet to many sheets in one go.
So previously we used the Page Layout view to add a header and a footer.
You can also do that from the page layout tab by going to more page setup options here and selecting
header and footer.
Here you can define a custom header and a custom footer.
The view here is from the old Excel.
It's not as user friendly as the Page Layout view. But you have all the options available so you can
type something directly in here.
You can also insert pictures, you can bring in your logo and you can insert time, page numbers, everything
directly from here. For the footer,
let's go in and add the page numbers and the number of pages in my report. Which is this icon right here.
Let's go with okay.
Now let's go to page layout tab as well.
So remember one option is to get to it here.
Another option is to go to view and click on page layout.
So just what we added before it's available to us right here.
Now let's also add a logo.
Select on header and footer, click on picture and import a picture.
So I have this one here, click on insert and it's right there.
Okay.
If we go to print preview we can see our logo, the report, and the page number.
In this case we haven't formatted it yet to print properly.
We need to fix the rows and the columns to be repeated.
So do you remember where that option was? Page layout, more options.
Which one was it? Sheet. Rows to repeat at top, row five, columns to repeat.
That's the first column and click on ok.
We can already see in the page layout view the way our printouts are going to look.
Now we don't want this one up here.
We can fix the print area to only our data set or in this case I'm just going to hide it from view.
OK.
Now that we applied our header and footer to our report. What if we want to copy it to our other pages?
So this one here doesn't have any headers or footers.
Let's take a look.
There is nothing here. To apply this one to the other pages.
What you need to do is select the pages you want.
I'm just going to go with these,
Select them, go to the page where you have the header and footer done.
So that's this one.
Activate the header or the footer, just click anywhere inside and then click away.
Now let's just deselect everything, go and check print preview.
We have our header there.
We have our footer there.
Right.
Everything got copied.
Something is missing though, our logo.
That one didn't get copied automatically.
So for the logo, it looks like what we need to do is to highlight everything and actually bring in our
logo again.
I'm going to remove it.
It's actually gone from here.
Now go to header and footer again, go to picture and import that logo. But notice while I'm doing this
all of these are highlighted as well.
I'm going to click away.
Let's select.
Now let's check if that logo is there. The logo is there.
So in case you're using a picture just make sure you select your sheets and then import the logo.