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).
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.
- 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.
- Secondly, select the View tab on the ribbon.
- Next, select Freeze Panes from the Freeze Panes drop-down menu of the window group.
- 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.
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.
- First, select the column behind those we want to freeze. So we will select column D.
- 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.
- 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.
- 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.
- 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.
- 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.
Unfreeze Multiple Panes in Excel
When no need to lock data we can unlock all those data by doing the following steps below.
- In the first place, we can see that our data is locked as the gray color line indicates.
- 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.
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.
- How to Unfreeze Rows and Columns in Excel
- How to Apply Custom Freeze Panes in Excel
- Excel Freeze Panes Not Working
- How to Freeze Panes with VBA in Excel