I'm a huge fan of keyboard shortcuts, therefore my fingers naturally and intuitively went for Ctrl + Tab to change sheets. Nada! After my 10th unsuccessful attempt in a row I just had to find the actual shortcut for this.
The correct keyboard shortcut for changing sheets in Excel
To change worksheets in Excel, press:
- Ctrl + PageUp for moving to the next sheet
- Ctrl + PageDown for moving to the previous sheet
Unfortunately, it's not possible to cycle from the last sheet to the first one or vice versa. Either way, learning these two shortcuts will save a few seconds every now and then.