How to keep the same rows repeated on each page frozen? (NOT freeze panes)

[brillopad]

Hey guys,

I'm having a lot of trouble figuring this out. Any help is greatly appreciated!!

Basically, I want the top few rows on every page after the first page to be the same and not move, especially when I insert new rows above it.

This is for a purchase order type of form, so the first page will have customer and shipping information that I won't have to repeat on the other pages. However, what I do want to repeat at the top of each page after page 1 is the column headings for the order (i.e. quantity, product number, description, total cost, etc).

For each order I make (they are getting really, really long....20 pages or so) I add new items by inserting new rows, which moves the column heading on the next page down. I then have to go back and manually re-organize all the pages so each page has the column headings at the top of the page instead of having been pushed to the middle when I add new rows.

I hope this makes sense.....but I just want the column headings to freeze and stay put regardless of how many new rows I insert above it.

Freeze panes doesn't work because I don't want to just be able to scroll, I want each column heading physically present on each page. Headers WOULD work....except they only show up when printed (we are emphasizing a paperless environment).

Anyone have any ideas? I don't really know how to use excel well and it takes so much time to reorganize each order....Just wondering if anyone has a better way of doing this!

Thanks! Greatly appreciate it!

[arthurbr]

but I just want the column headings to freeze and stay put regardless of how many new rows I insert above it

Welcome to the board,
I don't quite understand what you mean. If you insert a row above the row containing the headings, the latter will go down, otherwise there's no way of inserting a row