ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to make the top row sticky (https://www.excelbanter.com/new-users-excel/76115-how-make-top-row-sticky.html)

shutdown

How to make the top row sticky
 

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


Peo Sjoblom

How to make the top row sticky
 
If the top row is row 1 select A2, do windowsfreeze

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"shutdown" wrote in
message ...

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



shutdown

How to make the top row sticky
 

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

Thanks Peo.


--
shutdown
------------------------------------------------------------------------
shutdown's Profile: http://www.excelforum.com/member.php...o&userid=32289
View this thread: http://www.excelforum.com/showthread...hreadid=520431



All times are GMT +1. The time now is 01:52 PM.

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