Microsoft Office 2016: The Complete Guide (2015)

ADD AND DELETE PAGE NUMBERS ON WORKSHEETS

When you want to show the page numbers on a Microsoft Excel print, these numbers can be added to the pages in either the headers or footers of the worksheet pages.

How to Add Page Numbers on a Single Worksheet?

The required steps are as follows:

Select the worksheet that you want to number.

Located on the insert tab is the Text group, select Header & Footer

On the worksheet, Select Add Header or Add Footer.

To determine where in the header or footer you want the page number to be, click inside the Left Region, Centre Region or Right Region box of the Header or Footer.

Located inside the design tab, there you will find the Header & Footer Elements groups, select Page Number.

The placeholder [Page] will now be displayed in the selected section.

TIP: If it is that you want to add the total number of pages, press space after &[Page], type the word and then press space. Now click Number of Pages in the Header & Footer Elements groups.

To allow for the page numbers to be shown on the page in Layout View, select anywhere outside the Header or Footer region.

After you have finished modifying Page Layout View, which is found on View tab, in the workbook views group, select the option Normal. The choice is given to users to select Normal is also found on the status bar.

TIP: You can insert page numbers for a worksheet in the form of Page Layout View, which gives you the option to view them or you can use the Page Setup Dialog Box if you want to insert page number for more than one worksheet at a time. As for additional sheet types which includes chart sheets. You can insert page number only by using the Page Setup Dialog box.

Add Page Numbers on Multiple Worksheets.

Thanks to the Page Setup Dialog box, page numbers can now be inserted on different worksheets in a single workbook. For instance, if a single workbook contains three worksheets, each page in each worksheet will be numbered pages 1,2 and 3.

TIP- In order to add page numbers to every worksheet in a workbook in chronological order, you have to change the number that each worksheet starts with. Not to fear, set a Different Number for the Starting Page gives more detailed guidelines on how to carry out this task.

To add page numbers on multiple worksheets: - the following steps are crucial.

Select the worksheets or chart sheets that you want to add the Page Numbers to.

To select a single sheet, select the sheet tab. Do not be alarmed if your desired tab is not on display, select the tab scrolling buttons to show the tab then select the tab.

To select two or more adjacent sheets, you will firstly need to select the tab or the first sheet, after that hold down shift while you click on the tab for the last sheet you would like to select.

To select two or more adjacent sheets, click the tab, then hold down CTRL while at the same time selecting the tabs of the other sheets that you want to select.

To select every sheet in a workbook right click a sheet tab, then select All Sheets.

TIP: - Whenever you select numerous worksheets [Group] is displayed in the title bar at the top of the worksheet. In case you want to cancel a collection of selected worksheets in a workbook, select any worksheet that wasn’t selected. If there are no visible unselected worksheet, right click the tab of a selected sheet, and click Ungroup Sheets.

Select the Dialog Box Launcher which is located in the Page Setup group on the Page Layout tab.

In the Page Setup Dialog box, on the Header/Footer tab, click either Custom Header or Custom Footer.

In order to specifically where in the header or footer you want to put page number, select inside the Left section, Centre section or Right section box.

If you want to insert numbers, click the insert Page Numbers button.

The placeholder &[Page] appears in the selection section.

PLEASE NOTE: In case you want to calculate the total number of pages, type a space after & [Pages], type the word of, then press space and then click the Insert number of pages’ button.

The placeholder & [Page] of & [Page] appears in the selected section.

How to Set a Different Number for the Starting Page?

If you want to number all of the worksheet pages in a workbook to be chronological order, firstly page numbers should be assigned to all worksheets in a workbook. The next step would be to use the following method to begin the page number for each worksheet with the appropriate number. For instance, if your workbook contains three worksheets that would be printed as three pages this could be resourceful to begin page numbering for the third worksheet with the number 5.

On the Page Layout table, where the Page Setup group is located, select the Dialog Box Launcher.

On the Page tab, in the first number that you were going to use for the first page.

ADVICE: - To be able to take advantage of the default numbering system, you will need to type Auto in the first page number box.

Change the Order in which Pages are numbered.

Although Excel numbers and print pages from the top down and then left to right on the worksheet automatically, you still have the ability to change the direction to print pages and numbers in the opposite way. Which is from left to right and then from the top down. Firstly, you will need to select the worksheet for which you want to change the numbering order. Secondly, you want to go on the Page Layout tab, inside the Page Setup groups and select the Dialog Box Launcher.

Finally, on the sheet tab which is located underneath Page order, click down then over, then down.

Select the worksheets or chart sheets for which you want to remove page numbers. The following steps are required for different worksheets and chart sheets.

To select a single sheet, select the sheet tab. Don’t be alarmed if your desired    tab is not on display, select the tab scrolling buttons to show the tab then select the tab.

To select two or more adjacent sheets, you will firstly need to select the tab or the first sheet, after that hold down shift while you click on the tab for the last sheet you would like to select.

To select two or more adjacent sheets, click the tab, then hold down CTRL while at the same time selecting the tabs of the other sheets that you want to select.

Whenever multiple worksheets are selected [Group] will be displayed in the title bar. Which is located above the worksheet. In order to carry out any selection of several worksheets in any workbook, select any unselected worksheet visible. Then right-click the tab of a selected sheet, and then click Ungroup Sheets.

On the Page Layout View, in the Page Setup group, select Dialog Box Launcher.

On the Header/Footer tab, in the Header or Footer drop-down box, select [None]. If this isn’t visible, then it is likely that you may have to scroll to the top of the list to click [None].