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.


How to Freeze Multiple Panes in Excel: 4 Different Criteria

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 as well as 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. 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 Rows and Columns at the Same Time in Excel 


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.


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 is above the 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 gray line.
  • 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


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

  • 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


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 modify or edit your data, it 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.

Download Practice Workbook

You can download the workbook and practice with them.


Conclusion

The above methods assist you in freezing 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.


Related Articles


<< Go Back to Freeze Panes | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo