EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Page Numbers in Excel
 

Page Numbers in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Page Numbers in Excel

 

 

Page Numbers in Excel

We come across data that needs to be printed. We put page numbers when we print the data and want it to be in order. Similar to MS Word, In Excel, we can also put page numbers on our documents when we print them.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Introduction:

As the name suggests, page numbers are used to order our documents when we print them. Suppose we want to start a new document and start it from where the previous document ended, let’s say it was page number 49. We can start numbering our new document from page number 50.

We insert Page numbers in a worksheet that do not display in a normal view. It is displayed in the Page Layout view, but it is visible when the document is printed on sheets of paper.

How to Insert Page Numbers in Excel? There are two ways to Insert Page Numbers into Excel:

  1. Insert Page numbers into a single worksheet.
  2. Insert page numbers into multiple worksheets.

We are going to learn both of them with examples.

When we insert page numbers in Excel by the above steps:

  • Go to View Tab & Page layout view.

Excel Page Number step 1

  • In the footers section, select any block; in the Design tab, under Header & footer controls, select Page number.

Excel Page Number step 2

  • After inserting the page number, type the word “Of” and then click on the Number of pages.

Excel Page Number step 3

  • Click on anywhere in the sheet, and the sheet is ready with the page numbers.

Excel Page Number step 4

  • Click Ctrl + P to print the document.

Excel Page Number step 5

The page print preview shows the document has page numbers.

  • After the document is ready with pages, click Normal Layout in the view tab.

How to Use Page Numbers in Excel?

These Insert Page Numbers are very simple and easy to use. Let us now see how to use the Page Numbers in Excel with the help of some examples.

Page Numbers in Excel Example #1

Insert Page numbers into a single worksheet.

You can download this Page Numbers Excel Template here – Page Numbers Excel Template
  • Click on the worksheet you want to insert the page number on.

Page Number Example 1

  • Go to View Tab, and Click on the Page Layout section.

Page Number Example 1-1

  • By default, the Normal view is selected in Excel; when clicked on the Page Layout view, an option appears for headers and footers.

Page Number Example 1-2

The above image appears at the top of the page. At the bottom of the page, we get an option to add footers.

Page Number Example 1-3

  • There are three blocks in the footer section. Click on any one of the blocks where you want to insert the page number.

Excel Page Number Example 1-4

I have written the “Third block” text inside the 3rd block to highlight the third block.

  • When we click on any one of the blocks, a design tab appears in Header & Footer Tools.

Page Number Example 1-5

  • The Design tab has an option for Page number & Number of pages.

Excel Page Number Example 1-6

  • Now in the block where we want to insert the page number and click “Page Number,” a code appears. Write the word “OF” after the code.

Page Number Example 1-7

  • Now again, in the design Tab, click on Number of Pages. Another code appears in the block after the word “OF.”

Page Number Example 1-8

  • Now click anywhere in the sheet, and the sheet is ready with page numbers.

Page Number Example 1-9

  • Our sheet does not contain any data; it shows the total number of pages as 0 and a null value for the page number.

Now let us practice with some data in the sheet.

Page Numbers in Excel Example #2

Our second sheet has columns A & B values up to cell 230.

Let us give a page number to this worksheet as well.

  • This data is on sheet 2, so we click on Sheet 2, named “Random Data.”

Page Number Example 2

  • Again, go to the view tab and click on the page layout section.

Page Number Example 2-1

  • Now the option pops up for headers & footers. The top section is for the headers, and the bottom is for the footers.

Page Number Example 2-2

Page Number Example 2-3

  • Click on any block of footers and then click on a Page number from the Design Tab.

Page Number Example 2-4

  • A code pops up in the block. Now type the word “OF” after the code.

Page Number Example 2-5

  • Again in the design tab of the headers and footers section, click on several pages. Another code pops up in the block after the word “Of.”

Page Number Example 2-6

  • Now click anywhere on the sheet, and the page number is ready for the worksheet.

Page Number Example 2-7

The worksheet has five pages, and the page number is first. Now let us learn to insert page numbers in multiple worksheets in the next example.

Page Numbers in Excel Example #3

There are two sheets of sheet 3 & sheet 4. We will try to insert page numbers on both worksheets.

Page Number Example 3

  • Hold control and click on sheet 3 & sheet 4 to select both sheets.

Page Number Example 3-1

  • In the view tab, click on a page layout.

Excel Page Number Example 3-2

  • A design tab appears; in the design tab in the headers & footers section, click on a page number in the third block.

Excel Page Number Example 3-3

  • Write the word “Of” and then click on the Number of pages in the Design Tab.

Excel Page Number Example 3-4

  • Another code pops up in the block after the word “Of.”

Page Number Example 3-5

  • Click anywhere in the sheet, and the page numbers are ready for both pages.

Page Number Example 3-6

The above image is for sheet 3 & the below image is for sheet 4.

Page Number Example 3-7

Explanation of Page Numbers in Excel:

  • Page number in Excel is a useful tool to organize the data if we need to have the data in printed form.
  • Page numbers in Excel data can be seen in Page layout form but not in Normal view.

Things to Remember

  • A page number is displayed in Page Layout View, not Normal View.
  • Footers have three blocks, and a page number can be inserted in any of them.
  • Once the Page number is inserted, it contains the page number when the document is printed.

We can choose the starting number for the page number from the following steps:

  • In the Page Layout tab, click on the button shown in the screenshot.

Page Layout Button

  • A page setup dialog box appears below:

Page setup

  • By default, the first-page Number is Auto; we can change it to the desired Number.

Page setup 1

Recommended Articles

This has been a guide on Page Numbers in Excel. Here we discuss how to Page Numbers in Excel, along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel –

  1. Page Setup in Excel
  2. Excel Insert Page Break
  3. Negative Numbers in Excel
  4. Excel ISNUMBER Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Page Numbers Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Page Numbers Excel Template

EDUCBA

डाउनलोड Page Numbers Excel Template

🚀 Limited Time Offer! - ENROLL NOW