Suppose, we need to lock the first column. Freeze First Column with Keyboard Shortcut Excel Freeze Panes Not Working (5 Causes with Fixes)ģ.

How to Freeze Top Two Rows in Excel (4 ways).

Apply Custom Freeze Panes in Excel (3 Easy Ways).

How to Freeze Selected Panes in Excel (10 Ways).

Read More: How to Freeze Top Row in Excel (4 Easy Methods)

If we scroll down the headers will remain in the same place.

And, now we can view that a gray line appears, which means the headers are now locked.

After that, press R to lock the top rows.

This will take us to the Freeze Panes drop-down menu bar. Now, let’s see the procedure of how this shortcut key works. To freeze the top rows only, we can use a keyboard shortcut Alt + W + F + R. To make it easy to understand the dataset we need to lock the headers which we put at the top of our dataset. When we scroll down our dataset, we lost the headers of the datasets. Read More: How to Freeze Top Row and First Column in Excel (5 Methods)

Now if we scroll down, the frozen rows will still be visible to us.

And finally, a gray line will show up directly below the frozen rows.

As we are showing how this works that’s why we are seeing this in detail.

All we need to do is press Alt + W + F + F to freeze panes.

This will appear in the Freeze Panes option.

After that, press the keyboard hotkey sequentially Alt + W + F.

To select the row click on row 9 or click on any cell in row 9 and press Shift + Spacebar, to select the whole row.

We are going to select row 9 to lock the above rows. Firstly, select the row or cell or column.But I will explain in a detailed way that will help to understand how those shortcuts work. To use the shortcut to lock rows or columns or both, we just need to select the cell or column or rows and then press the keyboard hotkey. Shortcut to Freeze Both Rows and Columns in Excel And the dataset includes Product Name in column B, Price in column C, and the product’s percentage of value-added tax in column D ( Vat).ġ. To use the keyboard shortcuts to Freeze Panes in excel we are going to use the dataset below. It takes only a few clicks to freeze panes but if you are using the keyboard shortcut, you will be able to complete the task within some seconds. We may all know about the Freeze Panes in excel with this we can easily freeze or lock the data we want to display all the time even while navigating to another part of the worksheet.

Set excel shortcut keys