02-18-2020 05:49 AM
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
02-18-2020 06:05 AM
@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".
12-01-2020 12:28 PM
01-12-2021 02:32 PM
@Riny_van_Eekelen Thank you. really simple solution for such an irritating problem.