Roadrunner’s Guide to Excel
The list of shortcuts below are the shortcuts I show to my students. Per a student’s recent suggestion I decided to compile them all into one document. If you’ve been in my class, then welcome back, these are for you! If you haven’t been in my class before, you’ll get plenty of use out of these. **You can scroll to the bottom of this blog to see tutorials on how to use each keyboard shortcut.
Navigate to end of data Ctrl + ↔↕
Navigate back to the beginning Ctrl + Home
Move between sheets Ctrl + Page Up / Page Down
Move between open workbooks Shift + Tab
Select a line of data Ctrl + Shift + ↔↕
Select your whole data set Ctrl + A
Expand your selection by one Shift + ↔↕
Execute and move to the right Tab
Execute and move down Enter
Execute and stay Ctrl + Enter
Other Useful Shortcuts
Make Absolute (lock or anchor) F4
Insert today’s date Ctrl + ; (semi-colon)
Basic Shortcuts (not specific to Excel)
Copy Ctrl + C
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Select multiple adjacent cells Shift
Select multiple non-adjacent cells Ctrl
Navigate to the end of your data set
Ctrl + Directional Keys (arrows on your keyboard)
Select a whole line of data inside a data set
Ctrl + HomeNavigate back to the beginning (go to cell A1)
Select your whole data set!
Ctrl + A
Select an entire column
Ctrl + Spacebar
Select an entire row
Shift + Spacebar
Insert a row or column
Ctrl + Shift + “+”
** Make sure you already selected an entire row or column.
Remove a row or column
Ctrl + “-”
** Make sure you already selected the entire row or column.
Expand a selection by one cell, or one row, or one column
Shift + Directional Keys (arrows on your keyboard)
Chelsea Dohemann is an instructor for LearniT! She teaches Microsoft Desktop courses and supplemental classes like PowerPoint Psychology and VBA coding for Excel. When she isn’t teaching or learning about new programs she’s playing cribbage, learning a language or playing a guitar near a campfire. Coming up Chelsea will be expanding her course offerings to include Visio, Photoshop, Adobe Acrobat, and Google Apps .