How to Freeze Multiple Panes in Excel (4 Criteria)

Get FREE Advanced Excel Exercises with Solutions!

It’s distinctive to freeze rows and columns in Excel while working with large datasets. As a result, while navigating to another part of the worksheet, we can view the data. Microsoft Excel has built-in tools with which we can easily freeze a large set of data. This article will show you how to freeze multiple panes in Excel.


Download Practice Workbook

You can download the workbook and practice with them.


4 Different Criteria to Freeze Multiple Panes

To keep a section of the worksheet displayed while scrolling to another part of it, we are going to use the Freeze Panes to freeze multiple panes. In this article, we will cover some benchmarks about the Freeze Panes command. To Freeze multiple panes in excel, we are using the dataset below. The dataset contains some product name in column B and their price in column C also the product’s percentage of value-added tax (Vat).

4 Different Criteria of Freeze Multiple Panes


1. Freeze Multiple Rows in Excel

We could choose to keep certain rows of our spreadsheet displayed at all times. And, we can still view the frozen rows when we scroll through our data. We can freeze multiple rows in excel using the freeze panes command. It will take some clicks to do this. Assume that we need to freeze the rows up to row 10. Now, let’s go through the following steps to freeze multiple rows.

STEPS:

  • Firstly, select the rows we want to freeze from the list below. As we want to freeze rows 1 to 9 in our case. So, we’ll choose row 10.

4 Different Criteria of Freeze Multiple Panes

  • Secondly, select the View tab on the ribbon.
  • Next, select Freeze Panes from the Freeze Panes drop-down menu of the window group.

4 Different Criteria of Freeze Multiple Panes

  • Finally, As shown by the gray line, the rows will lock in place.

  • Now, we can scroll down the worksheet to see the frozen rows at the top while going down.

Read More: How to Freeze Top Two Rows in Excel (4 ways)


2. Lock Multiple Columns in Excel

If we wish to lock multiple columns, we can easily do that with excel. To do this we need to follow some procedures. Suppose we want to freeze column B and column C. As we want to view the product name and the price of those products. So let’s have a look at those procedures to freeze multiple columns in excel.

STEPS:

  • First, select the column behind those we want to freeze. So we will select column D.

4 Different Criteria of Freeze Multiple Panes

  • After that, on the ribbon, select the View tab.
  • Next, in the Freeze Panes drop-down menu in the Window group, choose the Freeze Panes option.

4 Different Criteria of Freeze Multiple Panes

  • Now, we can see the gray line which indicates that the columns are now locked.

  • By scrolling right, we can view the frozen data columns.


Similar Readings


3. Excel Multiple Rows and Columns Freezing Together

We can lock both rows and columns at the same time. Let’s demonstrate the procedure below.

STEPS:

  • In the beginning, select a cell that above rows and left columns we want to freeze. So we select cell D9. As we want to see the product name and price from product Shampoo to product Day Cream.

4 Different Criteria of Freeze Multiple Panes

  • After that, select the View tab from the ribbon.
  • Now, in the window group, from the Freeze Panes drop-down menu, choose Freeze Panes.

  • Finally, two gray lines appear, one directly below the frozen rows and the other directly adjacent to the frozen columns. The columns and rows will be frozen at the same time after just clicking the Freeze panes button.

  • So, the rows and columns will lock in place, as indicated by the grayline.
  • While grazing down, we can scroll along the worksheet to see the frozen rows and columns.

Related Content: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)


4. Lock the Top Row and the First Column

We can lock the top row and the first column at the same moment. For this let’s have a look at the steps below.

STEPS:

  • Likewise, the previous criteria, go to the View tab on the ribbon in the sheet which we wish to lock the top rows and first column.
  • After that, to lock the top rows, choose the Freeze Top Row option from the Freeze Panes drop-down menu in the Window group of the View tab.

  • And to lock the first column, just choose the Freeze First Column option from the Freeze Panes drop-down selection in the Window category of the navigation pane to lock the first column.

4 Different Criteria of Freeze Multiple Panes

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


Unfreeze Multiple Panes in Excel

When no need to lock data we can unlock all those data by doing the following steps below.

STEPS:

  • In the first place, we can see that our data is locked as the gray color line indicates.

4 Different Criteria of Freeze Multiple Panes

  • In the second place, simply just go to the View tab from the ribbon.
  • Next, choose Unfreeze Panes from the Freeze panes drop-down menu under the Window category to unlock the data.

  • Finally, just clicking on the Unfreeze Panes will unlock all the rows and columns.


Freeze Panes Aren’t Operating Properly

If the Freeze Panes button in our worksheet isn’t working, it’s probably because of one of the following:

  • When you are modify or edit your data, which allows you to make changes to a cell’s data or enter a formula. To cancel data modifying mode, pressing the Enter or Esc key will help.
  • Your spreadsheet has been password-protected. Please first unprotect the worksheet before freezing the rows or columns.

Conclusion

The above methods assist you to Freeze Multiple 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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo