Show sheet tabs section
How to show the sheet tabs section at the bottom of the workbook using Excel and VBA methods
File tab > Options > Advanced > Display options for this workbook > Check Show sheet tabs checkbox
| 1. Select the File tab. |  |
| 2. Click on Options. |  |
| 3. Select the Advanced tab. |  |
| 4. Scroll down to Display options for this workbook section. 5. Check the Show sheet tabs checkbox. |
 |
| 6. Click OK. |  |
METHOD 1. Show sheet tabs section using VBA
VBA
Sub Show_sheets_tab_section()
'show sheet tabs
ActiveWindow.DisplayWorkbookTabs = True
ActiveWindow.DisplayWorkbookTabs = True
End Sub
EXPLANATION
This tutorial shows how to show the sheet tabs section at the bottom of the workbook using Excel and VBA methods. Therefore, we are assuming that the sheet tabs are hidden.
This tutorial provides one Excel method that can be applied to show the sheet tabs section. This is achieved in six steps by adjusting the workbook's options.
Using VBA the sheet tabs can be shown by setting the DisplayWorkbookTabs to True.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Hide sheet tabs section | How to hide the sheet tabs section at the bottom of the workbook using Excel and VBA methods | |
| Hide gridlines in a worksheet | How to hide gridlines in a worksheet using Excel and VBA methods | |
| Show gridlines in a worksheet | How to show gridlines in a worksheet using Excel and VBA methods | |
| Hide gridlines in a workbook | How to hide gridlines in a workbook using Excel and VBA methods | |
| Hide gridlines in multiple worksheets | How to hide gridlines in multiple worksheets using Excel and VBA methods |