Freeze row in Excel shortcut

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

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.