Learn how to lock the top row in Excel in only 2 clicks! Apply the same technique to freeze the first column in your worksheet.
If you need to freeze multiple rows in MS Excel, check our quick tutorial below!
We will show you how to make several rows and columns always visible, at the same time, using an efficient technique. Stop scrolling up and down or left and right all the time by freezing panes in Excel.
Ready to save time?
How to freeze the top row in Excel?
To lock the first row in Excel, click View then Freeze Top Row. That’s it! We told you it could be done in only 2 clicks.
How to freeze the first column in Excel?
In Excel, freeze the column header by selecting View then Freeze First Column.
How to freeze multiple rows or columns?
Freeze multiple rows or columns in Excel, or a mix of columns and rows in 3 clicks!
How to freeze the top rows?
If you want to freeze several rows, select the first row you don’t need to freeze or the first cell below the rows you want to freeze. Check the video on the right to know how to do it!
How to freeze multiple columns?
Freeze multiple columns in Excel by selecting the first column you don’t need to freeze or the first cell to the left of the columns you want to lock. Watch our quick video to learn how to do this!
How to freeze rows and columns together?
Freeze top and side panes by selecting the first cell next and under the columns/rows you want to lock. Then click View > Freeze Panes.
Watch how to do it in less than 10 seconds!
How to unfreeze rows or columns in Excel?
Unfreeze panes by clicking View then Unfreeze Panes.
Now, you know how to pin rows and columns in Excel and how to unfreeze them!
Join our MS Excel Course now to learn more handy tips!
