Excel is one of the most widely used platforms for spreadsheet applications. For multiple spreadsheets, Excel offers a page number facility to organise your spreadsheets further.
When you insert page numbers in Excel, it lets you keep track of spreadsheets in case you plan to print them. In this article, we’ll learn how to add page numbers in Excel.
Here’s what we’ll cover:
Also read: How to add leading zeros in Excel?
Method 1: via Header and Footer option
You can use the Header and Footer option to add a page number on a single spreadsheet.
Step 1: Open the spreadsheet and click Insert, Header & Footer.
Step 2: Next, select the Header or Footer option depending on where you want to insert the page number and then select the type of header or footer. For example, we selected a simple page number type to display the page number. When you’re done, you’ll see the page number on the head or at the end of the spreadsheet.
Here’s what you will see if you select the Footer option:
Also read: How to enable and disable Excel autosave?
Method 2: via Page Layout
The Page Layout option is the second way to add page numbers in Excel. Here’s how to do this:
Step 1: Open the spreadsheet and click the downward icon in Sheet Options.
Step 2: Next, click on the Header/Footer option at the top and then select the downward button to select the header and footer type.
If you want to use a custom header or footer, click on the Custom Header or Custom Footer option and then write the header or footer as per your preference.
Also read: How to remove table formatting in Excel?
Method 3: Changing the starting page number
By default, Excel starts with the page number 1. However, you can change the starting page number if you want the worksheet to start with another page number.
Here’s how to do this:
Step 1: Open the spreadsheet, click Page Layout, and then click on the downward icon in front of Page Setup.
Step 2: Now, click Page and insert the page number in the Find page number box. When you’re done, press OK.
In conclusion, you can use any of the three methods to add page numbers in Excel. To add a random starting page number, head to method 3 or if you want to add page numbers to the workbook, use method 2. For inserting page numbers into a single sheet, follow method 1.
Also read: How to copy a formula in Excel?
