A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can I arrange tabs vertically in Excel (not horizontally)?



 
 
Thread Tools Display Modes
  #1  
Old October 25th 07, 07:25 AM posted to microsoft.public.excel.misc
LinLin
external usenet poster
 
Posts: 46
Default Can I arrange tabs vertically in Excel (not horizontally)?

I use a lot of tabs / worksheets in a spreadsheets and if I could view them
vertically (ie on the RHS of the screen) I could fit more tabs in!

Is there anyway to change this?

Otherwise, how does everyone else work with a lot of tabs? The problem is
that when the tab name is too long, that also takes away the tab space at the
bottom of the screen.
thanks everyone!
Ads
  #2  
Old October 25th 07, 08:42 AM posted to microsoft.public.excel.misc
RagDyeR
external usenet poster
 
Posts: 3,572
Default Can I arrange tabs vertically in Excel (not horizontally)?

Have you tried using XL's built in "Sheet List"?

Right click on the small arrows to the left of the tabs.
This brings up a list of maybe 15 sheets, which you can expand to an
infinitely scrolling list of all the sheets in the WB.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LinLin" > wrote in message
...
> I use a lot of tabs / worksheets in a spreadsheets and if I could view

them
> vertically (ie on the RHS of the screen) I could fit more tabs in!
>
> Is there anyway to change this?
>
> Otherwise, how does everyone else work with a lot of tabs? The problem is
> that when the tab name is too long, that also takes away the tab space at

the
> bottom of the screen.
> thanks everyone!


  #3  
Old October 25th 07, 01:17 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 3,365
Default Can I arrange tabs vertically in Excel (not horizontally)?

See Ragdyer's response - it's about as good as you're going to get. In
direct response to your question, there's no option to align the sheet tabs
vertically.

Other option involves $$ and hardware solution: buy a wider screen and go to
as high a resolution as you can comfortably work with. Or change the zoom
level for the workbook to something lower than 100% or your current setting -
again how low you go is based on your ability to still read and use the
display.

"Ragdyer" wrote:

> Have you tried using XL's built in "Sheet List"?
>
> Right click on the small arrows to the left of the tabs.
> This brings up a list of maybe 15 sheets, which you can expand to an
> infinitely scrolling list of all the sheets in the WB.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "LinLin" > wrote in message
> ...
> > I use a lot of tabs / worksheets in a spreadsheets and if I could view

> them
> > vertically (ie on the RHS of the screen) I could fit more tabs in!
> >
> > Is there anyway to change this?
> >
> > Otherwise, how does everyone else work with a lot of tabs? The problem is
> > that when the tab name is too long, that also takes away the tab space at

> the
> > bottom of the screen.
> > thanks everyone!

>
>

  #4  
Old October 25th 07, 03:24 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,909
Default Can I arrange tabs vertically in Excel (not horizontally)?

How about a sheet navigation bar from Debra Dalglesih?

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

Or Bob Phillips' Browsesheets macro?

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25


Gord Dibben MS Excel MVP

On Wed, 24 Oct 2007 23:25:02 -0700, LinLin >
wrote:

>I use a lot of tabs / worksheets in a spreadsheets and if I could view them
>vertically (ie on the RHS of the screen) I could fit more tabs in!
>
>Is there anyway to change this?
>
>Otherwise, how does everyone else work with a lot of tabs? The problem is
>that when the tab name is too long, that also takes away the tab space at the
>bottom of the screen.
>thanks everyone!


  #5  
Old October 25th 07, 04:41 PM posted to microsoft.public.excel.misc
slow386
external usenet poster
 
Posts: 20
Default Can I arrange tabs vertically in Excel (not horizontally)?

What a time saver . . .
Thanks
Steve

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
...
> How about a sheet navigation bar from Debra Dalglesih?
>
> http://www.contextures.on.ca/xlToolbar01.html
>
> Or Bob Phillips' Browsesheets macro?
>
> See this google search result. All one line for the URL
>
> http://groups.google.com/group/micro...c19464f875bd25
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 24 Oct 2007 23:25:02 -0700, LinLin
> >
> wrote:
>
>>I use a lot of tabs / worksheets in a spreadsheets and if I could view
>>them
>>vertically (ie on the RHS of the screen) I could fit more tabs in!
>>
>>Is there anyway to change this?
>>
>>Otherwise, how does everyone else work with a lot of tabs? The problem is
>>that when the tab name is too long, that also takes away the tab space at
>>the
>>bottom of the screen.
>>thanks everyone!

>



  #6  
Old October 26th 07, 07:16 AM posted to microsoft.public.excel.misc
LinLin
external usenet poster
 
Posts: 46
Default Can I arrange tabs vertically in Excel (not horizontally)?

Hi Gord

Contextures worked a treat!
COuldn't get to the browsheets macro at work because of email filters to
blogs etc.

This will definitely change my life!

cheerio

"Gord Dibben" wrote:

> How about a sheet navigation bar from Debra Dalglesih?
>
> http://www.contextures.on.ca/xlToolbar01.html
>
> Or Bob Phillips' Browsesheets macro?
>
> See this google search result. All one line for the URL
>
> http://groups.google.com/group/micro...c19464f875bd25
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 24 Oct 2007 23:25:02 -0700, LinLin >
> wrote:
>
> >I use a lot of tabs / worksheets in a spreadsheets and if I could view them
> >vertically (ie on the RHS of the screen) I could fit more tabs in!
> >
> >Is there anyway to change this?
> >
> >Otherwise, how does everyone else work with a lot of tabs? The problem is
> >that when the tab name is too long, that also takes away the tab space at the
> >bottom of the screen.
> >thanks everyone!

>
>

  #7  
Old October 26th 07, 07:17 AM posted to microsoft.public.excel.misc
LinLin
external usenet poster
 
Posts: 46
Default Can I arrange tabs vertically in Excel (not horizontally)?

Thanks Ragdyer & JLatham - I learn a new thing about Excel everyday!

"JLatham" wrote:

> See Ragdyer's response - it's about as good as you're going to get. In
> direct response to your question, there's no option to align the sheet tabs
> vertically.
>
> Other option involves $$ and hardware solution: buy a wider screen and go to
> as high a resolution as you can comfortably work with. Or change the zoom
> level for the workbook to something lower than 100% or your current setting -
> again how low you go is based on your ability to still read and use the
> display.
>
> "Ragdyer" wrote:
>
> > Have you tried using XL's built in "Sheet List"?
> >
> > Right click on the small arrows to the left of the tabs.
> > This brings up a list of maybe 15 sheets, which you can expand to an
> > infinitely scrolling list of all the sheets in the WB.
> > --
> > HTH,
> >
> > RD
> >
> > ---------------------------------------------------------------------------
> > Please keep all correspondence within the NewsGroup, so all may benefit !
> > ---------------------------------------------------------------------------
> > "LinLin" > wrote in message
> > ...
> > > I use a lot of tabs / worksheets in a spreadsheets and if I could view

> > them
> > > vertically (ie on the RHS of the screen) I could fit more tabs in!
> > >
> > > Is there anyway to change this?
> > >
> > > Otherwise, how does everyone else work with a lot of tabs? The problem is
> > > that when the tab name is too long, that also takes away the tab space at

> > the
> > > bottom of the screen.
> > > thanks everyone!

> >
> >

  #8  
Old October 31st 07, 02:15 AM posted to microsoft.public.excel.misc
LinLin
external usenet poster
 
Posts: 46
Default Can I arrange tabs vertically and Alphanumerically!

Hi Gord

I asked Contextures to modify the toolbar so that it will sort the tabs as
well (previously the tabs had to be in order already).
Thought you might like to know! It's at the website with the same link below

cheerio
LinLin

"Gord Dibben" wrote:

> How about a sheet navigation bar from Debra Dalglesih?
>
> http://www.contextures.on.ca/xlToolbar01.html
>
> Or Bob Phillips' Browsesheets macro?
>
> See this google search result. All one line for the URL
>
> http://groups.google.com/group/micro...c19464f875bd25
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 24 Oct 2007 23:25:02 -0700, LinLin >
> wrote:
>
> >I use a lot of tabs / worksheets in a spreadsheets and if I could view them
> >vertically (ie on the RHS of the screen) I could fit more tabs in!
> >
> >Is there anyway to change this?
> >
> >Otherwise, how does everyone else work with a lot of tabs? The problem is
> >that when the tab name is too long, that also takes away the tab space at the
> >bottom of the screen.
> >thanks everyone!

>
>

  #9  
Old October 31st 07, 02:05 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,909
Default Can I arrange tabs vertically and Alphanumerically!

Thanks for the update.

Debra is so accommodating.


Gord

On Tue, 30 Oct 2007 19:15:00 -0700, LinLin >
wrote:

>Hi Gord
>
>I asked Contextures to modify the toolbar so that it will sort the tabs as
>well (previously the tabs had to be in order already).
>Thought you might like to know! It's at the website with the same link below
>
>cheerio
>LinLin
>
>"Gord Dibben" wrote:
>
>> How about a sheet navigation bar from Debra Dalglesih?
>>
>> http://www.contextures.on.ca/xlToolbar01.html
>>
>> Or Bob Phillips' Browsesheets macro?
>>
>> See this google search result. All one line for the URL
>>
>> http://groups.google.com/group/micro...c19464f875bd25
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Wed, 24 Oct 2007 23:25:02 -0700, LinLin >
>> wrote:
>>
>> >I use a lot of tabs / worksheets in a spreadsheets and if I could view them
>> >vertically (ie on the RHS of the screen) I could fit more tabs in!
>> >
>> >Is there anyway to change this?
>> >
>> >Otherwise, how does everyone else work with a lot of tabs? The problem is
>> >that when the tab name is too long, that also takes away the tab space at the
>> >bottom of the screen.
>> >thanks everyone!

>>
>>


  #10  
Old October 31st 07, 04:05 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,218
Default Can I arrange tabs vertically and Alphanumerically!

I think it's the law. She's Canadian!

Gord Dibben wrote:
>
> Thanks for the update.
>
> Debra is so accommodating.
>
> Gord
>
> On Tue, 30 Oct 2007 19:15:00 -0700, LinLin >
> wrote:
>
> >Hi Gord
> >
> >I asked Contextures to modify the toolbar so that it will sort the tabs as
> >well (previously the tabs had to be in order already).
> >Thought you might like to know! It's at the website with the same link below
> >
> >cheerio
> >LinLin
> >
> >"Gord Dibben" wrote:
> >
> >> How about a sheet navigation bar from Debra Dalglesih?
> >>
> >> http://www.contextures.on.ca/xlToolbar01.html
> >>
> >> Or Bob Phillips' Browsesheets macro?
> >>
> >> See this google search result. All one line for the URL
> >>
> >> http://groups.google.com/group/micro...c19464f875bd25
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Wed, 24 Oct 2007 23:25:02 -0700, LinLin >
> >> wrote:
> >>
> >> >I use a lot of tabs / worksheets in a spreadsheets and if I could view them
> >> >vertically (ie on the RHS of the screen) I could fit more tabs in!
> >> >
> >> >Is there anyway to change this?
> >> >
> >> >Otherwise, how does everyone else work with a lot of tabs? The problem is
> >> >that when the tab name is too long, that also takes away the tab space at the
> >> >bottom of the screen.
> >> >thanks everyone!
> >>
> >>


--

Dave Peterson
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I freeze panes horizontally and vertically at same time BW Excel Discussion (Misc queries) 15 October 16th 09 06:51 PM
aligning sheet tabs vertically, not horizontally Wilma Excel Worksheet Functions 1 March 10th 07 11:15 PM
How to create a floating bar chart vertically not horizontally... Cristina Charts and Charting in Excel 1 June 30th 06 09:45 PM
I would like the tabs in Excel to be listed vertically on left. Suzy Excel Discussion (Misc queries) 1 June 2nd 05 08:39 PM
Move cells vertically to horizontally Abe Excel Discussion (Misc queries) 1 March 23rd 05 02:57 AM


All times are GMT +1. The time now is 02:50 PM.


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