Subscribe to Podcast

Subscribe on iTunes
Subscribe on Stitcher
Subscribe on Google Play
Subscribe on Spotify

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.

Virtual Assistants – How to print titles on every page in Excel

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.