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.
Get immediate free access to PDF Cheat Sheet with more than 350 Excel keyboard shortcuts and hotkeys. Lists the most common and popular keyboard shortcuts. 350 + Excel Keyboard Shortcuts And Hotkeys: Free PDF Cheat Sheet. I hope that this Cheat Sheet helps you improve your Excel skills and become even more efficient and productive.
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
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
![Keyboard Shortcut For Excel Sheet Switch Mac Keyboard Shortcut For Excel Sheet Switch Mac](/uploads/1/2/5/2/125288984/249902459.jpg)
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!