Here’s a simple, but very helpful tip if you work in large Excel documents with numerous worksheets.
Navigating around an Excel document with a lot of worksheets can be difficult. Moving to a different worksheet by scrolling through the tabs at the bottom of the Excel workspace—especially when the worksheet you are looking for is not located near the current worksheet—can be frustrating. There is, however, an easier way to quickly jump to a different worksheet in the current workbook.
In the bottom-left corner of the Excel workbook, you’ll see four navigation buttons to the left of the worksheet tabs.
Right-clicking on these buttons will display a list of all the worksheets, identified by name, in the current workbook. Selecting a name in this list will take you to that worksheet.
Tip by Matthew Graven, TechNet Tips Editor.