Add or remove page numbers

2016 2011



Add page numbers

1. On the Insert tab, click Header & Footer.

   Excel automatically changes to Page Layout view.

2. On Header & Footer tab, click either the Header or Footer, and then select the page number format you want.

   Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom.

3. When you're done, you can either stay in Page Layout view, or you can switch to Normal view by clicking Normal on the View tab.

Set a different number for the starting page

You can make the first printed sheet start with a page number other than 1. This is helpful if there are other printed pages that will come before the sheet. For example, you might print a 2-page Word document that will account for pages 1 and 2, and your Excel sheet would then start on page 3.

1. On the Page Layout tab, click Page Setup.

2. On the Page tab, in the First page number box, type the number you want for the first page number. For example, if you wanted the first page number to be 3, you'd type the number 3.

3. Click OK.

If you are using a page number format that counts the total pages, for example: Page 3 of 7, you'll need to make an adjustment to the second number. This adjustment ensures you don't end up with something like this: Page 10 of 7.

1. In Page Setup, click the Header/Footer tab, and then click either Custom Header or Custom Footer.

2. After Page &[Page] of &[Pages], type the plus sign (+), and then type the number of pages that come before your first page number.

   For example, if 3 is your first page number, you need to include 2 pages in the total page count. So you'd type a +2 at the end: Page &[Page] of &[Pages]+2 and then click OK.

3. Click OK again.

Change the order that pages are numbered

1. On the Page Layout tab, click Page Setup, and then click Sheet.

2. Under Page order, select the page numbering order that you want.

Remove page numbers

1. On the Page Layout tab, click Page Setup, and then click Header/Footer.

2. Under Header or Footer, select (none).

   You might have to scroll to find (none) at the top of the list.

Add page numbers

1. On the Layout tab, under Page Setup, click Header & Footer.

2. On pop-up menu under Header or Footer, select the page number format that you want to add.

   Header formats appear at the top of the printed page, and footer formats appear at the bottom.

   Tips: 

   • You can see how your page numbers will appear by viewing your sheet in preview mode. On the Layout tab, under Print, click Preview.

   • To add page numbers to multiple sheets in your workbook at the same time, select the sheets you want before clicking Header & Footer. The page number format you choose will be applied to all selected sheets.

   • You can create a completely custom header or footer with page numbers by clicking Customize Header or Customize Footer, and following the instructions given.

Set a different number for the starting page

1. On the Layout tab, under Page Setup, click Header & Footer.

2. Add page numbers in the format that you want.

3. Click Customize Header or Customize Footer, depending on where the page numbers appear.

4. Look for the page number code &[Page], and click immediately after it to move the insertion point to this location.

5. Type a plus sign (+), and then type the number of pages by which you want to advance the starting page. For example, to start on page 4, you are increasing the starting page number by three pages, so you type +3. The code now appears as &[Page]+3.

6. Click OK.

   In the Header or Footer box, the new first page header or footer is shown.

   Note: If you want to use a page number format that includes the total number of pages, such as Page 4 of 7, make sure that you also add the plus sign (+) and page number increase to the total pages code, &[Pages].

Change the order that pages are numbered

1. On the Layout tab, under Page Setup, click Header & Footer.

2. On the Sheet tab, under Page order, select the page numbering order that you want.

Remove page numbers

1. On the Layout tab, under Page Setup, click Header & Footer.

2. On pop-up menu under Header or Footer, select (none).

See also

Add or remove a header or footer