How to freeze panes
The function in Excel is called ‘Freeze Panes’. Freezing panes helps and keeps the important header row(s) always on top (the numbers are corresponding to the picture on the right hand side):
- Select the cell, whose the row above and the column on the left you want to freeze.
- Go to the “View” ribbon.
- Click on “Freeze Panes”.
- Click again on “Freeze Panes” on the list.
Now, the rows above and the left columns of your marked cells are frozen.
There are also the options of just freezing the top row of the sheet or the first column.
Keyboard shortcuts for freezing panes
If you want to freeze the heading rows or columns faster, you might want to memorize this keyboard shortcut: Type Alt –> w –> f –> f one after another. With this shortcut you either set the or you remove the freezing, depending on if it is set already.