Tanjima Hossain
Sometimes you may need to fix a portion of your worksheet so that when you scroll through the sheet the fixed part will not move and that’s why this article will explain the easiest ways to freeze selected panes in Excel. So, let’s get into the main article.
Download Workbook
10 Ways to Freeze Selected Panes in Excel
We will use the following dataset containing sales records of a company to demonstrate the ways of freezing selected panes in Excel.
We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.
Method-1: Freeze Only the First Row
If you want to freeze only the first row of your worksheet then you can do it easily by using the Freeze Top Row option.
Steps:
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze Top Row Option.
Then you will have a grey line below the top row which indicates that you have fixed the top row of this sheet.
Now, if you try to scroll down through your worksheet then you will notice that the first row is not moving with the scrolling process.
Read More: How to Freeze Top Two Rows in Excel (4 ways)
Method-2: Freeze Selected Panes in Excel for Multiple Rows
Suppose, we want to freeze the first 4 rows of the following dataset, and to freeze these selected panes in Excel we will use the Freeze Panes option here.
Steps:
➤ Select a cell beneath the last row (here, the last row is Row 4, so we selected a cell in Row 5) up to which you want to freeze the panes.
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze Panes Option.
Then a grey line will appear under Row 4 indicating the boundary of the frozen panes.
So, when we try to scroll down through our dataset we can see that the first 4 rows remain fixed during this process.
Read More: How to Freeze Selected Panes in Excel (10 Ways)
Method-3: Freeze Only the First Column
For freezing only the first column or Column A of your dataset you can use the Freeze First Column option.
Steps:
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze First Column Option.
Then you will have a grey line on the right side of the first column which specifies the first column of this sheet as a fixed pane.
So, for moving to the right side of your dataset you will find that the first column is not moving during this process.
Read More: How to Freeze First 3 Columns in Excel (4 Quick Ways)
Method-4: Freeze Selected Panes in Excel for Multiple Columns
For freezing multiple columns like the Product Code and Product column of the following table you can use the Freeze Panes option here.
Steps:
➤ Select a cell to the right side of the last column (here, the last column is Column B, so we selected a cell in Column C) up to which you want to freeze the panes.
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze Panes Option.
Then a grey line will appear to the right side of Column B indicating the boundary of the frozen panes.
Now, you can scroll to the right side as much as you want but the first two columns of the frozen panes will not move.
Read More: How to Apply Custom Freeze Panes in Excel (3 Easy Ways)
Method-5: Freeze Selected Panes in Excel for Rows and Columns Simultaneously
Here, we will try to freeze some rows and columns at a time, and to fix these selected panes we will use the Freeze Panes option.
Steps:
➤ Select a cell below the last row (here, the last row is Row 4 so we selected a cell in Row 5) and to the right side of the last column (here, the last column is Column B so we selected a cell in Column C) up to which you want to freeze the panes.
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze Panes Option.
Now, we will have two separate grey lines indicating the fixed rows area and the fixed columns area of this worksheet.
For moving down or to the right side we will find our frozen selected panes fixed all over time.
Read More: How to Freeze Top Row and First Column in Excel (5 Methods)
Method-6: Using Split Option to Freeze Selected Panes in Excel
Here, we will use the Split option to freeze the first 4 rows and first 2 columns of our datasheet.
Steps:
➤ Click on a cell below the last row (here, the last row is Row 4 so we selected a cell in Row 5) and to the right side of the last column (here, the last column is Column B so we selected a cell in Column C) up to which you want to freeze the panes.
➤ Go to View Tab >> Window Group >> Split Option.
After that, we can see that our worksheet has been divided into four parts, and for this reason, we are having two scroll bars on the right side and two scroll bars on the bottom side.
For scrolling down of the bottom portion scroll bar and scrolling to the right through the right scroll bar, we can move through our worksheet but our intended frozen panes will remain fixed here also until we scroll through the scroll bars of these parts.
Related Content: How to Freeze Multiple Panes in Excel (4 Criteria)
Method-7: Freeze Selected Panes for Single Row Using Format as Table Option
For freezing the header row of the following dataset, we will use the Format as Table option here.
Steps:
➤ Go to Home Tab >> Styles Group >> Format as Table Dropdown >> select any table style.
Then the Create Table dialog box will appear.
➤ Select the range of your dataset.
➤ Check the My table has headers option and click OK.
In this way, we will convert our range to the following table.
To examine our frozen header row, select anywhere in the table and scroll down through the table.
Then, we can see our fixed header rows at the top of the table.
Related Content: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)
Method-8: Table Option for Freezing Single Selected Row
In this section, we will freeze our header row by using the Table option.
Steps:
➤ Go to Insert Tab >> Table Option.
Afterward, the Create Table dialog box will appear.
➤ Select the range of your dataset.
➤ Check the My table has headers option and click OK.
After the creation of the table select anywhere in the table and scroll down through the table.
Then, we can see the header row is frozen for the table in spite of moving down through the table.
Read More: How to Freeze Top 3 Rows in Excel (3 Methods)
Method-9: Freeze Selected Panes for Single Row Using Power Query
In this section, we will use the Power Query option to freeze only the header row of this dataset.
Steps:
➤ Go to Data Tab >> From Table/Range Option.
Then, the Create Table dialog box will appear.
➤ Select the range of your dataset.
➤ Check the My table has headers option and click OK.
After that, you will be taken to the Power Query Editor window.
➤ Go to Home Tab >> Close & Load Dropdown >> Close & Load Option.
In this way, we have closed the Power Query Editor window and loaded the table to a new sheet named Table5.
For checking out our selected frozen panes, choose any cell in the table and scroll down through the table.
Finally, we can see our frozen pane of this table is fixed in spite of scrolling down the table.
Read More: How to Freeze Frame in Excel (6 Quick Tricks)
Method-10: Using VBA Code to Freeze Selected Panes
In this section, we will use a VBA code to freeze the first 4 rows of the following dataset.
Steps:
➤ Go to Developer Tab >> Visual Basic Option.
Then, the Visual Basic Editor will open up.
➤ Go to Insert Tab >> Module Option.
After that, a Module will be created.
➤ Write the following code
Sub freezepanes()
Range("A5").Select
ActiveWindow.freezepanes = True
End SubPrior to freezing panes, we have selected cell A5 in Row 5 (the immediate following row of the selected frozen panes), because we will freeze up to Row 4.
➤ Press F5.
Then, we will have the frozen panes indicator line below Row 4.
In spite of scrolling down through the worksheet, you will find the frozen panes fixed all over time like the following figure.
Read More: How to Freeze Panes with VBA in Excel (5 Suitable Ways)
Practice Section
For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.
Conclusion
In this article, we tried to cover the ways to freeze selected panes in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.
