Page numbering method of type 1/2 in Excel

The page numbering on 1/2 in Excel is similar when you number Excel pages in integers with a simple way.

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.

  1. How to type pages in Word 2010
  2. 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.

Page numbering method of type 1/2 in Excel Picture 1Page numbering method of type 1/2 in Excel Picture 1

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.

Page numbering method of type 1/2 in Excel Picture 2Page numbering method of type 1/2 in Excel Picture 2

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.

Page numbering method of type 1/2 in Excel Picture 3Page numbering method of type 1/2 in Excel Picture 3

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.

Page numbering method of type 1/2 in Excel Picture 4Page numbering method of type 1/2 in Excel Picture 4

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.

Page numbering method of type 1/2 in Excel Picture 5Page numbering method of type 1/2 in Excel Picture 5

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.

Page numbering method of type 1/2 in Excel Picture 6Page numbering method of type 1/2 in Excel Picture 6

The number of Excel pages in 1/2 style will be as shown below.

Page numbering method of type 1/2 in Excel Picture 7Page numbering method of type 1/2 in Excel Picture 7

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:

  1. How to create Header in Microsoft Excel
  2. Inserting letters, logos sink into Microsoft Excel 2013
  3. How to insert text into images in Excel

I wish you all success!

5 ★ | 3 Vote