Show row and column headings in multiple worksheets
How to show row and column headings in multiple worksheets using the Excel and VBA methods
1. Select the worksheets in which to show the row and column headings. Note: in this example we are showing the row and column headings in Sheets 2 and 3. |
2. Select the View tab. |
3. Click on the Headings checkbox, in the Show group, to select the checkbox. |
1. Select the worksheets in which to show the row and column headings. Note: in this example we are showing the row and column headings in Sheets 2 and 3. |
2. Select the Page Layout tab. |
3. Check the View checkbox under the Headings title, in the Sheet Options group. |
Dim ws2 As Worksheet
Set ws2 = Worksheets("Sheet3")
ws1.Activate
ActiveWindow.DisplayHeadings = True
ActiveWindow.DisplayHeadings = True
End Sub
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheet Names: Have worksheets named Sheet1 and Sheet2.
ADJUSTABLE PARAMETERS
Sheet Selection: Select the worksheets in which you want to show the row and column headings 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 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 shown, 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 the row and column headings, in multiple worksheets, in three steps.
VBA Method: Using VBA the row and column headings can be automatically shown in multiple worksheets by activating each of the worksheets that are to have the row and column headings shown and setting their ActiveWindow.DisplayHeadings to True.
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 | |
Hide row and column headings in multiple worksheets | How to hide 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 |