what you need to do is freeze the pane on the row you want as your heading row

(on the "windows" menu there's an option to "freeze panes", if you choose
the wrong row you can unfreeze the pane by going to the same place and the
option changes from freeze to unfreeze)

hope this makes sense


"questionsquestions" wrote:

I am trying to create heading row in excel that would appear on every page. I
want it to be possible to see this heading row as I scroll down and also want
it to print on all pages when I print.

I am referring to a heading row that I create and not the computer-generated
(A, B, C ...) heading row.

Thank you much for your assistance.