https://support.office.com/en-us/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
- To lock more than one row or column, or to lock both rows and columns at the same time, move your cursor to the first scrolling cell (i.e. your cursor is below the rows you want to freeze and to the right of any columns you want to freeze).
- Then choose the View tab, and then click Freeze Panes.