Forum Discussion
freeze panes, freezes more than I select
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
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".
Edit: Reading this post again after a long time and realise that to freeze the first two rows requires you to select A3, then Freeze Panes. Selecting C1 and Freeze Panes will freeze the first two columns. Likewise, C3 and Freeze Panes will freeze the first two rows and columns.
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".
Edit: Reading this post again after a long time and realise that to freeze the first two rows requires you to select A3, then Freeze Panes. Selecting C1 and Freeze Panes will freeze the first two columns. Likewise, C3 and Freeze Panes will freeze the first two rows and columns.
- Thanks! Not intuitive, but that did the trick!
- Riny,
4 years later and this is still the top workaround to a less-than-intuitive issue. Cheers buddy! Riny_van_Eekelen Thank you. really simple solution for such an irritating problem.
AlexW1835 Yeah the reference to the 'current selection' may be a bit vague. The more detailed support page (https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f) is more explicit about what to select in different scenarios. Though the only relevant part, in my opinion, is this one:
Freeze columns and rows
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Select View > Freeze Panes > Freeze Panes.
It always works. Wether you want to freeze only the first row or column or multiple rows and/or columns.
Riny_van_Eekelen I have joined this community just so I can tell you that I adore you. This has been driving me bonkers for literally years. I am completely delighted! I finally feel Excel is in my clutches! Thank you!
