Print Titles on Every Page in Excel
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 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
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)
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?
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.