ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheet Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/164570-sheet-tabs.html)

cokemanclassic

Sheet Tabs
 
Is it possible to view all of the tabs in a worksheet by creating two or more
"rows" of tabs instead of scrolling left and right?? Obviously I'm creating
more than 3 tabs in a worksheet.
--
cokemanclassic

FSt1

Sheet Tabs
 
hi,
no, so far as i know, in line is about the only way it works.
however, right click on the sheet navigator in the bottom left hand corner
of the sheet. a small popup will appear with all of your sheet names. click
on one to goto it. I think 15 or so is the max but there will be a "More
sheets" at the bottom. clicking "more sheets" will produce another popup with
scroll bars.

regards
FSt1

"cokemanclassic" wrote:

Is it possible to view all of the tabs in a worksheet by creating two or more
"rows" of tabs instead of scrolling left and right?? Obviously I'm creating
more than 3 tabs in a worksheet.
--
cokemanclassic


Peo Sjoblom

Sheet Tabs
 
Not really, if you right click on one of the arrow keys to the left you will
get a list and if you have more sheets you can select "More sheets" and you
will get a little pop up window with all the sheets
and from that window you can double click and sheet name and that will take
you to that particular sheet


--


Regards,


Peo Sjoblom



"cokemanclassic" wrote in message
...
Is it possible to view all of the tabs in a worksheet by creating two or
more
"rows" of tabs instead of scrolling left and right?? Obviously I'm
creating
more than 3 tabs in a worksheet.
--
cokemanclassic




cokemanclassic

Sheet Tabs
 
Thank You,
I'll give it a try.
--
cokemanclassic


"FSt1" wrote:

hi,
no, so far as i know, in line is about the only way it works.
however, right click on the sheet navigator in the bottom left hand corner
of the sheet. a small popup will appear with all of your sheet names. click
on one to goto it. I think 15 or so is the max but there will be a "More
sheets" at the bottom. clicking "more sheets" will produce another popup with
scroll bars.

regards
FSt1

"cokemanclassic" wrote:

Is it possible to view all of the tabs in a worksheet by creating two or more
"rows" of tabs instead of scrolling left and right?? Obviously I'm creating
more than 3 tabs in a worksheet.
--
cokemanclassic



All times are GMT +1. The time now is 05:48 AM.

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