How to lock the 1st row in excel when scoll down

Who is Participating?
naunidhConnect With a Mentor Commented:
For Excel 2007+ goto Views -->> Windows and use "Freeze Panes" option. You can Freeze top row, left-most column, or depending on the selection any row or column that you wish.

Hope this helps.
wmeerzaConnect With a Mentor Commented:
In Excel select freeze panes from the view tab
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
In order to freeze panes as described above, you need to select a cell other than A1. If you want to freeze the top row, select A2. If you want to freeze the top row and the leftmost column, select B2, then click the Freeze pane command.

You can freeze more than one row or column. Everything above and to the left of the current cell will be frozen when you click Freeze panes.

cheers, teylyn
Sandesh1983Connect With a Mentor Commented:
This should help you.  Follow the below link
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.