View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
ESS Joan
 
Posts: n/a
Default 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.