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.
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.
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.
Thank you, it is almost what I was seeking for. The only drawback of this command is that I can't freeze both scroll directions at one time. Anyway, it helped me very much.
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!
==============================================
"AkaSaint" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you, it is almost what I was seeking for. The only drawback of
> this command is that I can't freeze both scroll directions at one time.
> Anyway, it helped me very much.
>
>
> --
> AkaSaint
> ------------------------------------------------------------------------
> AkaSaint's Profile:
http://www.excelforum.com/member.php...o&userid=28440
> View this thread: http://www.excelforum.com/showthread...hreadid=480399
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks