Hide row and column headings in multiple worksheets
How to hide row and column headings in multiple worksheets using Excel and VBA methods
1. Select the worksheets in which to hide the row and column headings. Note: in this example we are hiding the row and column headings in Sheets 2 and 3. To select multiple worksheets hold the Ctrl key and click on the worksheets in which to hide the row and column headings. |
2. Select the View tab. |
3. Click on the Headings checkbox, in the Show group, to unselect the checkbox. |
1. Select the worksheets in which to hide the row and column headings. Note: in this example we are hiding the row and column headings in Sheets 2 and 3. To select multiple worksheets hold the Ctrl key and click on the worksheets in which to hide the row and column headings. |
2. Select the Page Layout tab. |
3. Uncheck the View checkbox under the Headings title, in the Sheet Options group. |
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Set ws2 = Worksheets("Sheet3")
ws1.Activate
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayHeadings = False
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 hide the row and column headings by changing the Sheet2 and Sheet3 worksheet names in the VBA code to any existing worksheet names in the workbook in which the VBA code is written.
This tutorial explains and provides step by step instructions on how to hide row and column headings in multiple worksheets using Excel and VBA methods.
Excel Methods: This tutorial provides two Excel methods that can be applied to hide row and column headings 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 row and column headings hidden, 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 the row and column headings, in multiple worksheets, in three steps.
VBA Method: Using VBA the row and column headings can be automatically hidden in multiple worksheets by activating each of the worksheets that are to have the row and column headings hidden and setting their ActiveWindow.DisplayHeadings to False.
Related Topic | Description | Related Topic and Description |
---|---|---|
Hide row and column headings in a worksheet | How to hide row and column headings in a worksheet using Excel and VBA methods | |
Show row and column headings in a worksheet | How to show row and column headings in a single worksheet using Excel and VBA methods | |
Show row and column headings in multiple worksheets | How to show row and column headings in multiple worksheets using Excel and VBA methods | |
Hide row and column headings in a workbook | How to hide row and column headings in a workbook using Excel and VBA methods | |
Show row and column headings in a workbook | How to show row and column headings in a workbook using Excel and VBA methods |