Customize page numbering for the starting pageīy default, pages are numbered sequentially starting with page 1, but you can start the order with a different number.
Now if you go to the Print Preview pane, you'll see that all pages from all worksheets got sequential Excel page number watermarks. The placeholder & of & will be displayed. Then click the Insert Number of Pages Button image.
When the placeholder & appears, type a space after &, and enter the word " of" followed by a space. Click on the Insert Page Number Button image. Define the location for the page numbers by clicking inside the Left section:, Center section: or Right section: box. You will get the Page Setup window appear. Press the Custom Header or Custom Footer button. Go to the Header/Footer tab in the Page Setup dialog box. Click on the Dialog Box Launcher Button image in the Page Setup group. Open the Excel file with the worksheets that need page numbering. You can insert page numbers on multiple worksheets so that all pages are numbered in sequential order by using the Page Setup dialog box. Say, you have a workbook with three sheets. How to insert page number and running head in word 2010 how to#
How to put page numbers in multiple Excel worksheets You can also apply any watermarks to your sheets using the HEADER & FOOTER TOOLS, please see How to Add a Watermark to a Worksheet in Excel. Now, if you go to Print Preview, you will see the page number watermarks added in Excel according to the selected settings. You can also press Normal Button image on the status bar. Now you can reset back to Normal view if you click on the Normal icon under the View tab.
Click anywhere outside the header or footer area to display the page numbers. Click the Number of Pages icon in the Header & Footer elements group to see the placeholder & of & in the selected section. Please have a look at the screenshot below. Then enter the word " of" followed by a space. If you want to add the total number of pages, type a space after &. You'll see the placeholder & appear in the selected section. Go to the Header & Footer Elements group and click on the Page Number icon. You can choose any by clicking on the correct section box. You'll get the Design tab with Header & Footer Tools.īoth header and footer areas have three sections: left, right and center. Click within the field Click to add header or Click to add footer. You will see your worksheet in the Page Layout view. You can also click on the Page Layout Button image on the status bar in Excel. Go to the Insert tab and click on the Header & Footer in the Text group. Open your Excel worksheet that needs inserting page numbers. You can put page numbers for a single spreadsheet using the Page Layout view. Page markers are really useful if your worksheet is quite big and prints as multiple pages. Insert page numbers in Excel on one worksheet Change the order in which page numbers are added. Customize page numbering for the starting page. 
How to put page numbers in multiple Excel worksheets.Insert page numbers in Excel on one worksheet.Please also remember that you can always see how your printed pages will look in the Print Preview mode. You can also define any number for your starting sheet if the default settings don't work for you. These options allow adding page numbers for one or several worksheets. You can insert numbers using the Page Layout view and the Page Setup dialog box. You can also select if they will appear in the left, right or central part. It's possible to add them in the sheets' headers or footers. I'll show you how to put page numbers in Excel. When you print an Excel document, you may want to display numbers on the pages. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly. This article explains page numbering in Excel 2019, 2016-2010.
0 kommentar(er)
