14. Protection, Sharing and Printing
14.7 Print Titles (Repeat Header Rows)
Steps in Excel
- Page Layout › Page Setup › Print Titles.
- Rows to repeat at top: click the box, then select row 1 (the header row) →
$1:$1. - Columns to repeat at left (for very wide sheets): for example
$A:$Aso Order ID appears on every page. - OK › check pages 2, 3… in Print Preview.
Worked example. The 14,000-row Orders list prints on many pages. With $1:$1 as rows to repeat, every page starts with Order ID | Order Date | Platform | City | …, so page 37 is still readable.
Ravindra Bagale's Tip
Many students copy-paste the header row after every 40 rows so that the header shows on each printed page – and the data gets spoiled (sort/filter go wrong). Never do this. In Page Layout › Print Titles, enter $1:$1 – Excel prints the header on every page automatically.
Ravindra Bagale's Tip – मराठी
बरेच students header row प्रत्येक 40 rows नंतर copy-paste करतात जेणेकरून printed पेजवर header दिसेल – आणि data खराब होतो (sort/filter चुकतो). हे कधीच करू नका. Page Layout › Print Titles मध्ये $1:$1 द्या – Excel प्रत्येक पेजवर header आपोआप छापतो.
Ravindra Bagale's Tip – हिंदी
बहुत से students हर 40 rows के बाद header row copy-paste कर देते हैं ताकि छपे पेज पर header दिखे – और data ख़राब हो जाता है (sort/filter गलत हो जाते हैं). ऐसा कभी मत करो. Page Layout › Print Titles में $1:$1 दो – Excel हर पेज पर header अपने-आप छापता है.
Worked example — print titles repeat header rows
Why
Priya Deshmukh in Pune and Emma Clarke abroad both need a clear, repeatable way to use print titles repeat header rows on a GreenField Dairy sheet without breaking totals.
What
Print Titles Repeat Header Rows is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for print titles repeat header rows.
- Enter a small made-up value for Priya Deshmukh using £ where money appears.
- Add a second value for Emma Clarke using £ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once print titles repeat header rows is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of print titles repeat header rows on a blank sheet for CityBasket Retail.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Sana Sheikh and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Yuki Tanaka.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply print titles repeat header rows to a 5-row made-up CityBasket Retail table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with print titles repeat header rows.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as CityBasketR_practice.xlsx.
Hint: Use a clear file name for class.
Loading practice tasks...
- Input cells to unlock (Easy): How many cells are in the Monthly target column?
- Total target (Easy): Add up the Monthly target column.
- Total actual (Easy): Add up the Actual column.
- Highest target (Easy): What is the largest value in the Monthly target column?
- Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
- Cities below target (Medium): How many cities have a Gap below 0?
- Manager for a city (Medium): Find the Manager for City "Mumbai".
- Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
- Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
- Best performer (Hard): Which City has the largest Actual?
- Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
- Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
