Printing with headers

Hi Hannah,

The feature you are looking for is called Print Titles
It sits on the Page Layout tab along the top of your screen.

Click on Print Titles
Click in to Rows to repeat at Top
Click anywhere along your Header Row with your mouse

(It should now have the Row number in the Box e.g. if your Header was in Row 1 it should now say $1:$1)

Go down and click on Print Preview and see how that looks

It should repeat that row on every page for you

Any problems, please reply to this question/thread
Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector