Home

freeze panes, freezes more than I select

%3CLINGO-SUB%20id%3D%22lingo-sub-1179400%22%20slang%3D%22en-US%22%3Efreeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179400%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20freeze%20the%20first%20two%20rows%20in%20a%20spreadsheet%2C%20however%20when%20I%20select%20them%20then%20click%20freeze%20panes%20it%20ends%20up%20freezing%20the%20first%2010%20rows%20not%20just%20the%20two%20I%20selected.%20Does%20anyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1179400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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?

TIA

1 Reply
Highlighted

@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