Show gridlines in a workbook
How to show gridlines in a workbook using Excel and VBA methods
Select all worksheets > View tab > Show group > Check Gridlines checkbox
1. Select all worksheets in a workbook. Note: in this example we are showing the gridlines in an entire workbook, which includes Sheets 1, 2 and 3. |
2. Select the View tab. |
3. Click on the Gridlines checkbox, in the Show group, to select the checkbox. |
Select all worksheets > Page Layout tab > Sheet Options group > Gridlines > Check View checkbox
1. Select all worksheets in a workbook. Note: in this example we are showing the gridlines in an entire workbook, which includes Sheets 1, 2 and 3. |
2. Select the Page Layout tab. |
3. Check the View checkbox under the Gridlines title, in the Sheet Options group. |
METHOD 1. Show gridlines in a workbook using VBA
VBA
EXPLANATION
This tutorial explains and provides step by step instructions on how to show gridlines in a workbook using Excel and VBA methods.
This tutorial explains and provides step by step instructions on how to show gridlines in a workbook using Excel and VBA methods.
Excel Methods: This tutorial provides two Excel methods that can be applied to show gridlines in an entire workbook. Both of the methods are very similar to each other, with both of the methods needing to select all of the worksheets in a workbook, however, one of them uses the View tab and the other use the Page Layout tab. Using either of the two methods you can show gridlines, in an entire workbook, in three steps.
VBA Method: Using VBA the gridlines can be shown in an entire workbook by looping through each of the worksheets in a workbook and setting their ActiveWindow.DisplayGridlines to True.
RELATED TOPICS
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 | |
Show gridlines in multiple worksheets | How to show gridlines in multiple worksheets 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 |