We all know that Excel workbooks can contain any number of worksheets and the tabs identifying those worksheets are located at the bottom of the screen.
I think most of my subscribers also know that when you have a workbook with many, many worksheets and all the tabs will not fit at the bottom of your screen, you use the navigation buttons in the bottom left-side of your screen to scroll through your worksheet tabs.
Still though, sometimes you have scroll a whole bunch because you don’t know whether you have to scroll right or left or how far, so it can be a pain.
I just learned this nifty little trick so I thought I would share it with you!
- Simply right-click on the navigation buttons (just to the left side of your worksheet tabs).
- Excel will display a Context menu that will list all your worksheets.
- Simply select the the worksheet of your choosing and you are finished!