Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create running total in an Excel Table
  • Excel Line Chart
  • How to create dynamic reference table name in Excel
  • How to Create Gantt Chart in Excel
  • How to count table rows in Excel

References

  • Two-column Lookup in Excel
  • Count unique text values with criteria
  • How to get address of named range in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to get last row in text data in Excel

Data Validations

  • Data validation must not exist in list
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100
  • Excel Data validation allow weekday only
  • Excel Data validation must begin with

Print Page Numbers in Excel

by

This example teaches you how to print page numbers in Excel.

1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.

2. Click Add footer.

The Header & Footer Tools contextual tab activates.

3. On the Design tab, in the Header & Footer Elements group, click Page Number to add the page number.

4. Type ” of ”

5. On the Design tab, in the Header & Footer Elements group, click Number of Pages to add the number of pages.

Result:

Note: Excel uses codes in order to automatically update the header or footer as you change the workbook.

6. Click somewhere else on the sheet to see the footer.

7. On the Design tab, in the Options group, you can add a different first page header/footer and a different header/footer for odd and even pages.

8. On the View tab, in the Workbook Views group, click Normal, to switch back to Normal view.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel TRUE Function
  • Return blank if in Excel
  • How to use Excel OR Function
  • How to use Excel AND Function
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Two ways to sum time over 30 minutes in Excel
  • Convert Excel time to Unix time in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Basic Overtime Calculation Formula in Excel

Grouping

  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel

General

  • How to calculate decrease by percentage in Excel
  • Advanced Number Formats in Excel
  • How to choose page/paper size in Excel before Printing
  • How to generate random number between two numbers in Excel
  • Subtotal by invoice number in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning