ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   headers (https://www.excelbanter.com/excel-programming/284153-headers.html)

Julie[_7_]

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

Tom Ogilvy

headers
 
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?




J.E. McGimpsey

headers
 
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?


Julie Finley

headers
 
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!

Tom Ogilvy

headers
 
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!





All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com