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?

TIA

4 Replies

@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".

Thanks! Not intuitive, but that did the trick!

@Riny_van_Eekelen Thank you. really simple solution for such an irritating problem. 

@Riny_van_Eekelen Thanks for that hint! I've struggled with this for years. Best hidden feature ever...