Excel Hack

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

Select any cell. Basically, it doesn't matter which cell you choose.

Freeze the top row

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

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 a cell

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

Press Alt + W + F + F. This allowed us to freeze multiple rows.

Fixed display even when scrolling

Multiple rows will be displayed in a fixed view even when scrolling.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments