How to toggle column visibility with a button in Excel?

This guide demonstrates how to create a button in Excel that toggles the visibility of specific columns, making it easier to manage and organize your data.

Use a button to toggle column visibility with a Toggle button
Use a button to toggle column visibility with Kutools for Excel

Use a button to toggle column visibility with a Toggle button

You can create a Toggle button to show hide columns by clicking it. Please do as follows.

1. Click Developer > Insert > Toggle Button (ActiveX Control). See screenshot:

Note: If you don’t see the Developer tab on the Ribbon, please click show/display developer tab in Excel to know how to enable it.

2. Draw a Toggle button on the worksheet. Right click it, and then select View Code from the right-clicking menu. See screenshot:

3. In the opened Microsoft Visual Basic Applications window, replace all content in the code window with below VBA code.

VBA code: button to show hide columns

Private Sub ToggleButton1_Click()
Dim xAddress As String
xAddress = "F:G"
If ToggleButton1.Value Then
    Application.ActiveSheet.Columns(xAddress).Hidden = True
Else
    Application.ActiveSheet.Columns(xAddress).Hidden = False
End If
End Sub

Note: “F:G” in the code means that columns F:G will be shown or hidden when the code runs. Please change them to your needs.

4. Press Alt + Q keys simultaneously to close the Microsoft Visual Basic Applications window.

5. Turn off the Design Mode with clicking Developer > Design Mode.

Now when you click the toggle button, the specified columns are hidden immediately.

While click it again, the columns are displayed.

Use a button to toggle column visibility with Kutools for Excel

If columns are already hidden in your worksheet, Kutools for Excel’s Toggle to unhide / hide all hidden column(s) utility can help you quickly toggle their visibility with just one click.

1. Click Kutools > Navigation.

2. Shift to the Column list pane, and then you can click the Toggle to unhide / hide all hidden column(s) button to show/hide columns in current worksheet.

Use a button to toggle column visibility with Kutools for Excel