You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows. To freeze a row (or unfreeze it later) you just need to use the "Freeze Panes" menu.
Can you freeze multiple rows in Excel?
To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. ... To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.
How do I freeze a row in Excel?
To freeze the top row or first column:
- From the View tab, Windows Group, click the Freeze Panes drop down arrow.
- Select either Freeze Top Row or Freeze First Column.
- Excel inserts a thin line to show you where the frozen pane begins.
