Each of us who are using M.S.
Excel knows that we can activate a different sheets in a workbook by clicking its sheet tab left side bottom of the workbook. Many of us also know that you can press Ctrl-Page Up to activate the previous sheet, and Ctrl-Page Down to activate the next sheet.
But if your workbook contains more than one sheets, and not all of the sheets’ tabs fit on the screen, you may find it unexciting to scroll through the tabs or use the keyboard or mouse to activate a long distance sheet.
Here’s a little-known trick that will allow you to bypass repeated scrolling or typing: Display a pop-up list of sheet names by right-clicking one of the arrows to the left of the sheet tabs that are located at the bottom of the worksheet window (see the picture below).
Select a sheet from the list, and you’re there in a flash.