Locked columns

Enter the number of columns (up to 14, hidden as well as visible) that remain fixed at the left side of the window as you scroll across the spreadsheet. If you lock the first few columns, you can see the information that identifies each row no matter where you are in the spreadsheet. Leaving the field blank allows all columns to scroll.

Tips:  

  • Click Spin icon to increase or decrease the number of locked columns by one.
  • If the locked columns are wider than the Spreadsheet window, you will be unable to move to other parts of the spreadsheet.