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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
How do i make sheet tabs look veritical - again 4
How to resize a Web Page 4
How do I open multiple worksheets each in its own tab 3
Reference to sheet name in another workbook 3
Unhiding multiple sheets 2
Problem with sheet tabs 2
Sheet Tabs 5

Back
Top