Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How To Display / Show Worksheet Tabs Vertically On Left Side Of Excel?
The worksheet tabs are automatically positioned at the bottom of the window by Excel, making it simple to navigate between sheets horizontally. This article is for you if you favour a vertical arrangement of worksheet tabs, though. When working with a lot of sheets or when you want to see a clear overview of the structure of your workbook, Excel's left side can display worksheet tabs vertically. It enables you to swiftly browse through your worksheets and immediately retrieve the desired sheet.
This guide will show you step−by−step how to change Excel's settings so that worksheet tabs appear vertically on the left side. No of your level of Excel proficiency, you'll find the directions to be simple to follow. In order to increase efficiency and organisation within the programme, let's get started and learn how to display worksheet tabs vertically on the left side of the screen.
Display / Show Worksheet Tabs Vertically On Left Side Of Excel
Here we will first add the VBA code to the workbook, then add the tab to the tool bar.. So let's see a simple process to know how you can display or show worksheet tabs vertically on the left side of Excel.
Step 1
Consider any excel sheet. First right click on sheet name and select view code to open VBA then double click on this workbook and copy the code into the textbox and close the VBA.
Right click > View Code > Double click > Copy > Alt + Q.
Code
Sub ShowSheetLists()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub
Step 2
Then click on arrow and select "more commands" .
Arrow > More Commands
Step 3
Then select macros from Choose Commands, then click on Thisworkbook.showsheetslist and click on Add, then click OK to complete the task.
Macro > Command > Add > Ok.
We can access the worksheet tab vertically.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can display or show worksheet tabs vertically on the left side of Excel to highlight a particular set of data.
2K+ Views
