Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Constant Row
How can create a row that when I scroll down the data in that row remains at the top of the screen? I did this once before but now I can't remember for the life of me how I did it. -- Juan ------------------------------------------------------------------------ Juan's Profile: http://www.excelforum.com/member.php...fo&userid=6889 View this thread: http://www.excelforum.com/showthread...hreadid=570196 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Constant Row
Hi Juan Try: Select an entire row, go to window and select freeze pane -- Steel Monkey ------------------------------------------------------------------------ Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051 View this thread: http://www.excelforum.com/showthread...hreadid=570196 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Constant Row
Steel Monkey, thank you that did help. However, in the particular sheet that I'm working on, I am not allowed to select entire rows by clicking on the (numbered) row box. I can only select the cells and that does not produce favorable results. I can't remember what I did to make those unaccessible to undo it. Any ideas? -- Juan ------------------------------------------------------------------------ Juan's Profile: http://www.excelforum.com/member.php...fo&userid=6889 View this thread: http://www.excelforum.com/showthread...hreadid=570196 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Constant Row
Juan,
You don't have to select the entire row - just select the first cell in the row, then freeze panes. This does the same thing. "Juan" wrote: Steel Monkey, thank you that did help. However, in the particular sheet that I'm working on, I am not allowed to select entire rows by clicking on the (numbered) row box. I can only select the cells and that does not produce favorable results. I can't remember what I did to make those unaccessible to undo it. Any ideas? -- Juan ------------------------------------------------------------------------ Juan's Profile: http://www.excelforum.com/member.php...fo&userid=6889 View this thread: http://www.excelforum.com/showthread...hreadid=570196 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Constant Row
Thanks, I think that it was my trackball that was acting funny. I still can't figure out how to access the rows at the number boxes but I was able to do what I needed with your help. Thanks again. -- Juan ------------------------------------------------------------------------ Juan's Profile: http://www.excelforum.com/member.php...fo&userid=6889 View this thread: http://www.excelforum.com/showthread...hreadid=570196 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
Making Excell formula constant | Excel Programming | |||
making variables constant | Excel Worksheet Functions | |||
making a column of formuls constant | Excel Worksheet Functions | |||
making calculated fields constant. | Excel Worksheet Functions |