LinkBack URL
About LinkBacks
hello, i have a work book with too many sheets, every time i have to rol right or left to find the correct sheet or to search for the sheet,
how to have 2 rows of sheets or 3 rows of sheets instead of rolling or searching. tks for your help. Marko
hello, i have a work book with too many sheets, every time i have to rol right or left to find the correct sheet or to search for the sheet,
how to have 2 rows of sheets or 3 rows of sheets instead of rolling or searching. tks for your help. Marko
That's not possible to put tabs in rows.
However you can right-click just to the left of the sheet tabs and select the sheet name from the popups.
http://screencast.com/t/3vCjfABzMa
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You can also "stretch" the area where the tabs are to show more of them. Just to left of the scroll bar, hover the mouse over the "divider", when the pointer changes, left-click and drag the scroll bar to the right (just as if you were widening a column)
Another alternative would be to have an "index" sheet that hyperlinks to each of your sheets when clicked on, and then a "home" button on each sheet to go back to the Index
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks