Learn how to freeze 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 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 freeze 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 in Excel, 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 freeze rows and columns in Excel and how to unfreeze them!
Join our MS Excel Course now to learn more handy tips!