How to Freeze A Row in Excel?

[Lewisclark]

How do I freeze a row in Excel? I would appreciate any tips or best practices for keeping header rows visible.

 

[louisegrant]

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.

 

[Colter]

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.

 

[alinajoseph]

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.

 

[Hazel]

In order to freeze a row in Excel: **View Freeze Panes Freeze Top Row.In order to freeze a row, select the row below it and then the option of Freeze Panes.

 

[Nancy_Wheeler]

To freeze the top row in Excel:

1. Go to the View tab.
2. Click Freeze Panes.
3. Select Freeze Top Row.

To freeze multiple rows, select the row below your target and click Freeze Panes > Freeze Panes.

 

[Rapunzel]

To freeze a row in Excel:
Go to View → Freeze Panes → Freeze Top Row.

 

[Choaks]

In excel, to freeze a row, you will only have to choose the row to freeze, open the view menu and select the freeze option so that the row you have chosen can be seen as you scroll.