ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make more than one row of sheet tabs (https://www.excelbanter.com/excel-discussion-misc-queries/180750-how-do-i-make-more-than-one-row-sheet-tabs.html)

Ron

How do I make more than one row of sheet tabs
 
I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?

gator

How do I make more than one row of sheet tabs
 
Do you have to see them all the time or do you just want to jump from tab to
tab without scrolling...
Or, you might check out a previous question titled 'Workbook tabs'...do a
search.
--
Gator


"Ron" wrote:

I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?


gator

How do I make more than one row of sheet tabs
 
the question was posted 9/7/06 by Dave
--
Gator


"Gator" wrote:

Do you have to see them all the time or do you just want to jump from tab to
tab without scrolling...
Or, you might check out a previous question titled 'Workbook tabs'...do a
search.
--
Gator


"Ron" wrote:

I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?


Gord Dibben

How do I make more than one row of sheet tabs
 
You cannot do that.

You can right-click on the navigation arrows at lower left end of sheet tabs bar
and get a list of 15 sheets and "more sheets".

O)r you can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site.

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

On Thu, 20 Mar 2008 07:50:00 -0700, Ron wrote:

I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com