In this article we will look at how to make page numbering in Excel. In documents of this type, the corresponding data can be indicated on the page headers. The page numbering in Excel is visible after printing or in layout mode. The order is set automatically. However, the numbering options can be changed. By default, it starts on the first page with a unit. Details below.
Markup
Page numbering in Excel is done in layout mode or through the Options dialog box. Consider the first option. In the markup mode, select the sheet on which you want to specify the number. Go to the tab called "Insert." Select the "Text" section. We use "Headers and footers". Go to the next step. On the sheet, select the footer or header. Determine the place where you need to specify the numbering. Go to the tab called "Designer." Open the section "Header and footer elements". Select the "Page Number" item. “& [Page]” will appear on the indicated area. To leave the layout mode, go to the tab called “View”. We open the section "Presentations of the book." We use the “Normal” option.
Parameters
Pagination in Excel can also be done in another way. In this case, you should refer to the "Page Settings" window. Select the sheet on which you want to put the data. The page layout tab is required. Go to the "Parameters" section. The main actions must be performed here. Click the button next to Page Setup. In the window that appears, go to the "Headers and Footers" tab. The following is another important step. Click "Create header" (if necessary, footer). Next, indicate the place to insert the number. “& [Page]” will appear on the indicated area.
additional information
The page numbering in Excel is especially useful if the sheet contains many lines and it is planned to print. The transition from one view to another can also be done by selecting markup in
the status bar. The number can be displayed in the right, central or left footer area. To consecutively number the pages on each sheet of a book, you need to change the starting number. Please note: if the tab of the required sheet is not visible, it can be found using the scroll buttons. If necessary, select several pages. To do this, click on the first sheet, hold down the SHIFT key and mark the last.