For other sheet types, such as chart sheets, you can insert page numbers only by using the Page Setup dialog box. 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. You can also click Normal on the status bar. The placeholder & of & appears in the selected sectionĬlick anywhere outside the header or footer area to display the actual page numbers in Page Layout view.Īfter you have completed working in Page Layout view, on the View tab, in the Workbook Views group, click Normal. 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. The placeholder & appears in the selected section. On the Design tab, in the Header & Footer Elements group, click Page Number. To specify where in the header or footer you want the page number to appear, click inside the Left section, Center section, or Right section box of the header or footer. This displays the Header & Footer Tools, adding the Design tab. On the worksheet, click Click to add header or Click to add footer. You can also click Page Layout on the status bar to display this view.

On the Insert tab, in the Text group, click Header & Footer.Įxcel displays the worksheet in Page Layout view. Add page numbers on a single worksheetĬlick the worksheet for which you want to insert page numbers. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same. Note: The screen shots in this article were taken in Excel 2016.

How to paginate in excel 2010