Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of named range in Excel
  • How to get last row in numeric data in Excel
  • How to use Excel MATCH Function
  • How to get relative column numbers in a range in Excel
  • Convert text string to valid reference in Excel using Indirect function

Data Analysis Examples

  • How to create running total in an Excel Table
  • How to sum a total in multiple Excel tables
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to Create Gantt Chart in Excel
  • How to calculate current stock or inventory in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Prevent invalid data entering in specific cells
  • Excel Data validation unique values only
  • Excel Data validation allow uppercase only
  • Excel Data validation whole percentage only

Print Headers and Footers in Excel

by

This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel.

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

2. Click Add header.

Worked Example:   How To Change Paper Orientation In Excel

The Header & Footer Tools contextual tab activates.

3. On the Design tab, in the Header & Footer Elements group, click Current Date to add the current date (or add the current time, file name, sheet name, etc).

Result:

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

Worked Example:   How to Break Worksheets into Pages in Excel

4. You can also add information to the left and right part of the header. For example, click the left part to add the name of your company.

5. Click somewhere else on the sheet to see the header.

Worked Example:   How to choose page/paper size in Excel before Printing

6. 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.

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

Post navigation

Previous Post:

How to Break Worksheets into Pages in Excel

Next Post:

Print Page Numbers 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
  • Get first name from name with comma — Manipulating NAMES in Excel
  • EXACT function: Description, Usage, Syntax, Examples and Explanation
  • CODE function: Description, Usage, Syntax, Examples and Explanation
  • Find function vs Search function in Excel
  • How to count total words in a range in Excel
  • Basic overtime calculation formula in Excel
  • Add decimal hours to time in Excel
  • Get week number from date in Excel
  • Custom weekday abbreviation in Excel
  • Check If Two Dates are same month in Excel
  • Calculate periods for annuity in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • How to set check register balance in Excel
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles