How to freeze the second row in excel

To do this yourself, please follow the steps described below;

– Open the desired Excel workbook in which you want to freeze the rows. 
– Now go to the row which is just below the row which you want to freeze. In our case let us go to the third row, and make any cell in this row active, by clicking on any cell in this row.

– Now press SHIFT + SPACEBAR in order to select this entire row. In our case, the entire third row should get selected.

– Now click on the “View” option on the menu bar, and then click on the “Freeze Panes” option. A drop-down menu would appear, as shown in the image below.

– Now select the “Freeze Panes” option.

– Now if we try to scroll towards the bottom of the page, we will notice that Row-2 and all the rows above Row-2, i.e. Row-1 as well has been frozen. In the image below we can see that after scrolling down the page, Row-1 and 2 are still stationary, but the rest of the rows are being scrolled (We can see in the image below that row-12 is coming just next to Row-2).    

– Additionally, if we want to skip going to the view option, clicking on Freeze panes, and then selecting the freeze panes option, we can use the excel shortcut after selecting the entire row, which is ALT + W + F + F. This will cater to the exact same subject, as we did above.