To freeze a row, select the last row in the row of work and press View/Freeze Panes. This makes the headers visible whilst scrolling large spreadsheets.
To freeze a row in Excel, select the row below the one you want to freeze, go to the View tab, click Freeze Panes, and choose Freeze Top Row. This keeps the row visible while scrolling.
To freeze a row in Excel, open your worksheet and click the View tab. Select Freeze Panes, then choose Freeze Top Row. This keeps the top row visible while scrolling. To freeze a different row, select the row below it first.
