30 Excel shortcuts to speed up your work

Time is money: It can sometimes take a while to find the right button to click on in the right menu. This is why many users resort to keyboard shortcuts. You can also sig­ni­fic­antly speed up the work process in Excel using shortcuts for fre­quently used functions and inputs. We introduce you to the most useful Excel keyboard shortcuts and explain how you can create your own.

Shortcuts mean that functions can be executed faster in many programs and operating systems. To use shortcuts like these, you usually have to press several keys sim­ul­tan­eously, although it’s not necessary to press them exactly at the same time. It works if you simply press down one key, keep holding it down, then press another one. The function isn’t carried out until you release all keys sim­ul­tan­eously.

The most popular key com­bin­a­tions are probably [Ctrl] + [C], [Ctrl] + [V], and [Ctrl] + [X]. These enable you to copy, paste, and cut files in many ap­plic­a­tion situ­ations. These shortcuts also work in Excel. We won’t introduce these shortcuts in this article, since they aren’t specific to Excel and can be used uni­ver­sally.

Instead, you will learn which special Excel shortcuts you can use to speed up work in the spread­sheet program. Besides the shortcuts for Windows, we will also list Mac Excel shortcuts.

Every user has different pri­or­it­ies and different chal­lenges to overcome. This makes it im­possible to offer all the Excel shortcuts to please everyone. But the good news is that Microsoft enables you to create your own shortcuts. You need macros for this, which make it possible to record and save a sequence of steps. When the macro is executed af­ter­wards, the same steps will be performed auto­mat­ic­ally by Excel. The practical thing about it is that you can assign macro shortcuts and activate them quickly. To create an Excel shortcut, first select the “Record Macro” tool, then select a name for the macro and assign a shortcut to it. You should choose a com­bin­a­tion that isn’t already being used by Excel, otherwise the older com­bin­a­tion will lose its original function. So, in addition to the default control key, you can also use the shift key and combine both with a letter. If you want, you can write a de­scrip­tion with the new macro so that you can see straight­away what it does. In this first mask, you decide how you want to save the macro. If you choose “This Workbook” or “New Workbook,” the macro and therefore also the Excel shortcut are only valid in a single folder. The best way around this is to select “Personal Macro Workbook,” meaning the macro will be available whenever you use Excel. Once you’ve created a macro, you may need to make changes to it. The cell spe­cific­a­tions within the function are always absolute. This means that as soon as you add another line, for example, it will no longer be taken into account by the macro. To change this, select the cor­res­pond­ing macro under “View Macros” and go to “Edit”. Microsoft Visual Basic for Ap­plic­a­tions (VBA) will open and this is where you can access the macro’s source code and make changes. The function for selecting the area can be found, for example, under “.SetRange.”