I have a speadsheet and when printing i want to show columns A & B 1 to 32 but also A to G 1 to 5 on every sheet with C to AA 6 to 32 i know how to repeat A & B 1 to 32 but cant repeat the top rows again hope you understand what i am trying to do but hard to explain its a form that i am trying to make.

Hi
You could do this using vba but you cannot do it with standard functionality. Why do you need to do this?
Tony

I need it for printing a register of equipment

solved just copied the c to g ,1 to 5 along top of sheet as these dont change so they appear on each print with a to b 1 to 32