33. Adding headers and footers

Adding Headers and Footers

Headers and footers in Excel are used to add titles, page numbers, dates, or other information at the top or bottom of each printed page. Let’s learn how:

Steps to Add Headers and Footers

  1. Step 1: Go to the Insert tab and select Header & Footer.
  2. Step 2: Enter the desired text or fields for the header and footer.
  3. Step 3: Preview your worksheet to ensure the header and footer are formatted correctly.

Interactive Example

# A B
1 Data 1A Data 1B
2 Data 2A Data 2B
3 Data 3A Data 3B

Enter text in the header and footer sections, then click "Preview Header & Footer" to see how it will appear.

Comments