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 अपने-आप छापता है.
Practice task
Set row 1 as the print title of your Orders sheet and column A as the left print title. Confirm in Print Preview that page 3 shows both.