Freeze row in Excel shortcut
The Freeze Panes in Excel refers to a feature that allows you to keep certain cells in a fixed view even when scrolling through the worksheet. For example, if you are creating a table with a large amount of data and you want to keep the heading row fixed so that it is always visible, this freeze function is useful. Explains how to freeze the first row, freeze multiple rows, etc. using the shortcut keys.
Shortcut to freeze rows
Freeze the top row
Windows
Access Key: Alt + W + F + R
Mac
None
Freeze multiple rows
Windows
Access Key: Alt + W + F + F
Mac
None
Freeze the top row with shortcut keys
Explains how to freeze the top row using the shortcut keys.
Total Time: 1 minute
Select any cell
Select any cell. Basically, it doesn't matter which cell you choose.
Freeze the top row
Press Alt + W + F + R. I was able to freeze the top row.
The top row is displayed even when scrolling
If you freeze a row, it will appear fixed even if you scroll like this.
Freeze multiple rows
Select the cell below the row you want to freeze.
In this example, we want to freeze up to the third row, so we select the fourth row of cells.
Press Alt + W + F + F. This allowed us to freeze multiple rows.
Multiple rows will be displayed in a fixed view even when scrolling.