Header and footer in excel: how to insert, edit and remove

Do you want khổng lồ know how to make a header in Excel? Or are you wondering how to add the footer page 1 to lớn the current worksheet? This tutorial will teach you how lớn quickly insert one of the predefined headers và footers & how to lớn create a custom one with your own text và graphics.

Bạn đang xem: Header and footer in excel: how to insert, edit and remove

To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. Generally, headers & footers contain basic information about the spreadsheet such as page number, current date, workbook name, tệp tin path, etc. Microsoft Excel provides a handful of predefined headers & footers khổng lồ choose from, as well as allows creating your own ones.

Headers và footers are displayed only on printed pages, in Print Pđánh giá & Page Layout view. In the normal worksheet view, they are not visible.

How lớn add header in Excel

Inserting a header in an Excel worksheet is quite easy. Here"s what you do:

Go to the Insert tab > Text group and cliông chồng the Header và Footer button. This will switch the worksheet to Page Layout view.
Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. By default, the central box is selected:
If you wish the header to appear in the top left or top right corner of the page, click the left or right box and enter some information there.When finished, cliông xã anywhere in the worksheet lớn leave the header area. To exit the header box without keeping the changes, press Esc.

When you print out your worksheet, the header will be repeated on each page.

How to lớn insert footer in Excel

Like an Excel header, a footer can also be inserted in a few easy steps:

On the Insert tab, in the Text group & cliông xã the Header và Footer button.On the Design tab, cliông chồng Go lớn Footer or scroll down to the footer boxes at the bottom of the page.
When done, cliông chồng anywhere in the worksheet khổng lồ exit the footer area.

For example, khổng lồ insert page numbers at the bottom of the worksheet, select one of the footer boxes và cliông chồng Page Number on the Design tab, in the Header & Footer group.

Xem thêm:


How to add a prephối header and footer in Excel

Microsoft Excel comes equipped with a number of inbuilt headers & footers that can be inserted in your document in a mouse cliông chồng. Here"s how:

On the Insert tab, in the Text group, click Header và Footer. This will display the worksheet in Page Layout view & get the Design tab to appear.On the Design tab, in the Header & Footer group, clichồng the Header or Footer button, & select the built-in header or footer of your choosing.

As an example, let"s insert a footer that displays a page number and tệp tin name:


Voila, our Excel footer is created, & the following information will be printed at the bottom of each page:


Two things you should know about preset headers và footers

When inserting an inbuilt header or footer in Excel, please be aware of the following caveats.

1. Preset headers & footers are dynamic

Most of the premix headers and footers in Excel are entered as codes, which makes them dynamic - meaning your header or footer will change lớn reflect the lakiểm tra changes you make khổng lồ the worksheet.

For example, the code & inserts different page numbers on each page and & displays the current file name. To see the codes, just clichồng the corresponding header or footer text box. If you have chosen to add a complex header or footer, chances are that different elements will be inserted in different boxes like in the above example:


2. Prephối headers và footers are inserted in predefined boxes

When adding a built-in header or footer, you cannot control the location of specific elements - they are inserted in the predefined boxes no matter which box (left, center, or right) is currently selected. To position the header or footer the way you want, you can move the inserted elements to lớn other boxes by copying / pasting their codes or add each element individually as explained in the next section.

How to lớn make a custom header or footer in Excel

In Excel worksheets, not only can you add preset headers và footers, but also make your own ones with custom text & images.

As usual, you start by clicking the Header và Footer button on the Insert tab. Then, clichồng one of the boxes at the top (header) or at the bottom (footer) of the worksheet và type your text there. You can also enter different pieces of information by selecting one of the built-in elements on the Design tab, in the Header & Footer Elements group.

This example will show you how to lớn create a custom header with your company logo, page numbers, tệp tin name and current date.

To begin with, let"s insert File Name (workbook name) in the central header box:
Then, select the right box and insert Page Number there. As you can see in the screenshot below, this only displays the number:
If you want the word "Page" to lớn appear as well, cliông chồng anywhere in the right text box, và type "Page" in front of the code, separating the word & the code with a space character like this:
Additionally, you can insert the Number of Pages element in the same box by clicking on the corresponding button on the ribbon, & then type "of" in between the codes so that your Excel header displays something like "Page 1 of 3":
Finally, let"s insert the company biệu tượng công ty in the left box. For this, cliông xã the Picture button, browse for the image file, và cliông chồng Insert. The & code will be inserted in the header straight away:


As soon as you cliông chồng anywhere outside the header box, an actual picture will show up.