adding page number to excel 2010
Step 2: Click the Insert tab at the top of the window. Step 3: Click the Header & Footer icon in the Text section of the ribbon at the top of the window. Step 4: Click the header section to which you want to add the page number. Step 1: Open the spreadsheet to which you want to add page numbers in Excel 2010. Step 2: Click the Insert tab at the top of the window. Step 3: Click the Header & Footer icon in the Text section of the ribbon at the top of the window. Step 4: Click the header section to which you want to add the page number. Click the worksheet for which you want to insert page numbers. On the Insert tab, in the Text group, click Header & Footer. Note Excel displays the worksheet in Page Layout view. You can also click Page Layout on the status bar to display this view. On the worksheet, click Click to add header or Click to add footer. **I am adding page numbers to the header for this tutorial, but you could also follow the directions to add page numbers to the footer as well.**. Step 1: Open the spreadsheet to which you want to add page numbers in Excel 2010. Step 2: Click the Insert tab at the top of the window. In the Page Setup dialog box, on the Header/Footer tab, click Custom Header or Custom Footer. 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. To insert numbers, click the Insert Page Number button. To insert page numbers in Microsoft Excel follow the below mentioned steps:-. 1  Go to the “Page Layout” tab. 2  In the “Page Setup” group click on the dialog box launcher in the bottom right corner. 3  The Page Setup dialog box will appear. 4  Select the “Header/Footer” tab. Insert page numbers in Page Layout view. Click the worksheet for which you want to insert page numbers. On the Insert tab, in the Text group, click Header & Footer. Note Excel displays the worksheet in Page Layout view. On the Insert tab, in the Text group, click Header & Footer. Note Excel displays the worksheet in Page Layout view. You can also click Page Layout on the status bar to display this view. On the worksheet, click Click to add header or Click to add footer. Step 3. Click the View tab on the upper side of the Excel window. Step 4. If in Normal View mode, click Page Layout on the upper left, below the tabs, to switch to Page Layout view; this will allow you to see the numbers on screen. Step 5. Click the Insert tab on the upper left side of the Excel window. 3. On the Design tab, click Page Number to add the page number. 4. Type  of . 5. On the Design tab, click Number of Pages to add the number of pages. Note: Excel uses codes in order to automatically update the header or footer as you change the workbook.