Freeze Rows and Columns in Excel

HeelpBook@heelpbook

116 Posts

#1 · February 23, 2018, 10:23 am

I have difficulty to find the menu to Freeze Rows and Columns in Excel. Could you help me?

HeelpBook@heelpbook

116 PostsTopic Author

#2 · February 23, 2018, 10:24 am

To freeze one or more rows of data at the top of your spreadsheet, select the row below the row(s) that you want to freeze. Then, select Freeze Panes->Freeze Panes from the View tab of the ribbon.

Similarly,

To freeze columns at the left of your spreadsheet, select the column to the right of the columns that you want to freeze and then select the Freeze Panes option.
To freeze rows at the top and columns on left of your spreadsheet, select the cell below and to the right of the rows and columns that you want to freeze and then select the Freeze Panes option.
To unfreeze the rows or columns in a spreadsheet, select Freeze Panes -> Unfreeze Panes.