Repeat Column Headers on Every Tab in Workbook

Hello,

I have an Excel workbook that has 30+ tabs. I would like to repeat the column headers on every page when the report is printed.

I know I can go to the Page Layout tab >> Print Titles >> Rows to Repeat at Top. But that only applies to the tab I am currently on. If I do a "Select All" on the tabs, the "Rows to Repeat at Top" section becomes grayed out.

If I force it so my entire workbook needs to have the same rows displayed (say lines 1, 2, and 3), is there a macro that I could run that would go through the entire workbook, go to the Page Layout tab >> Print Titles >> Enter Rows to Repeat at Top, enter $1:$3?

I'm open to other ideas as well that would accomplish this end result.

Thank you!!

Thanks Janos. I'll give it a try!