Page numbering method of type 1/2 in Excel
Operating page numbering in Excel , or page numbering on Word, is a basic operation when we work with office documents. And when you number the page will be all integers, even if the page numbering is parity. So if you want to type page number 1 in Excel, how to do it?
That is, then you will number pages in a total of 1/2, 2/2 instead of numbering pages 1 and 2 as before. In fact, page numbering in type 1/2 in Excel is similar to when you number page numbers in Excel. The following article will guide you to read page numbering style in half in Excel.
- How to type pages in Word 2010
- How to type pages in Word 2007 from any page
Manual numbering page 1/2 in Excel
Step 1:
First, you need to click on the Page layout tab then on the Page Setup group, click on the arrow icon at the corner.
Step 2:
A new dialog box appears, click the Header / Footer tab, then select Custom Footer to insert the page number at the bottom of the Excel footer.
Step 3:
Then select the location where you want to insert the page number , for example, here will insert the page number to the right of the interface, so click on the Right section. Then click on the Insert Page Number icon above as shown below.
Step 4:
After pressing Insert Page Number, a page number input character will appear. If you use integers like 1, 2, 3 to page numbers, you can immediately enter the number in this section. However, for page numbering in type 1/2, you need to insert / to distinguish as follows.
Next, users will click on Insert Number of Pages icon to add the next page character. As a result, you will be shown the number of page 1/2 in Excel.
Step 5:
Click Print Preview to preview the number of pages in Excel, 1/2, 2/2, . depending on the total number of Excel documents.
The number of Excel pages in 1/2 style will be as shown below.
The numbering of type 1/2 in Excel is similar to the numbering of pages in Excel. We only need to create 2 prefixes for the number of pages to be numbered 1/2.
See more:
- How to create Header in Microsoft Excel
- Inserting letters, logos sink into Microsoft Excel 2013
- How to insert text into images in Excel
I wish you all success!
You should read it
- How to number pages in all versions Excel (update 2020)
- Page numbering in Excel does not start from 1
- How to insert page numbers in Excel
- How to number page combination i ii iii and 1, 2, 3 on Word
- How to number pages on Word 2013
- How to number a PDF page
- Page numbering steps in Microsoft Word Microsoft
- Number the page for the text in Word
May be interested
- Number pages in Word 2003, insert special characters, date and time into Wordpage numbering in word 2003 makes it easy to set up automatic indexing, find the content you need quickly. this is the simplest page numbering guide on word 2003.
- How to type page numbers in Word 2016page numbering with multiple display options, typing from any page and other useful options in word 2016.
- Word 2013 Complete Guide (Part 14): Page title, footer and page numberingbelow is a tutorial on how to create page title, footer and page numbering in word 2013. please refer!
- Numbering in Excel 2016numbering in excel is a great feature that excel supports to help users work effectively and reach the fastest speed. the following article provides detailed instructions for numbering in excel 2016.
- How to Number Pages in Canvapage numbering in canva makes it easier for users to follow and shows professionalism when you create presentation slides in canva.
- Page numbering in Word 2016page numbering is an indispensable operation and very important for long text. the following article provides detailed instructions for page numbering in word 2016.
- How to number pages from any page on Word 2007,2010,2013tips to help you know the common page numbering in word. as well as page numbering from any page in the document. good luck!
- How to number columns automatically in Excelin excel, there is an automatic column numbering feature, so users will not need to perform the dragging of the order as usual.
- How to number page combination i ii iii and 1, 2, 3 on Wordpage numbering combines i ii iii and 1,2,3 in word frequently encountered when making documents, essays, reports, ...
- Numbering in Excelnumbering the data in an excel spreadsheet is very necessary, instead of having to enter the numbers from the beginning to the end, you can do some quick operations to automatically number the order. self for excel spreadsheet.