Lock cellrange for scrolling

Posted by: phillan on 8 September 2017, 1:58 pm EST

  • Posted 8 September 2017, 1:58 pm EST

    Hello!

    I want to set the scrollbars not to scroll all data but only some rows or columns. Where do I set this? I want the same functionality as Excel has where you can lock windows in the sheet and e.g. only scroll the data and not the headers.

     Thanks!

    Johan

     

  • Replied 8 September 2017, 1:58 pm EST

    Johan,

    It seems you are referring to the Freezing some rows/columns or making them non-scrollable, if this is the case then you can set the following properties as per your requirement:

    1.FrozenRowCount
    2.FrozenColumnCount
    3.FrozenTrailingColumnCount
    4.FrozenTrailingRowCount 

    Hope this helps.Thanks

  • Replied 8 September 2017, 1:58 pm EST

    Yep, that was it. Thanks Suresh!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels