Forum Discussion

Copper Contributor

Feb 18, 2020

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

excel

Riny_van_Eekelen
Feb 18, 2020
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.

Riny_van_Eekelen

Platinum Contributor

Feb 18, 2020

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.

Belinda1300

Copper Contributor

Sep 26, 2022

jhaynie ... lol... I have exactly the same reply as the others below - I barely ever like to comment online, but when I read your post I remember doing this oh so many years ago, but haven't used Excel much in the past 10 years... Amazing what still works!
Thankyou for the tip - I'm sure I will be lurking around here looking for more solutions to weird issues as I build up my home finance tracking spreadsheet! Yes, I know there are some great apps out there that do it, but I get a kick out of building it in Excel... I have the time, so why not... 🙂 Cheers!!