Also, you do not wish to display “Page” and only want the page number. Suppose you want to add a title on the left side of the footer and a page number in the center.Go to “Custom Header” or “Custom Footer.” First, let us select the “Custom Footer.”.In the “Page Layout” tab, select a dialog box launcher given next to the “Page Setup” menu.In method 2, you can follow the following steps: In method 1, you can directly specify on which side the page number is displayed. You can choose which direction to display the header or footer (page number) left, right, or center. There are different formats to insert the page numbers in Excel, such as: Different Formats to Insert Page Numbers in Excel Note: When you select more than one sheet, “Group” will be displayed along with the worksheet’s name as “” at the top. For example, suppose you have two worksheets in which you want to add the page numbers. This type of method (Method 2) is used to insert page numbers when you want to insert page numbers in multiple sheets. Step 4: Then, click on the “OK.” You will notice that the page number has been added.There will be a preview that will show how the page number will appear. This selection can be made by scrolling down the menu. Step 3: To insert the page number in the Excel worksheet, select “” in the “Header“ if you want to add a page number as a header, or select “” in the “Footer“ if you want to add a page number as a footer.Step 2: Go to the “Header/Footer” tab in this pop-up window.You will notice that a “Page Setup” dialog box will appear. In the “Page Setup” menu, click the dialogue box launcher given next to the “Page Setup” menu. Step 1: First, add the “Header & Footer” to the worksheet, then go to the “Page Layout” tab.Let us now see another example of inserting page numbers in Excel. To do this, go to the “View” tab, and click on “Normal” given in the “Workbook Views” group. You can now go back to the normal mode of display.The page number will appear when you click outside of this selected box.You can skip clicking “Page Number” and add “&” to the area where you want the page number to appear on the page. You will notice that & will appear in the selected section.But, first, let us select the left area in the footer. Click on “Page Number” to insert the page number in the (above) specified section of the header/footer.You can also do the same to specify the position in the header. To add the center footer, click the “Center section” box. To add the footer on the right side, click on the “Right section” box. To add a footer, click on the “Footer.” To add the footer on the left side, click on the “Left section” box.In addition, it will also display the “Header & Footer” tools in the “Design” tab. Upon clicking, it will add a “Design” tab.You can now click “Add header” or “Add footer” on the worksheet.The worksheet display will automatically change to the page layout view after clicking “Header & Footer.” Go to the “Insert” tab and select “Header & Footer,” given in the “Text” group.First, enter the Excel worksheet where you want to insert page numbers.