Print Titles on Every Page in ExcelPrint Titles

I am sure that this scenario resonates with you. You have just finished doing a whole lot of data entry for a client. It is a really long list. Now you just need to print it off for whatever reason.

The only problem is that the heading or title row does not print on every sheet of paper, it prints only on the first!

How do you make it print on every page?

Print Titles

Print Titles is how, and for those of you who are Mac users, this works the same on Windows and Mac.

Start off on the Page Layout Ribbon (same on Mac)

Click on the icon labelled Print Titles

Print titles

In the dialogue box that pops up, click into Rows to Repeat at Top and click on the row number of the row that holds the headings (it is not always row 1 – although in my example it is Row 1)

Print titles

Click OK.

Now whenever you print this worksheet, the title row will print on every page.

You can see it here on Page 1 and Page 2.

How is this tip going to save you time? Did you know this already?

To learn more fun things you can do with Microsoft Excel get my course Essential Excel Skills for Business there is a Windows Version and a Mac Version.

P.S – Have you joined my Facebook Group yet? Hop over there and ask to join. Ask questions, interact with others who have questions and have fun.

I really like Shelley’s courses. She has a clear and easy to follow teaching style. In ‘How to Create Fillable Forms’ I’ve learned about the functions of the Developer ribbon which will mean I’ll be able to create a bespoke Returns Form for a client who has an online shop

Freya Henderson – Virtual Office Orkney

Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.

Sarah Clements – Inuous

Absolutely superb course, easy to follow and to refer back whilst putting it all into practice! I was unaware of the extent you can customise a presentation and it’s just made me want to know more – what’s next Shelley?

Denise Williams

I thought I had a pretty good grasp of Outlook until I did this course! In her videos, Shelley is clear and concise, and the language she uses is straightforward and jargon-free. Each module is broken down into manageable chunks, which helps keep your attention and means the course is easy to fit in around other commitments. I’ve created email templates and implemented rules that are already saving me time, and as all the other things I’ve learnt start to become second nature, the positive impact on my efficiency is fast becoming clear. This course has been incredibly beneficial and I would highly recommend it to anyone looking to strengthen their skills and boost productivity.

Pip Doleman VA

I thought I knew Powerpoint really well, but I wanted to specifically learn how to use Powerpoint to create better infographics, easily and quickly. Shelley explains everything in a very logical and clear way, so I understood everything the first time I heard it. The most useful thing I learnt was that Powerpoint can do so much more than I thought it could. By also using the short cuts that Shelley showed me I am much quicker than I have ever been and I thought I was already quick!

Susan Marot

Shelley Fishel of Tomorrow’s VA has a wealth of experience in Microsoft Office. I met her in person 2 years ago at the PA Show in London. I also saw her in action in a fab workshop and knew she was the whizz that everyone had told me she was. I have since bought a lifetime access to her HUB and all the courses in there are a MUST if you are a VA on a mission. The courses will give you confidence in all the Office 365 components and will catapult you to dizzy heights

Alex Hughes