How do I make the first row in excel a header

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

– Open the desired Excel workbook in which you want to make the first row a header. 
– Now go to the row which is just below the row which you want to make a header. In our case let us go to the second 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 second 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-1 has been frozen. In the image below we can see that after scrolling down the page, Row-1 is still stationary, but the rest of the rows are being scrolled

– 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.