Having the right keyboard can be important for us Excel users. You can then copy/paste or audit the sheets without having to navigate all over the workbook. These are great if you are toggling back and forth between two sheets. The keyboard shortcut to select the previous sheet is: Ctrl+ Page Up
The keyboard shortcut to select the next sheet is: Ctrl+ Page Down If you're a keyboard shortcut lover, like me, here are a few shortcuts to quickly move between sheets. This is much faster than scrolling, then selecting the first/last sheet with the mouse.
If you want to speed up this process, checkout my post on how to Create Keyboard Shortcuts to Select the First or Last Sheet in Excel. Once you have scrolled to the front/back, you can then click the first/last sheet to select it. So yes, this action now requires two hands unless you have really really long fingers or use a left-handed mouse. You can see this tip by hovering your mouse over the buttons. You now have to hold the Ctrl key when clicking the sheet navigation buttons to scroll to the first or last sheet. These actions were consolidated into the sheet navigation buttons in the bottom left corner of the application window. Starting in Excel 2013 we lost the dedicated buttons to navigate to the first or last sheet. There were dedicated buttons to scroll to the first or last sheet in the workbook. If your workbook has a lot of tabs then you might want to quickly navigate to the first or last sheet in the workbook. ? #2 Navigating to the First or Last Sheet If you are in need of a high-five or pat on the back (and who isn't), then feel free to share this one with your boss and co-workers. You can also use this technique when multiple sheets are selected. It's much faster than right-clicking the tab and going to the Move or Copy… menu. I broke it out into 4 steps, but it really feels like 2 steps once you get the hang of it.
A plus symbol will appear in the sheet mouse icon.