How can I make row non-scrollable (the same as header row)

[AkaSaint]

I need to deal with a sheet having more than 150 rows, and I have 50
columns with titles. Please suggest how to make this row with titles
non-scrollable, for I could see it even when editing rows at the end of
the sheet.

 

[sawdawg]

Select the cell in the first column in the row just below the row you
want to remain visible. Then from the Window menu select Freeze Panes.
Hope this is what you were looking for.

 

[AkaSaint]

Thank you, it is almost what I was seeking for. The only drawback o
this command is that I can't freeze both scroll directions at one time
Anyway, it helped me very much

 

[RagDyer]

You *can* freeze *both* the row headers and the column headers
simultaneously.

Check out this old post:

http://tinyurl.com/2qdzt

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================