freeze panes, freezes more than I select

Occasional Visitor

I'm trying to freeze the first two rows in a spreadsheet, however when I select them then click freeze panes it ends up freezing the first 10 rows not just the two I selected. Does anyone have any suggestions?


1 Reply

@jhaynie You don't have to select rows. Just select the cell directly below and to the right of where you want to freeze the rows/columns. In your case, select C1 and then "Freeze panes".

Related Conversations
Force to select a staff member at bookings
koppenburg in Microsoft Bookings on
1 Replies
all Excel file freezes when I try to save
dericksd18 in Excel on
0 Replies
Power Query freezes in Excel
ire123 in Excel on
4 Replies