Theory
Whose report is this, and which page?
Aryan prints Meera's monthly report and hands it over. She flips to page 5 and asks: 'Is this still the sales report? Page 5 of how many? And is it this month's?'
The pages have no identity, no company name, no page number, no date. On a multi-page printout, that is confusing and unprofessional.
Headers and footers fix it: repeating bands that stamp every page with a name up top and page number and date below. And they can fill some of that in automatically. This small feature is what makes a printout look official.
Theory
Letterhead on every page
A company's letterhead prints its name and logo at the top of every sheet of paper, and often a page number at the foot. You do not retype it per page; it is part of the stationery. A header/footer is Excel's letterhead: define it once, and Excel stamps it onto every printed page automatically, keeping your report identified and navigable no matter how many pages it runs to.
Follow along
Add a professional header and footer
- Insert > Header & Footer (or switch to Page Layout view) The header and footer bands become editable, each with left/center/right sections.
- Type the shop chain name in the header center Fixed text like this repeats on every page.
- In the footer, insert auto-fields: Page Number of Number of Pages Gives 'Page X of Y' that updates itself as pages are added.
- Add the Date field to the footer Every printout is self-dated. Check it in Print Preview.
At a glance
Auto-fields that fill themselves
| Field | Inserts | Shows |
|---|---|---|
| Page Number | &[Page] | Current page (5) |
| Number of Pages | &[Pages] | Total pages (12) |
| Date | &[Date] | Today's date |
| File Name | &[File] | The workbook name |
Quiz
Aryan adds a footer with the date, then looks at the normal grid and cannot see it. Did it work?
- Yes, headers/footers show only in print, Print Preview and Page Layout view, not the normal grid
- No, the footer failed to save
- No, footers only work in .pdf files
- Yes, but only on the first sheet
Show the answer
Yes, headers/footers show only in print, Print Preview and Page Layout view, not the normal grid
Headers and footers live in the print layer: they appear on the printed page, in Print Preview, and in Page Layout view, but never in the normal grid where you edit data. Aryan should check Print Preview to confirm. Expecting them in the normal view is the classic misunderstanding (also flagged in BCA105), they are stationery, not cell content.
Think first
Header row, Print Titles, or header band?
Three similar-sounding things: a bold heading ROW in the sheet, Print Titles, and a page HEADER. Aryan wants the SHOP NAME on every printed page. Which one, and how does it differ from the other two?
Show the answer
The page header (Insert > Header & Footer). The other two are different: a heading row is data in the cells (product, price...) and prints wherever it sits; Print Titles repeats data rows (like the column headings) on every page. The header band is separate stationery above the grid, perfect for a company name or logo that is not part of the data. Three tools, three jobs: data row, repeated data row, page stationery.
Watch out
Where marks leak
Expecting headers/footers in the normal grid, they show only in print / Page Layout / Print Preview. Typing a page number by hand instead of using the auto-field (it will not update as pages change). And confusing the three: a data header row, Print Titles (repeats data rows), and the page header band (stationery). Naming auto-fields and the print-only nature earns easy marks.
Theory
Small polish, big impression
A dated, page-numbered, company-named printout signals care, and Meera trusts it more instantly. Unit 1 is almost complete; two topics remain. Next lesson is a genuine power feature that changes how you work with data ranges: Format as Table, which turns a plain range into a smart, self-expanding object with structured references. Then keyboard shortcuts to close the unit.
Summary
Key takeaways
- Headers repeat at the top and footers at the bottom of every PRINTED page.
- Each has left/center/right sections; type fixed text or insert auto-fields.
- Auto-fields fill themselves: page number, total pages, date, filename, sheet name.
- 'Page X of Y' uses the page-number and total-pages fields together.
- They appear only in print / Print Preview / Page Layout, not the normal grid; distinct from a data header row and Print Titles.
- Memory hook: a header/footer is your report's letterhead on every page.