How to display or hide sheet tabs and the Sheet Tab Bar in Excel?

Hide one or multiple selected sheet tabs with the Hide & Unhide feature

You can use Excel’s Hide & Unhide feature to hide one or multiple selected sheet tabs.

1. Select one or multiple sheet tabs that you want to hide on the Sheet Tab Bar.

   📝 Notes:

   • To select multiple adjacent sheet tabs, hold down the Shift key, and then click the first and last sheet tabs in the group.
   • To select multiple nonadjacent sheet tabs, hold down the Ctrl key, and then click each sheet tab individually.
2. Click Home > Format > Hide & Unhide > Hide Sheet.

   

All selected sheet tabs are then hidden from the Sheet Tab Bar.

Unlock Excel Magic with Kutools AI

• Smart Execution: Perform cell operations, analyze data, and create charts—all driven by simple commands.
• Custom Formulas: Generate tailored formulas to streamline your workflows.
• VBA Coding: Write and implement VBA code effortlessly.
• Formula Interpretation: Understand complex formulas with ease.
• Text Translation: Break language barriers within your spreadsheets.

Enhance your Excel capabilities with AI-powered tools. Download Now and experience efficiency like never before!

Display hidden sheet tabs with the Hide & Unhide feature

1. Click Home > Format > Hide & Unhide > Unhide Sheet.
2. In the Unhide dialog box, select the sheet tab that you want to display, and click OK.

With Kutools for Excel installed, you can use Hide Unselected Sheets to hide all sheet tabs except the active or selected ones, or use Unhide All Sheets to display all hidden sheet tabs with one click.

Hide all sheet tabs except the active or selected ones with one click

Click Kutools > View > Hide Unselected Sheets. All sheet tabs except the active one are then hidden.

Display all hidden sheet tabs with one click

Click Kutools > View > Unhide All Sheets to display all hidden sheet tabs at once. See screenshot:

You can display or hide the entire Sheet Tab Bar through Excel Options. Please follow these steps:

1. Click File > Options to open the Excel Options dialog box.
2. In the Excel Options dialog box, click Advanced in the left pane. Under Display options for this workbook, select or clear Show sheet tabs.
3. Click OK.

The Sheet Tab Bar will be displayed or hidden for the selected workbook.

The following two simple VBA macros can also help you hide or display the Sheet Tab Bar.

1. Click Developer > Visual Basic. In the Microsoft Visual Basic for Applications window, click Insert > Module, and then enter one of the following codes in the module.

   VBA code to hide the Sheet Tab Bar:

   Sub Macro()
   ActiveWindow.DisplayWorkbookTabs = False
   End Sub

   VBA code to display the Sheet Tab Bar:

   Sub Macro()
   ActiveWindow.DisplayWorkbookTabs = True
   End Sub

2. Click the Run button to run the code.

With Kutools for Excel installed, you can use its View Options feature to quickly display or hide the entire Sheet Tab Bar.

1. Click Kutools > View > View Options.
2. In the View Options dialog box, select or clear the Sheet Tabs option to display or hide the Sheet Tab Bar in Microsoft Excel.

The View Options feature of Kutools for Excel also lets you quickly show or hide many other Excel interface elements and settings, including the Formula Bar, Status Bar, gridlines, page breaks, zero values, and vertical and horizontal scroll bars. This saves you from searching for each setting separately. Click to learn more…