Show row and column headings in multiple worksheets

How to show row and column headings in multiple worksheets using the Excel and VBA methods

METHOD 1. Show row and column headings in multiple worksheets using a ribbon option

EXCEL

Select worksheets > View tab > Show group > Check Headings 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.
Select multiple sheets

2. Select the View tab. Select the View tab

3. Click on the Headings checkbox, in the Show group, to select the checkbox. Check Headings checkbox

METHOD 2. Show row and column headings in multiple worksheets using a ribbon option

EXCEL

Select worksheets > Page Layout tab > Sheet Options group > Headings > Check View 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.
Select multiple sheets

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

3. Check the View checkbox under the Headings title, in the Sheet Options group. Check the Headings View checkbox

METHOD 1. Show row and column headings in multiple worksheets using VBA

VBA

Sub Show_Row_Column_Headings()
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Set ws1 = Worksheets("Sheet2")
Set ws2 = Worksheets("Sheet3")
'show the row and column headings in multiple worksheets
ws1.Activate
ActiveWindow.DisplayHeadings = True
ws2.Activate
ActiveWindow.DisplayHeadings = True

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
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.

Explanation about how to show row and column headings in multiple worksheets

EXPLANATION

EXPLANATION
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 TOPICS

Related Topic Description Related Topic and Description
How to hide row and column headings in a worksheet using Excel and VBA methods
How to show row and column headings in a single worksheet using Excel and VBA methods
How to hide row and column headings in multiple worksheets using Excel and VBA methods
How to hide row and column headings in a workbook using Excel and VBA methods
How to show row and column headings in a workbook using Excel and VBA methods