Numbering in Excel will be different from page numbering in Word, you will need to access the page management set on Excel to number page number in Excel. With Excel, users also have many different types of numbering such as numbering page number in Excel from any number, numbering Excel page 1/2. Depending on what you need to number your Excel page, we follow the instructions below.
How to number Excel page in order
Step 1:
First at the Excel interface, the user clicks Page layout pagethen click Arrow icon Below to expand the interface.
Step 2:
Display the interface as shown, at First page number We will Fill is 1 to number Excel page in order From 1.
Continue Click on the header/footer tab then selected later Select Custom Header or Custom Footer To number page number.
Step 3:
Switch to a new interface you Select the location you want to number page then click Insert page number Then click OK to enter Excel page number. Finally click OK to proceed to number page number in Excel.
The number of Excel pages also starts from the number of pages you choose in the order.
How to number Excel page from page setup
Step 1:
At the Excel interface click Tab Page layout then click on arrow on the right corner In this setup group.
Step 2:
There is a page setup dialog box appear Header/Footer tab. Here users can choose to insert Excel page number at the top of the page, by clicking on Custom 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 page Customer Footer.
Step 3:
Footer dialog box appears. You will have 3 positions to place the number of pages including Left Section (left), Center Section (in the middle), Right Section (right). If you want to place the page number, place the mouse pointer there and click Insert page number As shown below.
Step 4:
Immediately appear &[Page] In the position we have chosen before, Click OK To complete.
Step 5:
Click OK to close the page setup interface. Now to check if the number of pages has been inserted into Excel or not, click on the Office icon on the interface and then select Print> Print Priview.
Users will see the number of pages appearing in the document interface.
How to number Excel page from any number
When numbering from any number, you can choose the number you want for the page number, not required to number the page number 1 because you can skip the introduction page for example.
You also Visit the page setup and at First Page Number Friend Fill in the page number I want to fill it out.
We refer to the article how to number Excel page from any number to know how to do it.
Numbered Excel page with header/footer Excel
Insert header in Excel or insert footer in Excel is also very familiar to us. And in addition to adding information for header, footer, you can immediately insert the page number.
Step 1:
At Excel page you Click Insert Then look Text group select header/footer.
Step 2:
Next click Page number To insert the page number as shown below.
Step 3:
Right after that you Select the location you want to place the page number And the number of pages will display in Excel page.
Instructions for inserting pages 1/2 on Excel
Insert the number 1/2 pages in Excel applies to the case of the same pages together type 1/2 and 2/2.
We will use the number 1/2 page numbering in Excel to set.
You will click on Insert page number and icon / Then press on The Insert Number of Pages icon.
Monitor how to perform details in the number 1/2 number on Excel.
Numbering Excel page through view mode
This is also the number of Excel page numbering Page layout but you visit from the view mode. Then you will see the page numbering option at the top of the page or at the foot of the page.
Then we also choose the position of inserting the number of pages we want to use.
Instructions to remove page numbering in Excel
To remove the number of pages in Excel, you also open the page setup interface and then click on the Header/Footer tab. At the page number you have hit us Click None To remove the number of pages in Excel. Click OK to save the setup and delete the pages in Excel.
