How to freeze rows

  1. Open the Excellentable in edit mode

  2. Click on the row header+1 where you want to freeze the pane and click "Freeze Pane" button

    Capture 2019-07-29 at 18.40.58.png
     
     

  3. Click on the row header+1 where you want to freeze the pane and click "Freeze Pane" button. (E.g. to freeze till row number 3, select row number 4)

      Capture 2019-07-29 at 18.41.39.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 columns