Excel Tip Tuesday: Navigating Worksheets with the Sheet Tab

Posted by Lisa on July 10, 2018 at 10:00 AM

Excel IconDo you have an Excel workbook that has a ton of worksheets? And does it take you forever to find the specific sheet you are looking for? If you answered "yes" and "yes," then there's a shortcut you should be using to see all sheets in one place.

Typically, if you have multiple sheets in a workbook, you use the arrows on the bottom left to scroll through them and eventually view the tab you want:

Excel Tips - Navigating Worksheets1

But, if you right-click on the arrows instead, you can view all your sheets in a list format, select the one you want to go to directly, and then click OK:

Excel Tips - Navigating Worksheets2

Voila! You are at the sheet you selected through a couple of clicks instead of clicking the arrows many, many, oh so many times.

Excel Tips - Navigating Worksheets3

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts