How to Freeze Selected Panes in Excel (10 Ways)

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.

how to freeze 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.

how to freeze selected panes in Excel

Steps:
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze Top Row Option.

freezing first row

Then you will have a grey line below the top row which indicates that you have fixed the top row of this sheet.

freezing first row

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.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

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.

freezing multiple rows

Then a grey line will appear under Row 4 indicating the boundary of the frozen panes.

freezing multiple rows

So, when we try to scroll down through our dataset we can see that the first 4 rows remain fixed during this process.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

Steps:
➤ Go to View Tab >> Window Group >> Freeze Panes Dropdown >> Freeze First Column Option.

freezing first column

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.

freezing first column

So, for moving to the right side of your dataset you will find that the first column is not moving during this process.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

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.

freezing multiple columns

Then a grey line will appear to the right side of Column B indicating the boundary of the frozen panes.

freezing multiple columns

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.

freezing multiple columns

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.

how to freeze selected panes in Excel

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.

freezing rows and columns

Now, we will have two separate grey lines indicating the fixed rows area and the fixed columns area of this worksheet.

freezing rows and columns

For moving down or to the right side we will find our frozen selected panes fixed all over time.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

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.

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

using split option

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.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

Steps:
➤ Go to Home Tab >> Styles Group >> Format as Table Dropdown >> select any table style.

format as table

Then the Create Table dialog box will appear.
➤ Select the range of your dataset.
➤ Check the My table has headers option and click OK.

how to freeze selected panes in Excel

In this way, we will convert our range to the following table.

format as table

To examine our frozen header row, select anywhere in the table and scroll down through the table.

format as table

Then, we can see our fixed header rows at the top of the table.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

Steps:
➤ Go to Insert Tab >> Table Option.

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.

Table option

After the creation of the table select anywhere in the table and scroll down through the table.

Table option

Then, we can see the header row is frozen for the table in spite of moving down through the table.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

Steps:
➤ Go to Data Tab >> From Table/Range Option.

Power query

Then, the Create Table dialog box will appear.
➤ Select the range of your dataset.
➤ Check the My table has headers option and click OK.

Power query

After that, you will be taken to the Power Query Editor window.

how to freeze selected panes in Excel

➤ Go to Home Tab >> Close & Load Dropdown >> Close & Load Option.

Power query

In this way, we have closed the Power Query Editor window and loaded the table to a new sheet named Table5.

Power query

For checking out our selected frozen panes, choose any cell in the table and scroll down through the table.

Power query

Finally, we can see our frozen pane of this table is fixed in spite of scrolling down the table.

how to freeze selected panes in Excel

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.

how to freeze selected panes in Excel

Steps:
➤ Go to Developer Tab >> Visual Basic Option.

VBA Code

Then, the Visual Basic Editor will open up.
➤ Go to Insert Tab >> Module Option.

VBA Code

After that, a Module will be created.

VBA Code

➤ Write the following code

Sub freezepanes()

Range("A5").Select
ActiveWindow.freezepanes = True

End Sub

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

VBA Code

➤ Press F5.
Then, we will have the frozen panes indicator line below Row 4.

VBA Code

In spite of scrolling down through the worksheet, you will find the frozen panes fixed all over time like the following figure.

how to freeze selected panes in Excel

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.

practice


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.


Related Articles

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo