How To Freeze Multiple Columns In Excel?

Select the cell immediately to the right of the columns you want to freeze and directly below the rows you want to keep visible

Go to the View tab

Click Freeze Panes

Select Freeze Panes from the dropdown

To freeze only columns, select the first cell in the row below the columns you want frozen

To freeze the first multiple columns and rows together, choose the cell that starts the unfrozen area

To unfreeze columns, go to View

Click Freeze Panes

Select Unfreeze Panes

Suggested for You

Trending Today