Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Huber57
 
Posts: n/a
Default Viewing multiple rows of worksheets in a workbook

Is it possible to view two or three rows of worksheet tabs in a workbook?

I have a workbook with many tabs and it would be easier to navigate if I
could see more than 8-10 at a time.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Viewing multiple rows of worksheets in a workbook

Nope.

But maybe you could just rightclick on the VCR like controls to the left of the
sheet tabs. You'll see a list of the worksheet names that you can select.

Huber57 wrote:

Is it possible to view two or three rows of worksheet tabs in a workbook?

I have a workbook with many tabs and it would be easier to navigate if I
could see more than 8-10 at a time.

Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Viewing multiple rows of worksheets in a workbook

Hi Hubert,
I would suggest sorting your worksheet tabs as the best way to organize
them so that you can find the tab you want. It will also help with the right
clicking on the worksheet navigation arrows that Dave P. mentioned.
http://www.mvps.org/dmcritchie/excel...#sortallsheets
Besides the macro there is addition information of interest in that topic.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
Nope.

But maybe you could just rightclick on the VCR like controls to the left of the
sheet tabs. You'll see a list of the worksheet names that you can select.

Huber57 wrote:
Is it possible to view two or three rows of worksheet tabs in a workbook?

I have a workbook with many tabs and it would be easier to navigate if I
could see more than 8-10 at a time.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Sorting multiple worksheets simultaneously Bannor Excel Discussion (Misc queries) 0 January 10th 06 12:33 PM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Sort rows across multiple worksheets - Excel 2003 Stamdale Excel Worksheet Functions 2 July 5th 05 04:30 PM
Continuous page numbers in workbook of multiple worksheets Val Excel Discussion (Misc queries) 3 June 23rd 05 07:32 PM


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

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

About Us

"It's about Microsoft Excel"