1. On the “Summer Bookings” worksheet, clickHeader & Footerfrom theTextgroup situation on theInserttab.

2. ClickClick to add footerwhich would display theHeader & Footertools which gets added to theDesigntab.

3. Specify where the page number should be by selecting theCenter sectionbox.

4. On theDesigntab in theHeader & Footer Elementsgroup, clickPage Number.

5. The placeholder&[Page]will appear in the selected section, to add the total numberofpages type the word of followed by the space in theHeader & Footer Elementsgroup after clickingNumber of Pages, then the placeholder&[Page] of &[Pages]appear.

6. Click anywhere outside the header or footer area to display the page numbers inPage Layout View.

7. Once you are done working in thePage Layout View, clickNormalin theWorkbook Viewsgroup situated on theViewtab. OR You can also clickNormalon the status bar.

References:

https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7-BF957C6CE29C