Forum Discussion

Steffen1155's avatar
Steffen1155
Copper Contributor
Dec 11, 2023
Solved

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...
  • Riny_van_Eekelen's avatar
    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.

Resources