Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I HAVE TWO ROWS OF SHEET TABS?
I have a worksheet which currently has around 20 sheet tabs at the bottom,
with more being added in the future. Is there any way to have more than one row of tabs, so that I can see all the tabs at once without having to scroll back and forwards? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I HAVE TWO ROWS OF SHEET TABS?
have not seen it but i use ctrl+pgdwn or pgup and that is faster and works nicely or create a macro that asigns to your icons up top to to dropdown box and select your sheet number ? maybe -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=550260 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I HAVE TWO ROWS OF SHEET TABS?
Hi,
if you use Excel 2003 (I am not sure for previous versions), you can right click on arrows that are on the left of sheet names and you'll get a "menu" with all your sheets... and then just choose the one you want. Regards, Nika Lampe "Zygan" wrote: have not seen it but i use ctrl+pgdwn or pgup and that is faster and works nicely or create a macro that asigns to your icons up top to to dropdown box and select your sheet number ? maybe -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=550260 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
view excel sheet tabs in multiple rows | Setting up and Configuration of Excel | |||
sorting a sheet with outlined rows | Excel Discussion (Misc queries) | |||
Why do sheet tabs keep disappearing? Box in Tools is checked. | Excel Discussion (Misc queries) | |||
Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
Moving rows to sequential position on another sheet | Excel Discussion (Misc queries) |