Forum Discussion
ACDeBellis
Mar 09, 2020Copper Contributor
Freeze panes not working properly
I'm having an issue with freeze panes. I'm trying to freeze the first 2 columns and the top row of a large worksheet, so I'm using "Freeze top row" for the top row, and selecting the 3rd column and s...
Abiola1
Mar 09, 2020MVP
Hello,
Usually in this case, you will probably have headings in i.e row 3. If your headings is in row 3 and you want to Freeze row 3 and the first 2 columns (A and B), you need to select cell C4. Then, apply Freeze Panes.
This will Freeze the first two columns and the first 3 rows. When you scroll to the right and down, you will notice the freezing
Usually in this case, you will probably have headings in i.e row 3. If your headings is in row 3 and you want to Freeze row 3 and the first 2 columns (A and B), you need to select cell C4. Then, apply Freeze Panes.
This will Freeze the first two columns and the first 3 rows. When you scroll to the right and down, you will notice the freezing