Thread: How to make the top row sticky

Hi,
Here's an example:
pic0001.gif

How can I make the top row (PTSD1, PTSD2,....) from disappearing when the buttom of the page is reached.
Alternatively, is there a way to change the column Labels (A, B, C...) to what I need (PTSD1, PTSD2...)

Thanks.

If the top row is row 1 select A2, do windows>freeze

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"shutdown" <shutdown.24dxbn_1141878304.7736@excelforum-nospam.com> wrote in
message news:shutdown.24dxbn_1141878304.7736@excelforum-nospam.com...
>
> Hi,
> Here's an example:
> 4429
>
> How can I make the top row (PTSD1, PTSD2,....) from disappearing when
> the buttom of the page is reached.
> Alternatively, is there a way to change the column Labels (A, B, C...)
> to what I need (PTSD1, PTSD2...)
>
> Thanks.
>
>
> +-------------------------------------------------------------------+
> |Filename: pic0001.gif |
> |Download: http://www.excelforum.com/attachment.php?postid=4429 |
> +-------------------------------------------------------------------+
>
> --
> shutdown
> ------------------------------------------------------------------------
> shutdown's Profile:
> http://www.excelforum.com/member.php...o&userid=32289
> View this thread: http://www.excelforum.com/showthread...hreadid=520431
>

So simple, but then again I'm a complete beginner

Thanks Peo.