How to Switch Between Worksheets in Excel

A number of people in my office have been asking me how they can easily switch between worksheets in Excel using their keyboards rather than having to click on an individual sheet and this article will addresses that issue.

This may sound lazy to someone who does not use Excel very often, but when you’re a manager and have an Excel spreadsheet in front of you with 50 tabs, that little mouse pointer can start to be a real pain!

Anyway, it’s always good to know shortcuts if you can. I’ve been in the situation numerous times where my touch pad died and I didn’t have a mouse laying around. Knowing some slick keyboard shortcuts can make the difference between getting some work done and taking a coffee break.

Switch Between Worksheets in Excel

excel switch tabs

So in order to move through sheets or tabs in an Excel workbook using the keyboard, simply press and hold CTRL and then press the PgUp or PgDn buttons to move from right-to-left or left-to-right! That’s it!

That’s one of my favorite shortcut keys in Excel, but there are several other ones also, which you might find useful:

CTRL + ; – Enters the current date into the active cell

CTRL + A – Selects the entire worksheet

ALT+F1 – Creates a chart of the data in the current range

SHIFT+F3 – displays the Insert Function dialog box

SHIFT+F11 – Inserts a new worksheet

CTRL+HOME – Moves to the beginning of a worksheet

CTRL+SPACEBAR – Selects an entire column in a worksheet

SHIFT+SPACEBAR – Selects an entire row in a worksheet

If you want to learn more keyboard shortcuts for Excel, check out the Office blog where they have listed over 100 shortcuts.

You can also check out my other posts on keyboard shortcuts, including how to right-click using the keyboard, move your mouse with the keyboard, and switch between browser tabs.

Any other shortcut you would want to know about Excel? Post a comment and I’ll try to get you the info! Enjoy!