how do i make sheet tabs look veritical

  • Thread starter Thread starter Raks
  • Start date Start date
R

Raks

I have added many sheets in single workbook, how can i mahe the sheet tabs
veritical as i want them to appear on single screen
 
I have added many sheets in single workbook, how can i mahe the sheet tabs
veritical as i want them to appear on single screen
Click to expand...

As indicated by another poster I don't think you can either...
however; when I have encountered this type of display "issue" in the
past I simply created a worksheet with a "Main Menu" that is launched
on open, which contains buttons representing each worksheet in the
workbook... a little more work but the end result is more or less the
same and you can format it anyway you want. (ie be more descriptive/
vertical etc)

James
 
This cannot be done.

Right-click on one of the sheet navigation arrows to get a 15 sheet listing
and "more".

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP
 
As indicated by another poster I don't think you can either...
however; when I have encountered this type of display "issue" in the
past I simply created a worksheet with a "Main Menu" that is launched
on open, which contains buttons representing each worksheet in the
workbook... a little more work but the end result is more or less the
same and you can format it anyway you want. (ie be more descriptive/
vertical etc)
Click to expand...

Hi James
How would I create a worksheet with a "Main Menu"?
Using 2007
 
Hi Gord
I just can't get the Navigation Toolbar as per Dave's code on Debra
Dalgleish's site to work
http://www.contextures.on.ca/xlToolbar01.html
Click to expand...

Using 2007 instructions
Would there be something you can think of that I'm not doing correctly

I'm missing the Sheet Navigator commands
1. The Sheet Navigator commands should appear at the far right of
the Home tab on the Ribbon..
2. Click the Select a Sheet command, to view a list of sheets in
the active workbook.
3. From the dropdown list, select a sheet, and that sheet will be
activated.

I also didn't use Ron de Bruin's Modify the XML to Add the Buttons
code as I didn't know what I was doing
 
Back
Top