If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
In complex Excel spreadsheets, the current single line for worksheet tabs is
restrictive. Instead, please consider including a second or third row option that will allow for numerous worksheets to be accessible at one time. This will save time instead of having to use the | | buttons. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
If you right click over the buttons you can pick from a larger set of Worksheets, but not all of them. You can pick more sheets which opens a dialogue box that allows you to pick the sheet you want. -- drewlake ------------------------------------------------------------------------ drewlake's Profile: http://www.excelforum.com/member.php...o&userid=30349 View this thread: http://www.excelforum.com/showthread...hreadid=504038 |
#3
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
How about trying this
I add a drop-down to the Formatting toolbar, and in ThisWorkbook, I setup up the toolbar buton and populate it so Private Workbook_Open() With Application.CommandBars("Formatting") With .Controls.Add(Type:=msoControlDropdown, temporary:=True) .Caption = "SheetGoto" .OnAction = "GotoSheet" End With End With End Sub Private Sub Workbook_Activate() Dim i As Long With Application.CommandBars("Formatting").Controls("Sh eetGoto") .Clear For i = 1 To Wb.Sheets.Count .AddItem Wb.Sheets(i).Name Next i .ListIndex = 1 End With End Sub In a standard code module I add this macro to actiavte the sheet Private Sub GotoSheet() With Application.CommandBars.ActionControl ActiveWorkbook.Sheets(.Text).Activate End With End Sub -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Peter Gross" Peter wrote in message ... In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. Instead, please consider including a second or third row option that will allow for numerous worksheets to be accessible at one time. This will save time instead of having to use the | | buttons. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...id=34febb21-51 6c-43e3-9d5a-c945b090cdfe&dg=microsoft.public.excel.misc |
#4
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
Peter-
Did you know you can display multiple tabs on screen simultaneously? With your sprdsht open, click Window New. Notice the filename (upper left corner) now includes a :1 or :2 suffix, indicating which window is visible. Click Window Arrange and select one of the display options (I prefer horizontal) to show both windows at once. Select window 1 and indicate which tab to display; select window 2 and indicate another tab to display. A change made to one window is made to the other window, so you can see the results of a change as it ripples throughout the sprdsht. |
#5
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
"Peter Gross" wrote:
In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. I have a worksheet with over 60 tabs. A summary worksheet pulls data from all of the other worksheets. I solved my navigation problem by putting a hyperlink for each of the other tabs on the summary page. On all the other worksheet , there is a hyperlink back to the summary worksheet. |
#6
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
"Jason" wrote: "Peter Gross" wrote: In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. I have a worksheet with over 60 tabs. A summary worksheet pulls data from all of the other worksheets. I solved my navigation problem by putting a hyperlink for each of the other tabs on the summary page. On all the other worksheet , there is a hyperlink back to the summary worksheet. This do the trick when navigating data sheets, how ever when working this summary work sheet and writing formulas containting cells from multiple worksheets there is just no easy way to use that method for entering 'name of tab 87'!C2 for instance. I'd still love to be able to use multiple rows of work sheet tabs or to shrink the font and/ or turn the tab names 90 degrees for easy access when working formulas. |
#7
|
|||
|
|||
Allow multiple rows of worksheet tabs for complex spreadsheets
Have you tried right-clicking on the group of arrows to the left of the
tabs? "Anton" wrote in message ... "Jason" wrote: "Peter Gross" wrote: In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. I have a worksheet with over 60 tabs. A summary worksheet pulls data from all of the other worksheets. I solved my navigation problem by putting a hyperlink for each of the other tabs on the summary page. On all the other worksheet , there is a hyperlink back to the summary worksheet. This do the trick when navigating data sheets, how ever when working this summary work sheet and writing formulas containting cells from multiple worksheets there is just no easy way to use that method for entering 'name of tab 87'!C2 for instance. I'd still love to be able to use multiple rows of work sheet tabs or to shrink the font and/ or turn the tab names 90 degrees for easy access when working formulas. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mail merging multiple columns with varying number of rows | troll_mage | Mailmerge | 1 | November 10th, 2005 06:42 PM |
copy rows meeting criteria to another worksheet | confused | Worksheet Functions | 4 | October 4th, 2005 11:51 AM |
Comparing a list to a Calendar worksheet. | PatrickL | Worksheet Functions | 0 | August 25th, 2005 04:21 PM |
Excel Workspace - Worksheet Tabs | Marc Lauter | Setting up and Configuration | 1 | October 1st, 2003 03:01 PM |