In this material, we will look at how to makepage numbering 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.
The page numbering in Excel is carried out inmarkup mode or via the "Options" dialog box. Consider the first option. In markup mode, select the sheet on which you want to specify the number. Go to the tab called "Insert". Choose the "Text" section. We use "Headers and footers". We proceed to the next stage. On the sheet, select the bottom or top header. Determine the place in which you want to specify the numbering. Go to the tab called "Designer". Open the section "Elements of headers and footers". 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 section "Book views". We use the option "Normal".
The page numbering in Excel can be carried outalso 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. You need to perform the basic actions 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]".
The page numbering in Excel is especially useful,if the sheet contains many lines and it is planned to print. 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.