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. 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. Click the View tab, and click the Normal option in the Workbook Views section of the Ribbon to return to normal edit mode for the spreadsheet.Note: The screen shots in this article were taken in Excel 2016. Click anywhere in the worksheet between the header and footer.Highlight the text or options, and press the Delete key to remove the header or footer details.Click the header or footer you want to remove.In the Ribbon, click the View tab, and click the Page Layout option in the Workbook Views section.To remove a header or footer, follow these steps. You can also click the Different Odd & Even Pages option if you want the header and footer to appear differently on odd and even pages. If you want the header and footer of the first page to look different, check the Different First Page box in the Options section on the Header & Footer tab. Click the header or footer to modify the text or options.īy default, the header appears on every page of your worksheet.To make additional edits to the header or footer, click the View tab in the Ribbon, and click the Page Layout option in the Workbook Views section.Click the View tab, and click the Normal option in the Workbook Views section of the Ribbon to return to normal edit mode for the worksheet. When you're done editing, click anywhere in the worksheet between the header and footer.Similar to the header, click the desired footer section (left, middle, or right) and add the desired text or options from the Header & Footer tab in the Ribbon.Scroll down the page until you see the Add footer text at the bottom of the page, and click the Add footer text. To add a footer, click anywhere in the worksheet below the header.Click the desired header section and add the desired text or options from the Header & Footer tab in the Ribbon. The header is split into three sections: left, middle, right. The Page Layout view for the worksheet is displayed, with the header showing at the top of the worksheet.If your Excel program window is not maximized, click the Text option, then click Header & Footer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |