How to number Excel pages from any number
With references, textbooks, or Excel spreadsheet calculations, there will be more operations to insert page numbers in Word or insert page numbers in Excel. There are many styles of inserting the number of pages that users can perform such as inserting the number of Word pages from any page, inserting the number of pages on the parity, inserting a page number of 1/2 in Excel. So what if I want to insert the Excel page number from any number, but not 1?
By default when creating a page number in Excel, the first page is always automatically numbered 1. However, many people have the need to start the first page with a number of other pages, not automatically number 1 in the way usually, common, normal. The following article will guide you how to insert Excel page numbers from any number.
- How to number page combination i ii iii and 1, 2, 3 on Word
- How to number columns automatically in Excel
- Instructions for inserting page numbers on PowerPoint
- How to create Header in Microsoft Excel
How to number Excel pages from any number
Step 1:
At the interface in Excel, click on Page Layout and select the arrow icon below as shown to open the Page Setup interface.
Step 2:
Displaying the new interface in the First page number section we enter the page number you want to start. For example, enter the number 3 for the first page of Excel.
Step 3:
Click on Header / Footer then select the place you want to insert the page number. If you want to insert a page number at the top of the page, click Custom Header. If you want to insert a page number at the end of each page, click Custom Footer.
Step 4:
For example, choose to insert the page number under each footer. In the Footer interface, select the location of the page number, including the Left section (left), Center section (center), Right section (right). In which position the user wants to number the page, place the cursor on the position then select the Insert Page Number icon as shown below.
Immediately afterwards display & [Page] in the selected location, the user clicks OK to complete the page numbering.
Step 5:
After finishing the page numbering on Excel, unlike Word will display right on the content, the user must print it out or click Preview to see it. Press Ctrl + P or click the File tab, choose Print to check.
The other numbered first page of Excel you choose here is number 3.
Any number of Excel page operations are simple. You just need to set the number of pages you want to start at the Page section, and then insert the Excel page number as usual.
I wish you all success!
You should read it
- How to insert page numbers in Excel
- Page numbering in Excel does not start from 1
- How to number page combination i ii iii and 1, 2, 3 on Word
- How to number a PDF page
- Page numbering in Excel does not start with number 1
- Number the page for the text in Word
- How to style pages symmetrically on Word
- How to number pages on Word 2013
May be interested
- How to quickly see the total number of pages of Word files?you have dozens or even hundreds of word files on your computer and you want to know the total number of pages of each file. however, if opening each file will take a lot of time, so is there a way for you not to open and still know the total number of pages? today, tipsmake.com will guide you how to quickly see the total number of pages of word files.
- How to number pages without first page in WPS Officewhen editing documents using docs in wps office, many people want to number pages from the second page, skipping the cover page or table of contents. if you do not know how to do it, the following article from tipsmake.com will guide you in detail on how to number pages skipping the first page in wps office.
- Number pages in Word 2013, insert page numbers automaticallyto number pages on word 2013, we also perform the same operation as when numbering pages on word 2007, or numbering pages on 2010.
- How to number pages in WPS Officewps office is a lightweight, convenient office suite, especially with the docs application that fully supports editing features. if you are looking for a way to number pages in wps office, let's explore the detailed instructions below with tipsmake.com.
- How to cut a PDF file into any small number of pagesyou want to split pdf files into any number of small pages to facilitate the exchange of files with friends faster instead of having to send an entire pdf file. in this article, tipsmake.com would like to guide you how to cut pdf files into many small pages quickly and accurately.
- How to change worksheet size in Excelexcel has settings for you to resize the spreadsheet, adjusting it to display all columns and rows on the same page. or if needed, users can also adjust the number of printed pages displayed for preview before printing.
- How to number pages in word (from the beginning or any page)for long documents in word, page numbering is essential to make it easier for you to search and edit text. the article shows you how to number pages from beginning to end of word documents and how to number pages from any position in the text.
- How to display 0 in front of a number in Excelusually when we enter a sequence of numbers in excel that has a leading zero, it will disappear. so how to display 0 in the series in excel?
- Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excellet's refer to tipsmake.com's article on how to format pages and print spreadsheets in excel 2016!
- How to number a PDF pagepdf page numbers are not available as options for page numbering in word or page numbering in excel.