In this material, we'll look at how to number the pages in Excel. In documents of this type, the relevant data can be specified on the sheet footers. Page numbering in "Excel" is visible after printing or in the markup mode. The order is set automatically. However, the numbering parameters can be changed. By default, it starts with the first page from the unit. Read more.
Layout
Page numbering in "Excel" is carried out in the markup mode or through the "Parameters" 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". Proceed to the next stage. On the sheet, select the bottom or top header. Determine the place where you need to specify the numbering. Go to the tab called "Designer". Open the section "Elements of headers and footers". We select the "Page number". On the specified site there will be an inscription "& [Page]". To leave the markup mode, go to the tab called "View". Open the "View book" section. We use the option "Normal".
Options
The page numbering in Excel can also be done in a different way. In this case, you should refer to the "Page Setup" window. Select the sheet on which you want to set the data. The "Page layout" tab is required. Go to the "Settings" section. The basic steps need to be performed here. Click the button next to "Page Setup". In the appeared window we pass to the tab "Headers". Then follows another important step. Click "Create a header" (if necessary, lower). Next, specify the location for inserting the number. On the specified site there will be an inscription "& [Page]".
additional information
Page numbering in "Excel" is especially useful if the sheet contains many lines and it is planned to print it. You can also switch from one view mode to another by selecting the markup in the status bar. The number can be displayed in the right, center, or left area of the footer. To number the pages sequentially on each of the worksheets, you must change the seed number. Note: if you do not see the tab of the required sheet, you can find it 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 one.