14. Protection, Sharing and Printing
14.6 Headers and Footers
Steps in Excel
- Insert › Text › Header & Footer – the sheet switches to Page Layout view.
- Click the left/centre/right section and type, or use Header & Footer › Header & Footer Elements: Page Number, Number of Pages, Current Date, File Name, Sheet Name, Picture.
- Codes look like
&[Page] of &[Pages],&[Date],&[Tab]. - Options on the same tab: Different First Page, Different Odd & Even Pages, Scale with Document.
- Alternative: Page Layout › Page Setup dialog launcher › Header/Footer tab › Custom Header….
- Return with View › Workbook Views › Normal.
Worked example.
| Section | Content | Printed as |
|---|---|---|
| Header centre | Blinkit Maharashtra – City Sales, March 2026 |
title on every page |
| Footer left | &[Tab] |
Orders |
| Footer centre | Page &[Page] of &[Pages] |
Page 2 of 5 |
| Footer right | Printed &[Date] |
Printed 01-04-2026 (depends on your system date format) |
Ravindra Bagale's Tip
Many students write the report title in the first row of the sheet and don't add page numbers – then if the order of the printed pages gets mixed up, nothing makes sense. Put the title in the header and "Page 1 of 5" in the footer; they appear on every page automatically.
Ravindra Bagale's Tip – मराठी
बरेच students report चा title sheet च्या पहिल्या row मध्ये लिहितात आणि page number देतच नाहीत – मग print केलेल्या पानांचा क्रम (order) हरवला की काहीच कळत नाही. Title header मध्ये आणि "Page 1 of 5" footer मध्ये टाका; ते प्रत्येक पानावर आपोआप येतं.
Ravindra Bagale's Tip – हिंदी
बहुत से students report का title sheet की पहली row में लिखते हैं और page number देते ही नहीं – फिर छपे हुए पन्नों का क्रम (order) बिगड़ गया तो कुछ समझ नहीं आता. Title header में और "Page 1 of 5" footer में डालो; ये हर पन्ने पर अपने-आप आते हैं.
Practice task
Add a centred header with your report title and a footer with the sheet name (left), Page X of Y (centre) and the print date (right). Check in Print Preview.