Show gridlines in a worksheet

How to show gridlines in a worksheet using Excel and VBA methods

METHOD 1. Show gridlines in a worksheet using a ribbon option

EXCEL

Select worksheet > View tab > Show group > Check Gridlines checkbox

1. Select the worksheet in which to show the gridlines.
Note: in this example we are showing the gridlines in Sheet 2.
Select a worksheet

2. Select the View tab. Select the View tab

3. Click on the Gridlines checkbox, in the Show group, to select the checkbox. Check Gridlines checkbox

METHOD 2. Show gridlines in a worksheet using a ribbon option

EXCEL

Select worksheet > Page Layout tab > Sheet Options group > Gridlines > Check View checkbox

1. Select the worksheet in which to show the gridlines.
Note: in this example we are showing the gridlines in Sheet 2.
Select a worksheet

2. Select the Page Layout tab. Select the Page Layout tab

3. Check the View checkbox under the Gridlines title, in the Sheet Options group. Check View Gridlines checkbox

METHOD 1. Show gridlines in a worksheet using VBA

VBA

Sub Show_Gridlines()
'show gridlines in an active worksheet
ActiveWindow.DisplayGridlines = True

End Sub

METHOD 2. Show gridlines in a specific worksheet using VBA

VBA

Sub Show_Gridlines()
Dim ws1 As Worksheet
Set ws1 = Worksheets("Sheet2")
'show gridlines in a worksheet named Sheet2
ws1.Activate
ActiveWindow.DisplayGridlines = True

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Worksheet Names: Have a worksheet named Sheet2.

ADJUSTABLE PARAMETERS
Sheet Selection: Select the worksheet in which you want to show the gridlines by changing the Sheet2 worksheet name in the VBA code.

Explanation about how to show gridlines in a worksheet

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to show gridlines in a single worksheet using Excel and VBA methods.

Excel Methods: This tutorial provides two Excel methods that can be applied to show gridlines in a single worksheet. Both of the methods are very similar to each other, with one using the View tab and the other using the Page Layout tab. Using either of the two methods you can show gridlines, in a single worksheet, in three steps.

VBA Method: Using VBA the gridlines can be shown in an active or a specific worksheet by setting the ActiveWindow.DisplayGridlines to True.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to hide gridlines in a worksheet using Excel and VBA methods
How to hide gridlines in multiple worksheets using Excel and VBA methods
How to show gridlines in multiple worksheets using Excel and VBA methods
How to hide gridlines in a workbook using Excel and VBA methods
How to show gridlines in a workbook using Excel and VBA methods