Lesson 85: How to use Page Number to number pages in Excel

This article shows you how to number pages (page numbers) in Excel.

How to use Page Numbers in Excel

1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.

2. Click Add footer.

3. On the Design tab, in the Header & Footer Elements group, click Page Number to add the page number.

4. Type “of”.

5. On the Design tab, in the Header & Footer Elements group, click Number of Pages to add page numbers.

Result:

6. Click somewhere else on the sheet to see the footer.

In addition, you can also view many other excel articles here.