In this segment, you will learn a lot about using shortcuts in Microsoft Excel.

Excel shortcuts for Windows and Mac

Keyboard Shortcuts are an absolute necessity for an Excel user in order to achieve optimal efficiency.

Many of the people who are very familiar with MS Excel do not make full use of the Keyboard Shortcuts. Using them speeds up work, reduces the usage of the mouse, saves enormous time and with little practice will prove to be an investment yielding lifelong benefits.

The shortcut keys differ between Windows and Mac keyboards. Our notes deal with the keys for Windows keyboards only and should be functional in most of them.


How to use Excel Shortcuts (Press, Hold and Release Keys)


Before we take a deep dive into the topic, keep in mind the following rules. Excel shortcuts use two types of dividers: the comma sign (,) and the plus (+) sign. Just a few words about the differences:

A comma sign (,) means that you need to press and release keys in order. For example, if you want to use the ‘Increase font size‘ shortcut in Excel, use the Alt, H, F, G combination. Press Alt, then release Alt, then press H, release H, and so on.

A plus sign (+) means that you need to press and hold each key in order. To increase the font size in Mac Excel, use the Command + Shift + > shortcut. In this case, press the keys simultaneously.

Types of Excel Shortcuts

Click following links to learn section wise shortcuts