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

Data Analysis

  • How To Create Pareto Chart in Excel
  • How to sum a total in multiple Excel tables
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Excel Frequency Function Example

References

  • Last row number in range
  • Convert text string to valid reference in Excel using Indirect function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get first column number in range in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation must contain specific text
  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation with conditional list

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

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 return blank in place of #DIV/0! error in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Return blank if in Excel
  • Check multiple cells are equal in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • How to get year from date in Excel
  • Add years to date in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign people to groups in Excel

General

  • Create dynamic workbook reference to another workbook in Excel
  • How to calculate profit margin percentage in Excel
  • Share Excel data with Word documents
  • Zoom Worksheet in Excel
  • Customize Ribbon In Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning