Buzz
In essence, numbering pages 1/2 in Excel is similar to numbering pages in Excel that Mytour has previously provided guidance on. If you haven't explored this issue, you can refer to how to number pages in Excel here and follow the instructions.
In this article, we're still talking about page numbering but it's page numbering 1/2 in Excel. This means that we can number pages as desired and number pages according to the overall list, such as page 1/3, page 2/3 instead of displaying pages 1, 2, 3 as before. You can apply this feature to number pages 1/2 in Excel 2016, 2013, 2010, 2007, 2003.
Guide on How to Number Pages 1/2 in Excel
1. Numbering Pages 1/2 in Excel 2016, 2013
Step 1: To number pages 1/2 in Excel 2016, 2013, simply go to the Page layout section and then select Page Setup.
Step 2: In Page Setup, go to the Header / Footer section and choose Custom Footer.
Step 3: Here you can choose the desired position to place the page number, but typically it's on the right side. After clicking on the Right section, select the icon named Insert Page Number.
Step 4: After Inserting Page Number, add the character '/' to differentiate, then click on the adjacent icon named Insert Number of Pages.
After these actions, press OK to confirm numbering pages 1/2 in Excel.
Step 5: Finally, click on Print Preview to preview the results you just configured.
And as you'll notice, instead of displaying Page 1, 2, 3, it will now show 1/4, 2/4, and depending on the total number of pages in your Excel file.
2. Numbering Pages 1/2 in Excel 2010, 2007
Step 1: Similar to Word 2016, 2013, to number pages 1/2 in Excel 2010, 2007, go to the Page layout section and then select Page Setup.
Step 2: Then, go to the Header / Footer section and choose Custom Footer.
Step 3: Then click on the Right section, and choose the icon as shown in the picture named Insert Page Number.
Step 4: After Inserting Page Number, add the character '/' to differentiate, then press on the adjacent icon named Insert Number of Pages.
Next, click on Print Preview to preview the results you just configured.
After that, you will see instead of displaying Page 1, 2, 3, it will now show 1/3, 2/3, and depending on the total number of pages in your Excel file.
3. Numbering Pages 1/2 in Excel 2003
Step 1: To number pages 1/2 in Excel 2003, go to File > select Page Setup.
Step 2: Then, go to the Header / Footer section and choose Custom Footer.
Step 3: After that, click on the Right section, and choose the icon as shown in the picture named Insert Page Number.
Step 4: After Inserting Page Number, add the character '/' to differentiate, then press on the adjacent icon named Insert Number of Pages.
Step 5: Finally, when you've added everything, just press OK to confirm the setting of numbering pages 1/2 in Excel.
After that, click on Print Preview to review the setup before actually numbering pages 1/2 in Excel.
The result you'll see will display Page 1, 2, 3, but now it will show 1/4, 2/4, and depending on the total number of pages in your Excel file.
With the guidance above, we hope readers have gained a brief understanding of numbering pages 1/2 in Excel 2016, 2013, 2010, 2007, 2003. Of course, this feature offers many other settings that you can explore in this section. Let us know if you discover any new features in this section or in Excel.
In addition to numbering pages 1/2 in Excel, you can also do the same with numbering pages in Word. This feature is quite similar between Excel and Word, but numbering pages in Word is used much more frequently than in Excel. Therefore, understanding this feature in Word is essential.
