Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel 2010
Posted on 2012-12-25
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Hello,
Excel only shows one row of sheet tabs and it is not possible to show several rows of tabs, not even with VBA. However, you can right-click on the navigation arrows to see a list of worksheets. It shows a "more" link to display more than the 15 (or so) sheets that are listed by default.
You could also rename the sheets to use shorter names, so more sheets fit on the tab bar.
And you can re-arrange the order of the sheets (by dragging them) to make sure the ones you need are displayed without having to scroll.
Cheers, teylyn
Excel only shows one row of sheet tabs and it is not possible to show several rows of tabs, not even with VBA. However, you can right-click on the navigation arrows to see a list of worksheets. It shows a "more" link to display more than the 15 (or so) sheets that are listed by default.
You could also rename the sheets to use shorter names, so more sheets fit on the tab bar.
And you can re-arrange the order of the sheets (by dragging them) to make sure the ones you need are displayed without having to scroll.
Cheers, teylyn
Active today
You may rename the tabs to 1, 2, 3, ... , A, B, C, ... etc. This way I can display more than 40 tabs. If they still don't fit then you should use higher display resolution or you may simply switch from tab to tab by CTRL+PgDown/PgUp.
Tab switching by the keyboard can ensure no missing tab in your process.
BTW, I would recommend to write a short VBA code which will go through all tabs and prepare the consolidated sheet automatically.
Tab switching by the keyboard can ensure no missing tab in your process.
BTW, I would recommend to write a short VBA code which will go through all tabs and prepare the consolidated sheet automatically.
You can use these 2 macros to jump forward or backwards through x number of tabs:
Flyster
Sub FwdTab()
ActiveWindow.ScrollWorkbookTabs Sheets:=19
End Sub
Sub RwdTab()
ActiveWindow.ScrollWorkbookTabs Sheets:=-19
End Sub
Flyster
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 2 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.