Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to hide row and column headings from all worksheets?

In Excel, we can hide the row and column headings in a worksheet by unchecking the Headings option under the View tab, but, how could you hide the row and column headings from all worksheets in a workbook?

Hide row and column headings from all worksheets with VBA code

Hide row and column headings from all worksheets with Kutools for Excel


arrow blue right bubble Hide row and column headings from all worksheets with VBA code

Except unchecking the Headings under the View tab one by one, the following VBA code can help you to hide them in all sheets at once.

1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Hide row and column headings in all worksheets:

Sub hideheadings()
'Updateby Extendoffie 20161206
    Dim wsSheet As Worksheet
    Application.ScreenUpdating = False
    For Each wsSheet In ThisWorkbook.Worksheets
        If Not wsSheet.Name = "Blank" Then
            wsSheet.Activate
            With ActiveWindow
                .DisplayHeadings = False
                .DisplayWorkbookTabs = True
                .DisplayHorizontalScrollBar = False
            End With
        End If
    Next wsSheet
    Application.ScreenUpdating = True
End Sub

3. Then press F5 key to run this code, and the row and column headings in all worksheets of the active workbook have been hidden at once. See screenshot:

doc hide headings all sheets 1


arrow blue right bubble Hide row and column headings from all worksheets with Kutools for Excel

If you have Kutools for Excel, with its View Options feature, you can also hide the row and column headings across all worksheets.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days. 

After installing Kutools for Excel, please do as follows:

1. Click Kutools > Show / Hide > View Options, see screenshot:

doc hide headings all sheets 2

2. Then in the View Options dialog box, uncheck Row & column headers from the Window options section, and then click Apply to all sheets button, see screenshot:

doc hide headings all sheets 3

3. And then the row and column headers in all sheets will be hidden immediately.

Click to Download Kutools for Excel and free trial Now!



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.