I want to replicate the first 6 rows each time I print separate pages, say page 1 then page 68.
Have freezed rows 1 to 6 but when printing page 68 it only prints 1 & 2
Hello,
Format -> Print Ranges -> Edit... and enter $1:$6 on field Rows to Repeat
Hope that helps.
If the answer helped to solve your problem, please click the check mark (
) next to the answer.
Appreciate answer but doing as suggested only turns whole spreadsheet grey and deletes all page breaks
Cannot get the box you show in your answer where you can specify Rows to repeat
Hi thanks a lot will just see how it works next time but very useful
Please do **not** use *Add Answer* if you actually don't answer a question but commenting an answer. Please use ***add a comment*** for that purpose. Thanks in advance …