It is very easy for you to insert page number in Excel. We are going to do it together.
How to insert text?
You would follow us as we insert a page number.
Click on insert
Click on text on the right side.
Adding a footer
Choose "Header and Footer", after clicking on the arrow beneath the text in step two.
Click on Number of pages
Note: Click on number of pages if you'd have multiple pages.
Click on an empty cell in any of the columns.
The 0 was showing &[pages] prior to clicking on an empty cell.
Note: To ensure that the page numbers appear on every page of the printed worksheet, you may need to set up page breaks or adjust the print area. To do this, go to the "Page Layout" tab on the ribbon and use the "Page Setup" section to set up your print area and page breaks.
The View Ribbon menu
Alternative method is to start from View menu in the Ribbon.
The full path would be: View > Page Layout.
The next step is to scroll down. At the bottom of the page select Click to add footer option.
From the Design Ribbon menu pick Page Number and Number of Pages options this time.
In the footer you should see &[Page]&[Pages] now. My proposal is to format it. I prefer &[Page] out of &[Pages].
At this point you can add more information to the Footer such as:
- Current Date
- Current Time
- File Path
- File Name
- Sheet Name
After you are done go to the Ribbon again and swith the view by clicking View > Normal.