How to: Show and Hide Gridlines

• May 29, 2023

Use the Worksheet.ActiveView.ShowGridlines property to display or hide worksheet gridlines.

Note

The Worksheet.PrintOptions.PrintGridlines property allows you to specify whether worksheet gridlines should be printed. Refer to the following help topic for more information on how to specify print options for a worksheet: How to: Specify Print Settings.

The following example hides gridlines for the first worksheet in a workbook:

View Example

• WorksheetActions.cs
• WorksheetActions.vb

workbook.Worksheets[0].ActiveView.ShowGridlines = false;

workbook.Worksheets(0).ActiveView.ShowGridlines = False

Change the Gridline Color

Use the WorksheetView.GridlineColor property to change the color of worksheet gridlines.

• C#
• VB.NET

workbook.Worksheets[0].ActiveView.GridlineColor = System.Drawing.Color.Blue;

workbook.Worksheets(0).ActiveView.GridlineColor = System.Drawing.Color.Blue

The image below demonstrates the result.