On the Sheet tab, under Page order, click Down, then over or Over, then down.The direction of each option is displayed in the preview box.On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher next to Page Setup.Click the worksheet for which you want to change the numbering order.On the Page tab, in the First page number box, type the number that you want to use for the first page.To use the default numbering system, type Auto in the First page number box.Ĭhange the order in which pages are numberedīy default, Excel numbers and prints pages from the top down and then left to right on the worksheet, but you can change the direction to number and print pages from left to right and then from the top down.On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher next to Page Setup.For example, if your workbook contains two worksheets that with both be printed as two pages, you would use this procedure to begin the page numbering for the second worksheet with the number 3. To number all of the worksheet pages in a workbook sequentially, first add page numbers to all worksheets in a workbook, and then use the following procedure to begin the page number for each worksheet with the appropriate number. Set a different number for the starting page The placeholder & of & appears in the selected section.If you want to add the total number of pages, type a space after &, type the word of followed by a space, and then click the Insert Number of Pages button.The second worksheet will also contain two pages numbered 1 and 2.
For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. You can insert page numbers on multiple worksheets in your workbook by using the Page Setup dialog box. For other sheet types, such as chart sheets, you can insert page numbers only by using the Page Setup dialog box. After you have completed working in Page Layout view, on the View tab, in the Workbook Views group, click Normal.You can also click Normal on the status bar.You can insert page numbers for a worksheet in Page Layout view, where you can see them, or you can use the Page Setup dialog box if you want to insert page numbers for more than one worksheet at the same time.Click anywhere outside the header or footer area to display the actual page numbers in Page Layout view.The placeholder & of & appears in the selected section On the Design tab, in the Header & Footer Elements group, click Page Number.The placeholder & appears in the selected section.If want to add the total number of pages, type a space after &, type the word of followed by a space and then, in the Header & Footer Elements group, click Number of Pages.
How To Number In Excel Add page numbers on a single worksheet