Edit this page

Hide Row and Column Headers and Gridlines

Row and Column headings, as well as worksheet gridlines, are handy when creating or editing a document in RadSpreadsheet. However, at times you would want to hide them in order to make the spreadsheet more clean and presentable. This article will teach you about the options provided by RadSpreadsheet that allow you to achieve this.

Show or Hide Row and Column Headings

The RadWorksheetEditor exposes a Boolean property ShowRowColumnHeadings. Its default value is true and this makes the row and column headings visible. Setting the property to false as demonstrated in Example 1 hides them.

[C#] Example 1: Hide Row and Column Headers

            this.radSpreadsheet.ActiveWorksheetEditor.ShowRowColumnHeadings = false;

Show or Hide Gridlines

If you want to show or hide the gridlines of RadSpreadsheet just set the ShowGridlines Boolean property of RadWorksheetEditor to true for showing the gridlines or false for hiding them. Example 2 shows how you can disable the gridlines.

[C#] Example 2: Hide Gridlines

            this.radSpreadsheet.ActiveWorksheetEditor.ShowGridlines = false;

You can download a runnable project of the previous example from our online SDK repository here, the example is listed as Spreadsheet / CustomRowAndColumnHeadings.

See Also