Managing a Large Number of Worksheets

[mark5767]

Hi, new here but this looks to be a pretty nice resource!

My question is I am dealing with workbooks with many worksheets. Like 30 sheets or even more. The sheets are nearly identical in format, only the part number is different and then each worksheet fills in basic part information based on the part number (description, costs, components, etc).

So, is there a way to quickly see all the worksheets in the workbook without having to scroll to the right on the bottom navigation bar? I was hoping there was a way to view all the tabs at once either by modifying how the navigation bar looks (stacking up the tabs and letting me see all 30 at once) or perhaps some pull down menu or function that simply lets me navigate to a certain sheet based on part # (each sheet is just named with a 6 digit part #).

Any comments greatly appreciated, thank you!

 

[VoG]

Yes, this is possible. Right click in the navigation arrows (bottom left) and a pop up list of sheets will be displayed. Click on a sheet name to select that sheet.

 

[Jaafar Tribak]

You know you could right click over the arrows to the left of the worksheet tabs to bring up a popup menu with all the worksheets .

 

[mark5767]

My goodness, that was easy! Thank you!

I consider myself reasonably experienced with Excel but never dealt with workbooks with so many sheets before. So I never really had a need to navigate this way. Right click does the trick once again. Thanks again!

 

[fari1]

thats awsum didn't know that