How do you copy or convert a row or several rows into a header?

What do you mean by Header?

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.

--
Regards,
Tom Ogilvy

"Julie" wrote in message
...
How do you copy or convert a row or several rows into a header?

One way:

Choose File/Page Setup/Sheet. In the Rows to repeat at top textbox,
enter your rows, e.g.:

$1:$1

or

$1:$3




In article ,
"Julie" wrote:

How do you copy or convert a row or several rows into a header?

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

J.E. correctly interpreted your question and provided the correct answer.
(rows to repeat at Top)

--
Regards,
Tom Ogilvy

"Julie Finley" wrote in message
...
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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!