MVP #39: How To Repeat The Header Row On Every Printed Page in Excel
posted by Michael Olafusi , on ,
For practice, I will use the (now popular) Pizza sales sheet. 5000 Pizzas sold in just 2 hours. And this time around we want to print the entire sales records, for use in the next general meeting to motivate the restaurant staff.
If we click on Print and examine the Print Preview, we will notice that only the page 1 has the header (S/N, Pizza Sold and Time). The other pages simply continue from where the previous page stopped and didn't give us the header row.
So how do we fix this?
Not hard at all.
Goto Page Layout menu. Click on Print Titles.
A dialog box will pop up.
Select the header row (row 1 in our case) to repeat on each page. And click on OK.
And that's all!
So let's see what will happen when we click on Print and examine the Print Preview.
Voila! Each page now shows the header. Even the last page.
And that's how you make Excel repeat the header row on every print page.
If you registered for the forthcoming free Excel training, don't be bothered by the fact that you haven't gotten any mail or training information from me yet. It will commence first week of July and I'm still making the training videos, class notes and practice files. Everything is original, work (business productivity) focused and very high quality (even my Nigerian accent).