Avatar of Jegajothy vythilingam
Jegajothy vythilingam
Flag for United States of America asked on

Excel 2010

My OS is win 7 Prof 64 bit and I use Excel 2010.
I have many individual worksheets  which are in individual Tabs  in my Excel file, and each tab is a month's balance sheet.

At the moment, when I open one month's worksheet, the number of tabs listed below at the bottom of the worksheet, is limited to a few.  

I tried to increase  the length of the display at the bottom of the worksheet, but it still does not accommodate all my tabs because there are more than 12 tabs in this single file.  

Is there any way for me to display all the tabs at the bottom of the worksheet, even if it means having 2 lines of tabs at the bottom of the worksheet?

Why do I want this, I am at the moment doing a consolidated sheet, thus I have to go into each tab i.e. into each month's accounts;  to retrieve the income and expenditure, thus, it will be convenient if I could have all the tabs displayed so that I could jump in and out easily, and avoid any reference mistakes.

Thank u.
Microsoft ExcelMicrosoft OfficeMicrosoft Applications

Avatar of undefined
Last Comment
Flyster

8/22/2022 - Mon
SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Pavel Celba

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jegajothy vythilingam

ASKER
Excellent, workable advice.  Thank u
Flyster

You can use these 2 macros to jump forward or backwards through x number of tabs:
Sub FwdTab()

    ActiveWindow.ScrollWorkbookTabs Sheets:=19

End Sub

Sub RwdTab()

    ActiveWindow.ScrollWorkbookTabs Sheets:=-19

End Sub

Open in new window

Just change the 19 to the number of tabs you see at the bottom. You can also go Alt+f8, highlight the macro name and select Options to assign a keyboard shortcut.

Flyster
Your help has saved me hundreds of hours of internet surfing.
fblack61