troubleshooting Question
Excel 2010
asked on
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.
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 4 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.