This example will teach you how to print page numbers in Excel.
- On the Advanced tab View (View) click Page Layout (Page Layout) to switch to Page Layout mode.
- At the bottom of the page click on Click to add a footer (Footer).Tab group activated Header & Tools (Working with footers).
- To add a page number, click the button Page Number (page number) tab Design (Constructor). The text will appear in the footer field. &[Page] or &[Page] – for the version of Excel.
- In the same field, after the inscription, enter “from”.
- Now click on Number of Pages (Number of Pages) tab Design (Constructor) to add the number of pages.
Note: Excel uses codes to automatically update the header or footer as changes occur in the workbook.
- Click anywhere else on the sheet to see the headers and footers.
Note: In a command group Options (Settings) tab Design (Designer) you can include a custom header for the first page, or different headers for even and odd pages.
- Нажмите кнопку Normal (Regular) tab View (View) to return to normal mode.