If you mean like in Sort it has a option that the section has headers, you
should make them "look" different from the adjacent data. Such as make the
header cells bold.
I am trying to make row 1 or serveral rows part of a header that
automatically shows up at the top of each page of a worksheet. I can
copy the row by right clicking and copying, but cannot paste it into the
header.