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