In addition to knowing which features and functions can help you work faster in Excel, knowing a few keyboard shortcuts will help as well. You see, the faster you can communicate with Excel the faster you’ll get your Excel-work done. So, in this post, I’ll talk about 3 of my most-used shortcuts and then show you how to easily figure out the shortcuts for your most-used commands.
Here are 3 shortcuts that I use on a daily basis:
When you press and hold the Ctrl key, and then hit the PageDown button, Excel activates the next worksheet. Ctrl and PageUp activates the previous worksheet.
Mac Users: depending on your keyboard, you may or may not have a PageDown button. If not, I believe holding Fn and Down arrow does the PageDown, so, you’d use Ctrl+Fn+Down
2) Alt+I, R
To insert a new worksheet row, I use Alt+I, R (for Insert Row). There are other shortcuts, but I prefer this one because it does not require me to select the entire row first or respond to a subsequent dialog box asking if I’d like to insert cells or a row. Plus, it inserts the same number of rows as the selected range. That is, if you select a single cell, it will insert one row. If you select 3 cells vertically, it will insert 3 rows, and so on.
Mac users: you may not have an alt key, so you may need ctrl + shift + =
The F2 key toggles into Edit mode, meaning, you can select a cell and hit F2 and then start editing it. Use Esc to get out without making any changes, or Enter to commit the changes.
Mac users: your F keys (function keys) may not be acting as function keys, so, you’ll either need to include the Fn key or go into System Preferences and check Use f keys as traditional function keys.
It is relatively easy to figure out the shortcuts for the commands you use frequently.
One quick way to see if there is a direct keyboard shortcut is to hover over the command icon and see if a keyboard shortcut is displayed in the pop up. For example, hovering over the Insert > Table command displays this message revealing the shortcut Ctrl+T:
If there isn’t a keyboard shortcut for the specific command you want to use, you can always use your keyboard to navigate through the user interface without a mouse. For example, if you press the Alt key, Excel reveals the letters that correspond to each ribbon tab, like this:
Then, you can press the letter for the desired tab to reveal the letters that correspond to the individual commands. For example, pressing M for the Formulas tab will reveal the letters that correspond to the commands on the Formulas tab, like this:
You can use these quickly, without waiting for the letter to pop up too, so, you can go as fast as you’d like. And, for the ones you use often, you’ll memorize them so you can select stuff without even looking.
Also, it is important to note that while keyboard shortcuts like Ctrl + T tend not to change with updated Excel versions, navigation through the user interface with Alt keys may change over time or as new command icons are introduced.
Plus, you can use the Excel help system (F1) and search for “keyboard shortcuts” to reveal hundreds of available shortcuts in Excel, or, head to my Excel-friend Dave Bruns shortcuts page which documents 200+ shortcuts for both Windows and Mac.
In closing, I’ll say that keeping my hands on my keyboard certainly has helped me interact with Excel faster, enabling me to work faster. I hope the same can help you work faster too 🙂