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 "Book Views". We use the “Normal” option.
Parameters
«» . « ». , . « ». «». . « ». «». . « » ( , ). , . «&[]».
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.