Show grid lines for a range of cells

Posted by: soenhay on 8 September 2017, 2:47 pm EST

  • Posted 8 September 2017, 2:47 pm EST

    Hi,

     

    Is there a way to only show grid lines for a range of cells? I didn't find anything online or on the forums so I assume that there is not an easy way to do this.

     

    Thanks.

  • Replied 8 September 2017, 2:47 pm EST

    I think you can do this with the StyleInfo Class. If you will look at it in the installed help file  on your computer. You could create a NamedStyle with gridlines and apply it to the block of cells you want to display gridlines on
  • Replied 8 September 2017, 2:47 pm EST

    Hello,

    The gridlines are on the sheet level and hence are applied to the entire
    sheet.  You could hide them and then set borders around the cells in
    specific rows to simulate gridlines. I have created a sample depicting the same, kindly have a look at it.

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur.


    2011/10/gridline.zip
Need extra support?

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

Learn More

Forum Channels