View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default repeat rows for add'l pages for tabs on a multi-tab worksheet

Do it one worksheet at a time.

Nancy T. wrote:

I have a worksheet with multiple tabs. Each of these tabs is a project and
some are more than 1 page. I'd like to get the rows to repeat on the
additional pages of these reports. Currently, when I "Select All Sheets" the
option to select "Rows to repeat at top" is greyed out.

How can I format this to get the rows to repeat when their are multiple pages?


--

Dave Peterson