Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 06, 11:55 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 5
Default 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

  #2   Report Post  
Old December 9th 06, 03:05 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
Default 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


  #3   Report Post  
Old December 14th 06, 06:34 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 5
Default 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



  #4   Report Post  
Old December 14th 06, 07:20 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
Default 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.



  #5   Report Post  
Old December 15th 06, 02:15 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 5
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My sheet tabs disappeared with entered data. Can it be restored? Irene V in NJ Excel Discussion (Misc queries) 8 September 12th 06 05:43 PM
Hiding rows while sheet is protected burnsbyrne Excel Discussion (Misc queries) 5 August 22nd 06 08:40 PM
view excel sheet tabs in multiple rows gingerq Setting up and Configuration of Excel 2 June 27th 06 01:25 AM
HOW DO I HAVE TWO ROWS OF SHEET TABS? Tess Excel Discussion (Misc queries) 2 June 9th 06 01:54 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017