Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)

Microsoft Excel has plenty of shortcuts. Those shortcuts help us to do work faster and also save time. In Excel, while scrolling over a huge dataset, sometimes we need to keep some data visible. Freezing is the method of ensuring rows and columns are displayed on the screen at all times, and the Freeze Panes tool helps us to do that in excel. The keyboard shortcut to freeze panes in excel will help to save time while working. In this article, we will know about some shortcuts to Freeze Panes in Excel.


Download Practice Workbook

You can download the workbook and practice with them.


3 Shortcuts to Freeze Panes in Excel

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. 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.

To use the keyboard shortcuts to Freeze Panes in excel we are going to use the dataset below. 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).

3 Shortcuts of Freeze Panes in Excel


1. Shortcut to Freeze Both Rows and Columns in Excel

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. But I will explain in a detailed way that will help to understand how those shortcuts work. Let’s demonstrate the steps below.

STEPS:

  • Firstly, select the row or cell or column. We are going to select row 9 to lock the above rows.
  • 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.

3 Shortcuts of Freeze Panes in Excel

  • After that, press the keyboard hotkey sequentially Alt + W + F. This will appear in the Freeze Panes option.
  • Now, press F to Freeze Panes.

3 Shortcuts of Freeze Panes in Excel

  • All we need to do is press Alt + W + F + F to freeze panes. As we are showing how this works that’s why we are seeing this in detail.
  • And finally, a gray line will show up directly below the frozen rows.

3 Shortcuts of Freeze Panes in Excel

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

3 Shortcuts of Freeze Panes in Excel

Read More: How to Freeze Top Row and First Column in Excel (5 Methods)


2. Shortcut to Freeze Top Rows in Excel

When we scroll down our dataset, we lost the headers of the datasets. To make it easy to understand the dataset we need to lock the headers which we put at the top of our dataset. To freeze the top rows only, we can use a keyboard shortcut Alt + W + F + R. Now, let’s see the procedure of how this shortcut key works.

STEPS:

  • First, press Alt + W + F. This will take us to the Freeze Panes drop-down menu bar.

3 Shortcuts of Freeze Panes in Excel

  • After that, press R to lock the top rows.
  • And, now we can view that a gray line appears, which means the headers are now locked.

3 Shortcuts of Freeze Panes in Excel

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

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


Similar Readings:


3. Freeze First Column with Keyboard Shortcut

Suppose, we need to lock the first column. Our first column contains the Products Name and while scrolling over our dataset we want to view the Products Names. So, to freeze the first column there is a keyboard shortcut Alt + W + F + C (sequentially). Now, let’s go through the procedure of how this shortcut performs.

STEPS:

  • In the beginning, using the keyboard shortcut Alt + W + F will bring us to the Freeze Panes menu bar.

  • Then, to lock the first column, press C. And this will freeze up the first column of our worksheet.

  • If we scroll left or right the first column will still be in the same place.

Read More: How to Freeze Top Row and First Column in Excel (5 Methods)


Shortcut of Unfreeze Panes in Excel

As we can use the shortcut for freezing panes, we can also unfreeze them with the keyboard shortcut. Assume that our data is locked. As we can see that two gray lines, one just under the frozen rows and the other immediately adjacent to the frozen columns. And the shortcut for unfreezing panes is Alt + W + F + F. Now, let’s have a look at how it works.

STEPS:

  • Firstly, by pressing Alt + W + F on the keyboard, the Freeze Panes menu bar can be accessed.

3 Shortcuts of Freeze Panes in Excel

  • After that, press F to unfreeze the panes.


Conclusion

The above methods are shortcuts of Freeze Panes in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo