format rows to print at top for multiple tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ESS Joan - 02 Jun 2006 15:59 GMT

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.

Reply to this Message

Dave Peterson - 02 Jun 2006 17:33 GMT

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
worksheets?

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:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> 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.

Signature

Dave Peterson

Reply to this Message