Show gridlines in multiple worksheets
How to show gridlines in multiple worksheets using Excel and VBA methods
1. Select the worksheets in which to show the gridlines. Note: in this example we are showing the gridlines in Sheet 2 and 3. To select multiple worksheets hold the Ctrl key and click on the worksheets in which to show the gridlines. |
2. Select the View tab. |
3. Click on the Gridlines checkbox, in the Show group, to select the checkbox. |
1. Select the worksheets in which to show the gridlines. Note: in this example we are showing the gridlines in Sheet 2 and 3. To select multiple worksheets hold the Ctrl key and click on the worksheets in which to show the gridlines. |
2. Select the Page Layout tab. |
3. Check the View checkbox under the Gridlines title, in the Sheet Options group. |
Dim ws2 As Worksheet
Set ws2 = Worksheets("Sheet3")
ws1.Activate
ActiveWindow.DisplayGridlines = True
ActiveWindow.DisplayGridlines = True
End Sub
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheet Names: Have worksheets named Sheet2 and Sheet3.
ADJUSTABLE PARAMETERS
Sheet Selection: Select the worksheets in which you want to show the gridlines by changing the Sheet2 and Sheet3 worksheet names in the VBA code.
This tutorial explains and provides step by step instructions on how to show gridlines in multiple worksheets using Excel and VBA methods.
Excel Methods: This tutorial provides two Excel methods that can be applied to show gridlines in multiple worksheets. Both of the methods are very similar to each other, with both of the methods needing to select the worksheets that are to have the gridlines shown, however, one of them uses the View tab and the other using the Page Layout tab. Using either of the two methods you can show gridlines, in multiple worksheets, in three steps.
VBA Method: Using VBA the gridlines can be shown in multiple worksheets by activating each of the worksheets that are to have its gridlines shown and setting their ActiveWindow.DisplayGridlines to True.
Related Topic | Description | Related Topic and Description |
---|---|---|
Hide gridlines in a worksheet | How to hide gridlines in a worksheet using Excel and VBA methods | |
Show gridlines in a worksheet | How to show gridlines in a worksheet using Excel and VBA methods | |
Hide gridlines in multiple worksheets | How to hide gridlines in multiple worksheets using Excel and VBA methods | |
Hide gridlines in a workbook | How to hide gridlines in a workbook using Excel and VBA methods | |
Show gridlines in a workbook | How to show gridlines in a workbook using Excel and VBA methods |