View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bossyone99
 
Posts: n/a
Default how do you set up a page break with a repeating top row

I have a work sheet with alot of columns with each having a different header
subject. Each column has hundreds of rows of data. How do I set a page break
where the headers for the columns will appear on each page. Also if I delete
a row it will automaticly bump the next row up without effecting the column
headers. Please help. Thank you