Wednesday, August 24, 2011

Excel change sheets shortcut

The other day I was analyzing some website data using Microsoft Excel. The data was spread across multiple worksheets and I had to jump back and forth quite often.

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.

No comments:

Post a Comment