format rows to print at top for multiple tabs



I regularly format large workbooks in Excel and would like to be able to
format all tabs with rows to repeat at the top of the page when printing.
When I highlight all tabs and go to page setup the rows to repeat at top
option is disabled. It would save a lot of time to be able to format the
entire workbook at once. How do I formatt many tabs within a workbook to
have a consistent area to print at the top of all sheets at once.



Dave Peterson

Maybe you could record a macro that changes this setting.

Then rerun it for each sheet--or even modify the macro to loop through all the

Option Explicit
Sub testme01()

Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.PageSetup.PrintTitleRows = "$1:$2"
Next wks

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question