sheet tabs on multuiple rows
I work with files with many sheets. I often need to switch between the sheet
tabs. Right clicking on the lower left corner and selecting the needed sheet tab is too cumbersome for me. What about displaying all sheet tabs on as many tab rows as necessary? ---------------- 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...ic.excel.setup |
sheet tabs on multuiple rows
I would suggest sorting your worksheet tabs alphabetically so
that you can find them quickly, and install the following macro which is the equivalent of right-click on a sheet tabs navigation arrow on lower left of workbook followed by "More Sheets..." or with a macro Worksheets in VBA Coding and in Worksheet Formulas http://www.mvps.org/dmcritchie/excel...htm#moresheets You could also build an index sheet http://www.mvps.org/dmcritchie/excel/buildtoc.htm http://www.mvps.org/dmcritchie/excel/buildtoc2.htm -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mikky" wrote in message ... I work with files with many sheets. I often need to switch between the sheet tabs. Right clicking on the lower left corner and selecting the needed sheet tab is too cumbersome for me. What about displaying all sheet tabs on as many tab rows as necessary? ---------------- 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...ic.excel.setup |
sheet tabs on multuiple rows
Thank you David. Actually I am already using a macro to sort my sheets
alphabetically. The solutions you offer are useful but they are only things that can be done about the problem. The problem itself remains - Microsoft should do something to make navigation easier for users who would not dear to build macros. (I am not afraid to try macros but most people have never heard that word and do not want to know about it once they hear it would take them additional learning efforts!) I think sheets on multiple rows is an elegant solution and I guess it is not difficult to make. Also: I think an option to move the sheet row to top moght be good, too, I personally would prefer to have the sheet tabs just under the menu bars. "David McRitchie" wrote: I would suggest sorting your worksheet tabs alphabetically so that you can find them quickly, and install the following macro which is the equivalent of right-click on a sheet tabs navigation arrow on lower left of workbook followed by "More Sheets..." or with a macro Worksheets in VBA Coding and in Worksheet Formulas http://www.mvps.org/dmcritchie/excel...htm#moresheets You could also build an index sheet http://www.mvps.org/dmcritchie/excel/buildtoc.htm http://www.mvps.org/dmcritchie/excel/buildtoc2.htm -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mikky" wrote in message ... I work with files with many sheets. I often need to switch between the sheet tabs. Right clicking on the lower left corner and selecting the needed sheet tab is too cumbersome for me. What about displaying all sheet tabs on as many tab rows as necessary? ---------------- 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...ic.excel.setup |
sheet tabs on multuiple rows
With 208 worksheets one would not be able to tell if the
worksheet rows were at the top or at the bottom if the tabs are to appear on multiple rows and that's assuming that I got an even larger monitor than this crappy old monitor that I just bought three weeks ago as it is only displaying 1280 x 1024. I guess I'm old fashioned but I've become accustomed to being able to my data. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mikky" ... I think sheets on multiple rows is an elegant solution and I guess it is not difficult to make. Also: I think an option to move the sheet row to top moght be good, too, I personally would prefer to have the sheet tabs just under the menu bars. |
sheet tabs on multuiple rows
With 208 not, but with 20 or 30 sheets on multiple rows could be quite useful.
With 60 or hundred sheets multiple rows can be still be useful with vertical scroller added. "David McRitchie" wrote: With 208 worksheets one would not be able to tell if the worksheet rows were at the top or at the bottom if the tabs are to appear on multiple rows and that's assuming that I got an even larger monitor than this crappy old monitor that I just bought three weeks ago as it is only displaying 1280 x 1024. I guess I'm old fashioned but I've become accustomed to being able to my data. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mikky" ... I think sheets on multiple rows is an elegant solution and I guess it is not difficult to make. Also: I think an option to move the sheet row to top moght be good, too, I personally would prefer to have the sheet tabs just under the menu bars. |
All times are GMT +1. The time now is 05:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com