format rows to print at top for multiple tabs ESS Joan 02.06.2006 14:59:01 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.

Re: format rows to print at top for multiple tabs Dave Peterson <petersod[ at ]verizonXSPAM.net> 02.06.2006 16:33:57 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 ESS Joan wrote: [Quoted Text] > > 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