Microsoft Excel Keyboard Shortcut Mug

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`	Print
`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!

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.