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

how do you set up a page break with a repeating top row
 

Tools -- Page Setup -- Sheet tab
There's a section in there for repeat rows at top. Select the rows you want
to be on each page in that box.

- Search


"bossyone99" wrote:

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