Forum Discussion
Steffen1155
Dec 11, 2023Copper Contributor
Excel freezes more rows and columns as intended
I would like to freeze just the first 3 columns of a document. When selecting the columns and select the freeze option, it automaticaly freezes more columns and additional 19 rows (see pictures) Wha...
- Dec 11, 2023
Steffen1155 Better to think in terms of the first cell towards the right of the columns you want to freeze and below the row(s). So if you only want to freeze the first three columns, select D1 and then Freeze Panes. If you want the freeze the first two columns and the top three rows, select C4 and then Freeze Panes.
Riny_van_Eekelen
Dec 11, 2023Platinum Contributor
Steffen1155 Better to think in terms of the first cell towards the right of the columns you want to freeze and below the row(s). So if you only want to freeze the first three columns, select D1 and then Freeze Panes. If you want the freeze the first two columns and the top three rows, select C4 and then Freeze Panes.