Question: how rows are frozen in excel?
Answer: Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. ... 
Go to the View tab.
Select the Freeze Panes command and choose "Freeze Panes."