Create drop-down menu for sheets within an Excel file?

[kznmrexcel]

Hi, everyone,
I feel as if I saw this feature somewhere but I'm not certain. Is there a way to create a drop-down menu (or use a keystroke) to see a list of the sheets in an Excel file? I have a file with a large number of sheets, so navigating from left to right to click through the sheets is getting very cumbersome. Any ideas are appreciated.
Thanks,
Karen

 

[dmt32]

Hi,
no need to create anything Look at the bottom left corner of your Workbook - right click mouse and this will display the Activate dialog box showing a list of all worksheets.

Dave

 

[Fluff]

If you right click one of the arrows to the left of the tabs, it will show all the sheets.

 

[kznmrexcel]

If you right click one of the arrows to the left of the tabs, it will show all the sheets.

This is what I was looking for! Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.