Move tab bar
in [General]
|
From: SteveZmyname on 23 Apr 2010 10:45 Hello Is it possible to move the tab bar from the bottom of the excel sheet to the right side? I have over 20 tabs and think if they were listed vertically they could all be seen on one screen. thanks Steve
From: Dave Peterson on 23 Apr 2010 11:05 Nope. If you're looking to select a different worksheet... If you rightclick on the VCR like controls (to the left of the worksheet tabs), you'll see a list of worksheets in that workbook. Other options: Maybe you could use David McRitchie's Build Table of Contents to get the list and the hyperlinks all at once: http://www.mvps.org/dmcritchie/excel/buildtoc.htm Another option if you want a more generic solution: http://contextures.com/xlToolbar01.html (From Debra Dalgleish's site.) It builds a toolbar that you can use with any workbook to navigate to any worksheet. There's a link on that site for an xl2007 version for the ribbon (from Ron de Bruin). If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm SteveZmyname wrote: > > Hello > Is it possible to move the tab bar from the bottom > of the excel sheet to the right side? > > I have over 20 tabs and think if they were listed vertically > they could all be seen on one screen. > > thanks > Steve -- Dave Peterson
From: SteveZmyname on 23 Apr 2010 14:23 DAve Excellent information thank you! Is there a way to make the window taller that I get when right clicking the VCR buttons? Steve "Dave Peterson" wrote: > Nope. > > If you're looking to select a different worksheet... > > If you rightclick on the VCR like controls (to the left of the worksheet tabs), > you'll see a list of worksheets in that workbook. > > Other options: > > Maybe you could use David McRitchie's Build Table of Contents to get the list > and the hyperlinks all at once: > http://www.mvps.org/dmcritchie/excel/buildtoc.htm > > Another option if you want a more generic solution: > http://contextures.com/xlToolbar01.html > (From Debra Dalgleish's site.) > > It builds a toolbar that you can use with any workbook to navigate to any > worksheet. There's a link on that site for an xl2007 version for the ribbon > (from Ron de Bruin). > > If you're new to macros, you may want to read David McRitchie's intro at: > http://www.mvps.org/dmcritchie/excel/getstarted.htm > > > SteveZmyname wrote: > > > > Hello > > Is it possible to move the tab bar from the bottom > > of the excel sheet to the right side? > > > > I have over 20 tabs and think if they were listed vertically > > they could all be seen on one screen. > > > > thanks > > Steve > > -- > > Dave Peterson > . >
From: Dave Peterson on 23 Apr 2010 14:30 Not that I've seen. But if you have lots (more than 15 (I think) sheets), then they'll be an option at the bottom to show all the sheet names. SteveZmyname wrote: > > DAve > Excellent information thank you! > Is there a way to make the window taller that I get > when right clicking the VCR buttons? > > Steve > > "Dave Peterson" wrote: > > > Nope. > > > > If you're looking to select a different worksheet... > > > > If you rightclick on the VCR like controls (to the left of the worksheet tabs), > > you'll see a list of worksheets in that workbook. > > > > Other options: > > > > Maybe you could use David McRitchie's Build Table of Contents to get the list > > and the hyperlinks all at once: > > http://www.mvps.org/dmcritchie/excel/buildtoc.htm > > > > Another option if you want a more generic solution: > > http://contextures.com/xlToolbar01.html > > (From Debra Dalgleish's site.) > > > > It builds a toolbar that you can use with any workbook to navigate to any > > worksheet. There's a link on that site for an xl2007 version for the ribbon > > (from Ron de Bruin). > > > > If you're new to macros, you may want to read David McRitchie's intro at: > > http://www.mvps.org/dmcritchie/excel/getstarted.htm > > > > > > SteveZmyname wrote: > > > > > > Hello > > > Is it possible to move the tab bar from the bottom > > > of the excel sheet to the right side? > > > > > > I have over 20 tabs and think if they were listed vertically > > > they could all be seen on one screen. > > > > > > thanks > > > Steve > > > > -- > > > > Dave Peterson > > . > > -- Dave Peterson
|
Pages: 1 Prev: All worksheets in document are not saving! Next: document doesn't auto display when selected |