Here's how to do it:
- Navigate to the View main menu and select the Page Layout option.
- Scroll down and click on Add Footer.
- Under the Header & Footer Elements section, click on the Page Number.
- Once you click on page number, you can see the text “&[Page]” in the footer section.
- Click anywhere in Excel and you can see the numbers populating in the selected partition of the header or the footer.