How to number pages in Excel very quickly and easily
Numbering pages in Excel has many ways to do and insert many different types of Excel page numbers. Page numbering in Excel will be fundamentally different from inserting page numbers in Word.
The article below will guide you how to number pages in Excel.
1. How to number Excel pages from Page Setup
Step 1:
At the Excel interface, click on the Page Layout tab and then click on the arrow in the right corner in this settings group.
Step 2:
The Page Setup dialog box appears, click on the Header/Footer tab . Here users can choose to insert Excel page numbers at the top of the page, by clicking Custome Header. If you want to insert at the bottom of the page, click Customer Footer. Here I choose to insert at the bottom of the footer, so click Customer Footer .
Step 3:
The Footer dialog box appears. You will have 3 locations to place page numbers including Left section (left), Center section (middle), Right section (right). If you want to place the page number position, place the mouse cursor there and then click the Insert Page Number icon as shown below.
Step 4:
Immediately appears &[Page] in the position we selected before, click OK to complete.
Step 5:
Click OK to close the Page Setup interface. Now to check whether the page number has been inserted into Excel or not, click the Office icon on the interface and then select Print > Print Review .
Users will see page numbers appear in the document interface.
2. How to number Excel pages from any number
When numbering pages from any number, you can choose the sequential number you want for the page numbers. It is not required to number pages from number 1 because you can skip the introduction page, for example.
You also access Page Setup and in the First page number section, enter the page number you want to fill in.
We refer to the article How to number Excel pages from any number to know how to do it.
3. Number Excel pages using Excel Header/Footer
Inserting Header in Excel or inserting Footer in Excel is also very familiar to us. And in addition to adding information for Header and Footer, you can immediately insert page numbers.
Step 1:
On the Excel page, click Insert then look at the Text group and select Header/Footer .
Step 2:
Next click Page Number to insert the page number as shown below.
Step 3:
Immediately after that, choose the location where you want to place the page number and the page number will display in the Excel page.
4. Instructions for inserting page numbers in 1/2 style in Excel
Inserting page numbers in Excel 1/2 style applies to pages with the same content in 1/2 and 2/2 styles.
We will use the 1/2 page numbering character in Excel to set up.
You will click on the Insert Page Number icon and the / icon then click on the Insert Number of Pages icon .
Follow detailed instructions in the Instructions for numbering pages 1/2 on Excel.
5. Number Excel pages via View mode
This is also how to number Excel pages via Page Layout, but you access it from View mode. You will then see the option to number pages at the top or footer.
Then we can also choose the position to insert the page number we want to use.
Video tutorial on inserting page numbers in Excel
You should read it
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- How to keep Excel and Excel columns fixed?
- What is ### error in Excel? how to fix ### error in Excel
- How to display 0 in front of a number in Excel
- Instructions for searching and replacing in Excel tables
- MS Excel 2007 - Lesson 2: Customizing in Excel
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- Shortcut guide, abbreviated in Excel
- Microsoft Excel test P5