Hide gridlines in a workbook

How to hide gridlines in a workbook using Excel and VBA methods

METHOD 1. Hide gridlines in a workbook using a ribbon option

EXCEL

Select all worksheets > View tab > Show group > Uncheck Gridlines checkbox

1. Select all worksheets in a workbook.
Note: in this example we are hiding the gridlines in an entire workbook, which includes Sheets 1, 2 and 3. 		Select all worksheets

2. Select the View tab. Select the View tab

3. Click on the Gridlines checkbox, in the Show group, to unselect the checkbox. Uncheck Gridlines checkbox

METHOD 2. Hide gridlines in a workbook using a ribbon option

EXCEL

Select all worksheets > Page Layout tab > Sheet Options group > Gridlines > Uncheck View checkbox

1. Select all worksheets in a workbook.
Note: in this example we are hiding the gridlines in an entire workbook, which includes Sheets 1, 2 and 3. 		Select all worksheets

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

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

METHOD 1. Hide gridlines in a workbook using VBA

VBA

Sub Hide_Gridlines()
Dim ws As Worksheet
'hide gridlines in a workbook
For Each ws In Worksheets

ws.Activate
ActiveWindow.DisplayGridlines = False
Next ws

End Sub

Explanation about how to hide gridlines in a workbook

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to hide gridlines in an enire workbook using Excel and VBA methods.

Excel Methods: This tutorial provides two Excel methods that can be applied to hide 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 hide gridlines, in an entire workbook, in three steps.

VBA Method: Using VBA the gridlines can be hidden in an entire workbook by looping through each of the worksheets in a workbook and setting their ActiveWindow.DisplayGridlines to False.

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
Show gridlines in a workbook How to show gridlines in a workbook using Excel and VBA methods