How To Number Pages In Excel

Table of contents:

How To Number Pages In Excel
How To Number Pages In Excel

Video: How To Number Pages In Excel

Video: How To Number Pages In Excel
Video: How to Insert Page Numbers in Excel (Easy Step-by-Step) 2024, March
Anonim

In Microsoft Excel documents, page numbers can be put on the headers and footers of sheets. The numbers can only be seen after printing or in markup mode. Pages are numbered starting from one by default, but the first page number, as well as the order of the numbering itself, can be changed. You can use the Page Setup dialog box to add numbers to your pages, or you can do it in markup mode.

How to number pages in excel
How to number pages in excel

Instructions

Step 1

To number in the layout mode, select the sheet you want to number.

1. Go to the "Insert" tab, in the "Text" section, select "Headers and Footers".

2. Select a header or footer on the sheet. Indicate where the numbering should be placed in the header and footer.

3. Go to the "Design" tab, in the "Header and Footer Elements" section, select "Page Number", "& [Page]" will appear in the specified place.

4. To exit the layout mode, go to the "View" tab, in the "Book Views" section, select "Normal".

How to number pages in excel
How to number pages in excel

Step 2

To number using the Page Setup window, select the sheet you want to number.

1. Click the Page Layout tab, in the Page Setup section, click the button next to Page Setup.

2. In the window that opens, go to the "Headers and Footers" tab and click "Create Header" or "Create Footer", then specify the place where you want to insert the page number. "& [Page]" appears at the specified location.

Recommended: