How to add header and footer in Excel for all pages

If you have a large spreadsheet in Excel, you may want to add page numbers. Doing so is easy, and you can even add them in the format of “Page X of Y”. Read on to find out how.

To begin, click the “Insert” tab.

In the “Text” section, click “Header & Footer”.

The “Design” tab under “Header & Footer Tools” displays. In the “Header & Footer Elements” section, click the “Page Number” button. A header is added to the spreadsheet and the cursor is put inside the header.

The code for the page number is inserted. Make sure the cursor is after the “&[Page]” text and add the word “of”, as shown below.

To add a code that inserts the total number of pages in the document, click “Number of Pages” in the “Header & Footer Elements” section of the “Design” tab.

You can also insert “Page X of Y” into the header by clicking the “Header” button in the “Header & Footer” section of the “Design” tab. Select “Page 1 of ?” from the drop-down menu.

The “Page X of Y” text is inserted into the header and the main spreadsheet automatically becomes active again.

Here we showed how to insert “Page X of Y” into the header, but the procedure is the same for the footer.

Normally, you can insert the header or footer with document path, name quickly and easily in a Word file. But, have you ever tried to insert the chapter title to header or footer, so that, the content of the header or footer is depended on what chapter the page is in. This article, I will talk about how to solve this job in Word document.

Add chapter title to header or footer in Word document

To insert each chapter title to header or footer, you can use the Quick Parts feature to achieve it, please do as this:

1. Firstly, you should apply a paragraph style to the chapter title that you want to insert as header or footer, in this example, my chapter title is styled as Heading 1, see screenshot:

2. Then click Home > Header / Footer, and choose one header or footer style, see screenshot:

3. And then, click Quick Parts > Field under the Design tab, see screenshot:

4. In the popped out Field dialog box, do the following operations:

(1.) Select Links and References from the Categories drop down list;
(2.) In the Field names list box, please choose StyleRef option;
(3.) And then, find and select Heading 1 which is your chapter style you created from the Style name list box.

5. After finishing the settings, please click OK button, and now, the chapter title has been inserted into the header or footer, see screenshot:

Notes:

1. If there's more than one Heading 1 on one page, only the first appeared one will be inserted into the header or footer.

2. The header or footer will be changed automatically when the chapter title is changing.

Recommended Word Productivity Tools

Kutools For Word - More Than 100 Advanced Features For Word, Save Your 50% Time

Complicated and repeated operations can be done one-time processing in seconds.
Insert multiple images across folders into Word document at once.
Merge and combine multiple Word files across folders into one with your desired order.
Split the current document into separate documents according to heading, section break or other criteria.
Convert files between Doc and Docx, Docx and PDF, collection of tools for common conversions and selection, and so on...

Read More Download Now Purchase

Oldest First

Sort comments by

Oldest First

Newest First

Comments (8)

No ratings yet. Be the first to rate!

jesus

about 3 years ago

#28293