Sometimes it can be useful to lock a column or a row header. In this guide we will run through how to lock columns and row headers.
This is what you do:
1. Click the cell that is beneath the header row and to the right of the row headers.
2. Click the View tab.
3. Click Freeze Panes and Freeze Panes in the Window sub-tab.