Forum Discussion
Solved
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 su...
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.
If I remember correctly, I would select (in this case) line 3 and Freeze Panes. When this did not work, I saw your post and the single cell selection did work. Thank you!
