How to fix Excel cells when scrolling (Freezing Panes)

⁣This is also known as locking cells in view and can be done by using the 'Freezing Panes' option.

1. To lock excel cells in view select one row below and one column away from the cells you want to freeze.
2. Navigate the view tab and locate the 'Freeze Panes' option
3. Check the 'Freeze panes' option to lock your selected area in view, the rows and columns will be now be frozen in place