How to Create Excel Keyboard Shortcuts


In this tutorial, we will teach you how to create excel keyboard shortcuts. For the purpose of this tutorial, we will be using Macros. We will guide you on how to record a macro and then run it. The Macro allows you to set a keyboard shortcut for a set of actions that you have recorded as a macro.

Step 1 – Open Excel

First of all, click on start menu and type in excel in the search bar before you hit the enter key. With that done, a new excel workbook will open up.

Open Excel workbook

Step 2 – Record Macro option

Now go to the View tab. Over there, open up the Macros drop down menu and click on the Record Macro option in order to create a excel keyboard shortcut.

Record Macro in Excel

Step 3 – Configure the Macro

With that done, the Record Macro window will open up. Over there, type the name for the macro and enter the short cut key which will function along with the Ctrl key. Over there, let’s enter the letter “K” for the shortcut key.

You can enter the description and determine in which workbook the macro should be stored in.

Once you are done, simply click on the OK button.

Set the Macro

Step 4 – Stop macro recording

Now let’s start entering the data for which the shortcut key would be used. Over there, we will simply input random numbers in a table and align them properly as well.

Once done, let’s open up the Macro drop down menu and click on the “Stop Recording” option.

Stop recording for the Macro

Step 5 – Open a new sheet

With that done, now go to the file tab and let’s open up a new blank sheet.

Opening a blank sheet in Excel

Step 6 – Run the macro

In this new sheet, press the “Ctrl+K” key and you will see that all the data that we have previously recorded in the macro will appear over here. In this manner, you can use excel keyboard shortcuts to your advantage. Excel keyboard shortcuts such as Macro save you a lot of time. Instead of performing all those actions all over, you can simply use the shortcut key for the macro.

Execute the Macro