Questions

Forum Navigation
Please to create posts and topics.

Freeze Rows and Columns in Excel

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

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.

Freeze Rows and Columns in Excel

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.

Freeze Rows and Columns in Excel