How to freeze columns


  1. Open the Excellentable in edit mode 

  2. Select the column header+1 to where you want to freeze the pane and click "Freeze Pane" button. (E.g to freeze till column B, select Column(B+1) or Column C)

     
    Capture 2019-07-29 at 18.48.45.png


  3.  You can see the the columns left to the selected column are froze when you scroll sheet to the right.

     
    Capture 2019-07-29 at 18.49.02.png


How to freeze rows and columns at the same time

  1. Open the Excellentable in Edit mode
  2. Select row+1 and column+1 that you want to freeze. (E.g. to freeze Row 1 and Column A+B, Select the cell C2) and Click View→ Freeze Pane
    Capture 2019-07-29 at 18.30.05.png
  3. You can see the the rows above of the selected row are froze when you scroll sheet
    Capture 2019-07-29 at 18.32.41.png



See Also:

How to freeze rows