![how to delete a header in excel 2016 how to delete a header in excel 2016](https://www.techonthenet.com/excel/columns/images/delete2010_002.gif)
The direction of each option is displayed in the preview box.Ĭlick the worksheets or chart sheets for which you want to remove page numbers. On the Sheet tab, under Page order, click Down, then over or Over, then down. 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.Ĭlick 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. 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. 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.
![how to delete a header in excel 2016 how to delete a header in excel 2016](https://tecnotraffic.net/wp-content/uploads/2020/11/Maneras-faciles-de-eliminar-el-encabezado-y-el-pie-de.png)
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.
![how to delete a header in excel 2016 how to delete a header in excel 2016](https://v8r5x7v2.rocketcdn.me/wp-content/uploads/2014/11/excel-2013-delete-header-1.jpg)
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.