I have an Excel workbook with over 50 worksheets. This is a necessity and I can't go away from it.

However, I find it hard to:

  1. Have an overview of all the worksheets available
  2. Quickly jump to a certain worksheet

For the time being, the only thing I can do is to press on the ... to move to the right and to arrive to a worksheet.

Isn't there a better way to get this overview quickly (something like pressing on the Windows+Tab button?

  • 1
    If you right-click the < > to the left of the sheet names, you get an 'Activate' dialog where you can jump to another sheet. Does that help? – spikey_richie Oct 12 at 8:01
  • Yes that is exactly what I was looking for.... for years I am struggling haha – JohnAndrews Oct 12 at 8:02
  • Turned it into an answer :) – spikey_richie Oct 12 at 8:26
up vote 1 down vote accepted

If you right-click the < > to the left of the sheet names, you get an 'Activate' dialog where you can jump to another sheet.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.