How do I freeze panes in Excel?

Dear Customer,

Regarding your inquiry about freezing only row 8 in Excel without freezing rows 1-7, Excel’s default functionality does not support this directly. Typically, the Freeze Panes feature locks all rows above the selected row.

However, there is a workaround using VBA (macros). Please give it a try to see whether it works.

1. Open your Excel workbook and press Alt + F11 to open the VBA Editor.
2. Click Insert → Module.
3. Paste the following VBA code:

vba

Sub FreezeRow8Only()

With ActiveWindow

    .SplitColumn = 0

    .SplitRow = 8

    .FreezePanes = True

End With

End Sub

1. Close the VBA Editor and return to Excel.
2. Run the macro by pressing Alt + F8, selecting FreezeRow8Only , and clicking Run.
3. If you need to undo this action, use the following VBA command:

vba
Sub UnfreezePanes()

ActiveWindow.FreezePanes = False

End Sub

I understand this may not be a perfect solution, and I appreciate your feedback on this limitation. If you’d like Microsoft to consider adding direct functionality for this in future updates, we encourage submitting a feature request via our official channels Ideas · Community.

Please let me know if you need further assistance!

Best regards,  

Doris V - MSFT | Microsoft Community Support Specialist

Hi Doris,

Did you see Bob's reply? Perhaps you will respond to his comments.

Hi there,

Have a good day!

May I know if you have any updates/replies on this issue?

I am looking forward to assisting you.

Best regards,  

Doris V - MSFT | Microsoft Community Support Specialist

A single Row cannot be frozen if that's what you're trying to do. When Freeze Panes is applied all rows above the freeze are frozen [as are all columns to the left of the freeze].

i don't know what Doris V was trying to accomplish but it amounts to nothing more than use of the respective tools on the View tab of the Ribbon. It also applies the Split feature, not Freeze Panes.

Wow. It's crazy when AI bots reply

You can freeze panes very easily without using VBA. I'm having a bit of trouble understanding exactly what you want, but here's how freeze panes works. You select a cell and then use the the View tab of the Ribbon and click the Freeze Panes button. The freeze takes effect for the row directly above the selected cell and for the column on the left side of the selected cell.

In your example, select cell A8 then click the Freeze Panes button on the Ribbon.