how to freeze panes in excel

Here is how to freeze panes in Excel:

1. Go to the View tab on the Ribbon.
2. You have several Freeze options:
   • Freeze Top Row: Keeps the top row visible as you scroll down.
   • Freeze First Column: Keeps the first column visible as you scroll right.
   • Freeze Panes: Freezes rows above and columns to the left of the selected cell.
3. To freeze multiple rows or columns, select the cell immediately below the last row and to the right of the last column you want frozen, then click Freeze Panes.
4. To unfreeze, go to View and select Unfreeze Panes.

For example, to freeze the top row and first column simultaneously, select cell B2 and then click Freeze Panes. The window will show thicker borders indicating where panes are frozen.