EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Page Numbers in Excel

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Excel Tips » Page Numbers in Excel

Page Numbers in Excel

Page Numbers in Excel (Table of Contents)

  • Page Numbers in Excel
  • How to Insert Page Numbers in Excel
  • How to Use Page Numbers in Excel?

Page Numbers in Excel

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

Start Your Free Excel Course

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

Introduction:

As the name itself 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.

There are two ways to Insert Page Numbers to Excel:

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

We are going to learn both of them with examples.

How to Insert Page Numbers in Excel?

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

Popular Course in this category
Sale
Excel Training (21 Courses, 9+ Projects)21 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (10,706 ratings)
Course Price

View Course

Related Courses
Excel Data Analysis Training (15 Courses, 8+ Projects)Excel for Finance Training (18 Courses, 7+ Projects)
  • Go to View Tab & Page layout view.

Excel Page Number step 1

  • In the footers section, select any block, and 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 on Normal Layout in the view tab.

How to Use Page Numbers in Excel?

These Insert Page Numbers is 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 to 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, 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 on 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 a text “Third block” 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

  • In the Design tab, there is an option of Page number & Number of pages.

Excel Page Number Example 1-6

  • Now in the block where we want to insert page number and click on “Page Number”, a code appears in the block. 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 on anywhere in the sheet, and the sheet is ready with page numbers.

Page Number Example 1-9

  • Currently, our sheet does not contain any data, so; it shows a total number of pages 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 values in column A & B 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 as “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 section is for 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 a number of 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

There are a total of five pages in the worksheet, and the page number is first. Now let us learn to insert page numbers in multiple worksheets at once 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 the 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

  • Now click anywhere in the sheet, and 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 number 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 in Normal view.
  • Footers has three blocks, and a page number can be inserted in any one of them.
  • Once the Page number is inserted, when the document is printed, it contains the page number.

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

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

Page Layout Button

  • A page setup dialog box appears as 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

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Tips
    • Recover Document in Excel
    • Excel Shortcut to Select Row
    • Excel Header Row
    • Excel Insert Button
    • Excel Translate
    • Budget in Excel
    • KPI Dashboard in Excel
    • Blank Invoice Excel Template
    • Write Formula in Excel
    • Auditing Tools in Excel
    • Autofit Row Height in Excel
    • Formatting Text in Excel
    • Add Rows in Excel Shortcut
    • Divide Cell in Excel
    • Compare Two Columns in Excel for Matches
    • Excel Troubleshooting
    • Unprotect Excel Workbook
    • Subtract Date in Excel
    • Carriage Return in Excel
    • Negative Numbers in Excel
    • Worksheets in Excel
    • Excel Match Multiple Criteria
    • Exponential Moving Average Formula
    • Sentence Case in Excel
    • Excel Reverse Order
    • Excel Timesheet Template
    • Weighted Average in Excel
    • CTRL Shift-Enter in Excel
    • Excel Expense Tracker
    • INDEX MATCH Function in Excel
    • Percent Change in Excel
    • Drag and Drop in Excel
    • Shade Alternate Rows in Excel
    • Excel Database Template
    • Inverse Matrix in Excel
    • New Line in Excel Cell
    • Format Cells in Excel
    • Excel Text with Formula
    • Project Management Template in Excel
    • Vlookup vs Index Match
    • Embedded in Excel
    • Count Colored Cells in Excel
    • Excel Hacks
    • Column Header in Excel
    • Database Function in Excel
    • Excel Spell Check
    • Linear Interpolation in Excel
    • Convert Excel to CSV
    • Excel Not Responding
    • Delta Symbol in Excel
    • Excel Mortgage Calculator
    • Excel Show Formula
    • Break Links in Excel
    • VLOOKUP Examples in Excel
    • Alternate Row Color Excel
    • Checklist in Excel
    • Microsoft Office Tips
    • Excel vs Access
    • Excel Change Case
    • Count Characters in Excel
    • Formula Bar in Excel
    • Invoice Template in Excel
    • Find and Replace in Excel
    • PowerPivot in Excel
    • Wildcard in Excel
    • Line Break in Excel
    • NULL in Excel
    • Text Formula in Excel
    • Family Tree in Excel
    • Insert Calendar in Excel
    • Page Setup in Excel
    • Search For Text in Excel
    • Switching Columns in Excel
    • 3D Cell Reference in Excel
    • Roadmap Template in Excel
    • Cell References in Excel
    • Excel Automation
    • Matching Columns in Excel
    • Evaluate Formula in Excel
    • How to Find Mean in Excel
    • How to Add Cells in Excel
    • Project Timeline in Excel
    • TODAY Formula in Excel
    • Poisson Distribution in Excel
    • YEAR Formula in Excel
    • REPLACE Formula in Excel
    • Create Spreadsheet in Excel
    • SEARCH Formula in Excel
    • HYPERLINK Formula in Excel
    • Pivot Table with Multiple Sheets
    • COLUMNS Formula in Excel
    • DAY Formula in Excel
    • RIGHT Formula in Excel
    • INDIRECT Formula in Excel
    • Excel IRR Formula
    • Pivot Table Sort
    • OR Formula in Excel
    • Pivot Table Formula in Excel
    • How to Edit Drop Down List in Excel?
    • WEEKDAY Formula in Excel
    • Chart Wizard in Excel
    • Time Difference in Excel
    • Lookup Table in Excel
    • SUBTOTAL Formula in Excel
    • LOOKUP Formula in Excel
    • Themes in Excel
    • Group Worksheets in Excel
    • Excel ISNUMBER Formula
    • 3D Maps in Excel
    • VLOOKUP Tutorial in Excel
    • Moving Columns in Excel
    • Grouping Columns in Excel
    • Excel Formula of Percentage
    • Excel Leading Zeros
    • Timesheet in Excel
    • Nested IF Formula in Excel
    • SUMIF Formula in Excel
    • Concatenation in Excel
    • Excel Insert Page Break
    • LEN Formula in Excel
    • Insert Comment in Excel
    • Excel Print
    • Fractions in Excel
    • Excel Add a Column
    • Borders in Excel
    • Excel Sum by Color
    • Excel vs Google Sheets
    • Calculate Percentage Increase in Excel
    • Excel Format Phone Numbers
    • Excel Search Box
    • Excel vs CSV
    • Excel vs Numbers
    • Excel Concatenate Date
    • Excel Bullet Points
    • Calculate Compound Interest in Excel
    • Find External Links in Excel
    • Excel Comma Style
    • Excel Remove Leading Spaces
    • Combine First and Last Name in Excel
    • How to Calculate Ratio in Excel
    • SUMPRODUCT Function with Multiple Criteria
    • Create Excel Template
    • Excel Greater than or Equal
    • Excel Keyboard Shortcuts
    • Excel Row vs Excel Column
    • Excel Operators
    • Excel Text Compare
    • Excel Uppercase Function
    • Excel Auto Numbering
    • Watermark in Excel
    • Excel Delete Row Shortcut
    • Excel Word Count
    • Row Count in Excel
    • Excel Grade Formula
    • Excel Percentage Difference
    • Excel Rows and Columns
    • Excel Group
    • Excel Move Columns
    • Excel Row Height
    • Excel Sparklines
    • Excel Drawing a line
    • Multiple IFS in Excel
    • Excel Strikethrough
    • Numbering in Excel
    • Share Excel Workbook
    • Excel Shortcut For Merge Cells
    • Excel OneDrive
    • Excel Track changes
    • Excel Hide Formula
    • Excel Filter Shortcuts
    • Excel 3D Reference
    • Protect Excel Workbook
    • Excel Moving Averages
    • Excel Row Limit
    • Excel Absolute Value
    • Excel Print Area
    • Excel Format Painter
    • Excel Separate text
    • Excel Autofit
    • Excel Columns to Rows
    • Excel Paste Shortcut Option
    • Excel Rows to Columns
    • Excel Insert Row Shortcut
    • Excel Extensions
    • Excel Unmerge Cells
    • Divide in Excel Formula
    • Excel Compare Two Columns
    • Not Equal To Excel
    • Excel Remove Duplicates
    • Excel Remove Spaces
    • Excel Calculate Age
    • Copy Excel Sheet
    • Excel Conditional Formatting Based on Another Cell Value
    • Excel Cell Reference
    • Excel Split Cell
    • Excel Circular Reference
    • Highlight Every Other Row in Excel
    • Errors in Excel
    • Excel Delete Pivot Table
    • Excel Pivot Table
    • Subtraction in Excel
    • Count Unique Values in Excel
    • Excel Highlight Duplicates
    • Excel Data Formatting
    • Random Numbers in Excel
    • Basic Excel Formulas
    • Page Numbers in Excel
    • Excel CAGR Formula
    • Excel Combine cells
    • IFERROR with VLOOKUP in Excel
    • Column Sort in Excel
    • Print Comments in Excel
    • Cheat Sheet of Excel Formulas
    • Remove Hyperlinks in Excel
    • Excel Drop Down List
    • Remove (Delete) Blank Rows in Excel
    • Relative Reference in Excel
    • Subscript in Excel
    • Superscript in Excel
    • Excel Insert Multiple Rows
    • Excel Absolute Reference
    • Unhide Columns in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL COURSE
  • Online Excel Data Analysis Course
  • Excel for Finance Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download Page Numbers Excel Template

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Special Offer - EXCEL COURSE Learn More