PC Review


Reply
Thread Tools Rate Thread

how do I get tabs to show in 2 or more rows?

 
 
Drew
Guest
Posts: n/a
 
      1st Apr 2008
Excel 2007

As many of my workbooks contain multiple tabs (worksheets) I have often
wondered if it is possible to have these tabs 'stack'.

For instance, rather than scroll left right to find one of 16 tabs it would
be great to have 2 rows of 8 or 4 rows of 4.

Is this possible?

Thank you.


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      1st Apr 2008
No.

Drew wrote:
>
> Excel 2007
>
> As many of my workbooks contain multiple tabs (worksheets) I have often
> wondered if it is possible to have these tabs 'stack'.
>
> For instance, rather than scroll left right to find one of 16 tabs it would
> be great to have 2 rows of 8 or 4 rows of 4.
>
> Is this possible?
>
> Thank you.


--

Dave Peterson
 
Reply With Quote
 
Drew
Guest
Posts: n/a
 
      2nd Apr 2008
Thank you Dave ... although not the answer I was hoping for. I was hoping
that Microsoft would have figured that one out by now. Silly me.

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> No.
>
> Drew wrote:
>>
>> Excel 2007
>>
>> As many of my workbooks contain multiple tabs (worksheets) I have often
>> wondered if it is possible to have these tabs 'stack'.
>>
>> For instance, rather than scroll left right to find one of 16 tabs it
>> would
>> be great to have 2 rows of 8 or 4 rows of 4.
>>
>> Is this possible?
>>
>> Thank you.

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      2nd Apr 2008
There are other ways to display the sheet names.

You could rightclick on the VCR/DVD like controls to the left of the horizontal
scroll bar and see them.

Or you could use an addin from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

Drew wrote:
>
> Thank you Dave ... although not the answer I was hoping for. I was hoping
> that Microsoft would have figured that one out by now. Silly me.
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > No.
> >
> > Drew wrote:
> >>
> >> Excel 2007
> >>
> >> As many of my workbooks contain multiple tabs (worksheets) I have often
> >> wondered if it is possible to have these tabs 'stack'.
> >>
> >> For instance, rather than scroll left right to find one of 16 tabs it
> >> would
> >> be great to have 2 rows of 8 or 4 rows of 4.
> >>
> >> Is this possible?
> >>
> >> Thank you.

> >
> > --
> >
> > Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
Bill Sharpe
Guest
Posts: n/a
 
      2nd Apr 2008
Drew wrote:
> Excel 2007
>
> As many of my workbooks contain multiple tabs (worksheets) I have often
> wondered if it is possible to have these tabs 'stack'.
>
> For instance, rather than scroll left right to find one of 16 tabs it would
> be great to have 2 rows of 8 or 4 rows of 4.
>
> Is this possible?
>
> Thank you.
>
>

If you name your tabs with just a couple of characters you should be
able to display quite a few in one row.

I realize that's not the question you asked...

Bill
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofil on variable rows, delete extract and show remaining rows 1plane Microsoft Excel Programming 3 17th Nov 2009 10:49 AM
How do you display tabs on two rows? Bryn Harman Microsoft Excel Setup 2 28th Mar 2008 06:42 PM
How do I show two rows of worksheet tabs instead of one? =?Utf-8?B?Um9idEpXaXR0?= Microsoft Excel Misc 1 8th Jun 2005 09:50 PM
Pivot Tables: How do I show ALL field rows, including empty rows?? ekongirl@gmail.com Microsoft Excel Worksheet Functions 2 8th Apr 2005 06:21 PM
Is there a way to have multiple rows of tabs? =?Utf-8?B?UGV0ZWV3ag==?= Microsoft Excel Misc 2 24th Feb 2005 11:41 PM


Features
 

Advertising
 

Newsgroups
 


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