Are you looking for an easy way to remember all those useful keyboard shortcuts in Microsoft Excel?
Our Excel Keyboard Shortcuts Mug is the perfect solution! It has over 60 of the most useful Excel keyboard shortcuts printed on it.
Excel has hundreds of shortcuts available but the ones that made it onto the mug have been hand-picked by me, John MacDougall, a Microsoft Excel MVP. These are the shortcuts I use all the time and find indispensable!
The mug has a sleek white ceramic design. This mug isn’t just a practical way to boost your Excel productivity, but it also looks good and feels great in your hands with its C-handle and rounded design.
You won’t just look like an expert spreadsheet user; you will be one! You’ll save valuable time while working on spreadsheets because you’ll know exactly what shortcut keys to press.
Ditch that mouse and start using those keyboard shortcuts like a boss with the help of our awesome mug today! Get this must-have item now with the link above before it’s gone!
Copy and Paste Keyboard Shortcuts
Everyone knows the Ctrl + C and Ctrl + V keyboard shortcuts to copy and paste values in Excel. These will copy and paste all the contents of the cell including any formats.
These shortcuts are the more advanced shortcuts that will allow you to customize exactly what is copied and pasted.
| Shortcut | Description |
|---|---|
| Ctrl + D | Copy and paste from above |
| Ctrl + R | Copy and paste from right |
| Ctrl + Alt + V | Paste special |
| Ctrl + Shift + V | Paste as values |
Format Keyboard Shortcuts
When it comes to Excel, formatting can be a tedious task that absorbs valuable time.
There are a ton of keyboard shortcuts available that can make formatting a breeze. Knowing and utilizing these shortcuts can save you lots of time, especially when you know the most useful shortcuts.
| Shortcut | Description |
|---|---|
| Ctrl + 1 | Open format cells menu |
| Ctrl + B | Bold format |
| Ctrl + I | Italic format |
| Ctrl + U | Underline format |
| Ctrl + 5 | Strikethrough format |
| Ctrl + Shift + ! | Comma format |
| Ctrl + Shift + @ | Date format with AM/PM |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + ^ | Exponent format |
| Ctrl + Shift + % | Percent format |
| Ctrl + Shift + & | Outside borders |
| Ctrl + Shift + _ | Remove borders |
| Ctrl + Shift + ~ | General format |
Formula Keyboard Shortcuts
These shortcuts range from simple commands to copy and paste formulas to more complex formulas auditing features.
| Shortcut | Description |
|---|---|
| F2 | Edit active cell |
| F4 | Absolute and relative references |
| Alt + Enter | Enter line break in cell |
| Ctrl + ' | Copy formula from above |
| Ctrl + Shift + U | Expand or collapse the formula bar |
| Ctrl + [ | Selects precedents |
| Ctrl + ] | Selects dependents |
| Alt + = | Insert AutoSum |
| Shift + F3 | Function arguments |
| Ctrl + Shift + Enter | Insert array formula |
| Ctrl + ` | Display formulas |
Useful Function Key Shortcuts
Not all keyboards will have a function key row, but if yours does include them, you will want to make use of these handy shortcuts.
These are especially useful if you’re developing solutions in VBA.
| Shortcut | Description |
|---|---|
| F4 | Repeats last action |
| F7 | Spell check |
| F12 | Open save as menu |
| Alt + F8 | Open macro menu |
| Alt + F11 | Open VBA editor |
| Ctrl + F3 | Open name manager menu |
General Keyboard Shortcuts
These are must know general shortcuts for commonly used features.
| Shortcut | Description |
|---|---|
| Ctrl + ; | Enter current date |
| Ctrl + Shift + : | Enter current time |
| Ctrl + F1 | Expand or collapse the ribbon menu |
| Ctrl + F | Open find and replace menu |
| Shift + F11 | Insert new sheet |
| Ctrl + K | Insert hyperlink |
| F9 | Recalculates all sheets |
| Ctrl + E | Flash fill |
| Ctrl + N | Create a new blank workbook |
| Ctrl + W | Close the current workbook |
| Ctrl + F2 | |
| Ctrl + O | Open recent file |
Navigation Keyboard Shortcuts
| Shortcut | Description |
|---|---|
| Ctrl + Arrow | Move to end of current region |
| Ctrl + End | Move to lower right most used cell |
| Ctrl + Home | Move to upper left most cell |
| Ctrl + Page Down | Move to the next sheet |
| Ctrl + Page Up | Move to the previous sheet |
| Ctrl + Tab | Switch between open workbooks |
Pivot Table Keyboard Shortcuts
| Shortcut | Description |
|---|---|
| Alt + N + V | Insert a pivot table |
| Alt + Shift + Right Arrow Key | Group selected items |
| Alt + Shift + Left Arrow Key | Ungroup selected items |
| Ctrl + Shift + = | Insert Calculated Field |
| Ctrl + - | Hide the selected items |
Row and Column Keyboard Shortcuts
| Shortcut | Description |
|---|---|
| Ctrl + - | Delete rows or columns |
| Ctrl + Shift + + | Insert rows or columns |
| Ctrl + 9 | Hide rows |
| Ctrl + 0 | Hide columns |
| Ctrl + Shift + ( | Unhide rows |
| Ctrl + Shift + ) | Unhide columns |
| Alt + Shift + Left | Ungroup rows or columns |
| Alt + Shift + Right | Group rows or columns |
Selection Keyboard Shortcuts
| Shortcut | Description |
|---|---|
| Ctrl + A | Select all |
| Ctrl + G | Open go to menu |
| Ctrl + Space | Select entire column |
| Shift + Space | Select entire row |
Table Keyboard Shortcuts
Tables are the best tool for storing and managing tabular data in Excel. Once you start using them, you’ll wonder why you did use them before!
These are the top shortcuts for working with tables in Excel.
| Shortcut | Description |
|---|---|
| Alt + Down | Activate filter or dropdown |
| Ctrl + T | Insert a table |
| Ctrl + Alt + L | Refresh active filter |
| Ctrl + Shift + L | Toggle filters on or off |
| Ctrl + Shift + T | Toggle total row on or off |
Conclusions
Using Excel keyboard shortcuts is an indispensable way to speed up your work.
But it can be difficult to know which shortcuts are worth knowing. Memorizing all these shortcuts can also be a big task!
The Excel Keyboard Shortcut Mug will help you with these issues and get you to use the most useful Excel shortcuts while you enjoy your favorite drink.
Get your Excel mug today!
0 Comments