I have a question, and I hope that you can help me.

In Excel, I know how to freeze panes so that I can view the column
titles/labels as I scroll - however, do you know how to freeze them so that
they will automatically print in a set position as column titles on each
page?

When I manually copy and paste them, each time I add rows it offsets the
titles from the top, and as this is a sheet on which I am constantly updating
data, it becomes a hassle.

I have also thought about formatting them as a header, but there are too
many column headings and headers do not allow for precise positioning as
headings.

I would appreciate any help that you could provide me on this.