Excel makes it easy to insert Header and Footer fields
so you can give that final touch to your reports.
You just need to know your options
and how to get to them.
There are a few ways that you can get
to your Header and Footer options.
From your Page Layout tab,
you can click on any of these arrows
to expand the Page Setup options
and reach the Header & Footer options from here.
You can go to your View tab and select Page Layout
and when you place your cursor inside any
of the Header and Footer sections,
you'll see your Header & Footer menu show up
in your Ribbon.
Or you can go to your Insert tab
and in the Text section,
select Header & Footer to jump to the Page Layout View
and the Header & Footer menu.
Regardless of how you get to them,
your Header and Footer are each going
to be broken up into three sections.
There's a right, center, and left,
and can accommodate the same fields.
Let's walk through the Header & Footer menu options.
First, if you want each of your tabs
to use the same header and footer,
you'll save time by having your sheets grouped together
while you're adding your header and footers.
Just make sure that none of your sheets already contain
something in the header or footer
because, otherwise, this will override anything
that's already there.
To insert a header or footer message,
select the section where you'd like
to display your message
and simply type your custom message
or you can select from a number
of popular options.
If you go to the Header & Footer menu
and look in the Header & Footer section -
so right now we're in Header,
so I'll click here,
you'll see a list of popular options.
If you use these,
let's say I want to insert the Sheet Name,
just know that the preset will be entered
in the center section and will replace any existing header
or footer message - depending on which one you're in.
You can move it by cutting and pasting it
but then, say, you try to insert another,
so let's do the Page Number,
it will still delete your message
and move it back to the center section.
Let's delete this.
You also have several reference elements you can pick from,
and each can provide valuable information for your users.
Each of these fields will automatically update.
For example, the Page Number field will reference the number
of pages to be printed and will update as this changes.
These you can place where you want
and use however many of them you like in a section.
You can even intermingle them with other text.
For example, say that you insert
the Page Number field here.
You can add a space, type "of", add another space,
and then insert the Number of Pages field
to display the current page in relation
to the total number in the document.
You can even add more fields below it.
For example, press Enter
and insert the Current Date just below.
You can always toggle back and forth between your header
and footer by using the Navigation buttons.
Otherwise, you could always just scroll up
and down your page.
You also have options to create a different header or footer
for your first page than the rest of your document.
For example, if you check this off
and you're on the first page,
you'll notice that this label changes
to read "First Page Header."
Say, I put the Sheet Name in here
and scroll down to the second page,
that sheet name is missing from here
and the label on all subsequent pages changed
to just a normal header.
If I uncheck this, of course,
that erases my specific first page header.
You also have the option to create a different header
or footer message for odd and even pages.
Similarly, you'll see page one
is, of course, an odd number
so the label reads "Odd Page Header."
And I can insert the Sheet Name here...
Then move to any of your even pages.
If I come to page two,
now I have the option to set my header
for an even page header.
Actually, here, I'll go to the footer
and let's say we want to insert the File Path.
You can also further personalize your header
or footer message by applying some formatting
to any of the fields.
To do that, select the field that you'd like
to add the formatting to and in your Home tab,
come to the Font section
and here you can change its font color,
its font type, the font size.
We can bold it, italicize, double underline,
and that will help give it a little bit of a different look.
If you want to insert a logo or other image,
go to the section where you'd like to place that image.
And in the Header & Footer menu options,
select Picture and then select the location
where your image is located.
Select your image and press Insert.
Clearly, this image is way too big.
I can edit this by clicking on the Picture field again,
and in the Header & Footer section,
click on Format Picture,
Here, in the Size tab, making sure
that the Lock Aspect Ratio is checked off,
I'm going to resize it to 3/4 of an inch
and press OK.
I need to make my margins a little bit bigger.
To do that, you can either select here,
the top margin, and drag down,
or go to the Page Layout tab
and set your margins from there.
You can also add more formatting to this
in the Format Picture section.
Say, you want to make it grayscale.
I can come to the Color section.
Make it grayscale and click OK.
For more tutorials like this, click on these links.
Thanks!