How to Insert Page X of Y into a Header or Footer in Excel

00_lead_image_page_x_of_y

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.

01_clicking_insert_tab

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

01a_clicking_header_and_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.

02_clicking_page_number

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.

03_typing_of

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.

04_clicking_number_of_pages

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.

05_selecting_page_1_of_x

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

06_showing_page_x_of_y

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

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.