how to freeze a row in excel

To freeze a row in Excel, follow these steps:

1. Freeze the Top Row Only
   • Go to the View tab on the ribbon.
   • Click Freeze Panes.
   • Select Freeze Top Row.
     This will lock the first row so it remains visible as you scroll down the worksheet

2. Freeze Multiple Rows
   • Select the row immediately below the last row you want to freeze. For example, to freeze rows 1 and 2, select row 3.
   • Go to the View tab, click Freeze Panes , then choose Freeze Panes from the dropdown.
     This freezes all rows above the selected row, keeping them visible while scrolling

3. Freeze Rows and Columns Simultaneously
   • Select the cell below the last row and to the right of the last column you want to freeze. For example, to freeze rows 1 and 2 and column A, select cell B3.
   • Go to View > Freeze Panes > Freeze Panes.
     This keeps both the selected rows and columns visible while scrolling

4. To Unfreeze Panes
   • Go to View > Freeze Panes > Unfreeze Panes to remove any frozen rows or columns

Using these steps, you can keep important header rows or key data visible as you navigate large Excel worksheets.