Tuesday, December 1, 2020
Home Productivity How to create custom keyboard shortcuts in Microsoft Excel

How to create custom keyboard shortcuts in Microsoft Excel

Complete skills in Microsoft Office require the use of keyboard shortcuts. Although Microsoft Excel has a lot of built-in keyboard shortcuts, for the best workflow, you usually need to customize or customize the keyboard shortcuts to better suit your needs.

create-excel shortcuts

Fortunately, Excel supports some customizable keyboard shortcuts, and we’re here to show you how to create your own.

Note Excel shortcuts

Unfortunately, it’s not all perfect for Excel’s custom shortcut. Excel does not provide functions to replace regular shortcuts, so you cannot adjust a shortcut to an existing one.

So there are three main types of keyboard shortcuts:

  • Common shortcuts, such as Ctrl + I italics that you cannot change in Excel.

  • Alt shortcuts to press Alt key to activate shortcuts to ribbon items. For example, by pressing Alt> N> T. selects More tab and then Table option.

  • Macro shortcuts that are fully customized. We will discuss these a bit.

So even if you can’t adjust any of the default shortcuts, you can still uses quite a bit of functionality in Ribbon or create macros. Therefore, we use these options to make custom shortcuts.

The Quick Toolbar (QAT) is a useful command bar that always stays at the top of the screen. By default, it contains only a few options, such as Save, Undoand do it again, which you may want to delete because they already have easy keyboard shortcuts. But you can add many other commands to QAT.

We mentioned that Alt codes allow you to use any tape. If you press Alt, you should notice some pop-ups that also appear near QAT, giving you a one-step shortcut to the Excel command you want.

Click the drop-down menu to the right of the current icons to configure the Quick Toolbar in Excel the way you want. You can check out a few general options here, but you should choose the complete list More commands.

Excel Customize the Quick Launch toolbar

This will open a customization window where you will see a list of available commands in the left pane and the current QAT commands in the right pane.

Customize the Quick Toolbar

Click any command in the right pane and press delete button to delete it, or use the arrow buttons on the right side of the screen to rearrange the current items. Once you’ve sorted it, look in the left pane for the new commands you want to add.

By default, a drop-down menu appears Popular commands, but you can change its format Commands that are not on the ribbon if you want to avoid copying existing content. You can also show All commands, but be warned that the list is quite long.

Excel QAT Add Delete Options

Scroll through the list and select the functions you want to access immediately. QAT allows a lot of commands, so don’t be afraid to pick multiple of your favorites or even discover new features to try.

If you want to create groupings, there is an option called which allows you to add a divider between the icons. And keep your settings for future use Imports and exports button in this window to export your customization.

Once you have everything in order, just click ALRIGHT return to Excel with the new and improved QAT. To use one of its functions, press Alt, followed by the command number, execute it immediately.

Excel Alt toolbar shortcuts

This is much faster than searching through menus to find the right command.

2. Create your own Excel macros

Macros are a very useful (but often overlooked) feature of Office that allows you to record a series of activities and play them automatically. For example, if you have difficulty remembering complex formulas, you can create a macro that automatically applies the formulas to specific cells.

The macros are actually correct Visual Basic code running in the background to get Excel to perform functions, but you don’t need to know how to program to take advantage of macros.

To get started, go to to enable the Developer Ribbon tab File> Preferences and select Customize the ribbon on the left screen. Make sure on the right side Developer is selected, and then press ALRIGHT return.

Excel Enable the developer ribbon

Saving new macros

You can now save the first macro. Direction Developer tab in the selection bar and select Record a macro that Code section. Give it a name to remember according to it (it can’t have spaces) and give it a key that works for you.

The speed dial box appears Ctrl + another key, but you can also add Transfer to do this by holding it down when you select the key. Keep in mind that you can skip the regular keyboard shortcuts here, so if you make your macro run Ctrl + Z, you can no longer use either shortcut.

Below Save the macro in, choose Personal macro book. This is a file that allows you to split macros between Excel workbooks, perfect for defining shortcuts. If you want to use macros in only one workbook, change the setting This workbook instead. Enter a brief description of your macro, if desired, and then click ALRIGHT.

New macro for an Excel record

From here, everything you do will be recorded. The macro comes in any cell you select, changes in the font you use, or the characters you type. For example, you can make a macro that selects cell B3, type “test”, and format it in bold. When you have completed the exact operation you want to record, select Stop recording is Developer tab to end the macro.

Using and editing macros

Then select to access the macro Macros the same Code -warrant Developer tab. This will display a list of your macros; Press Edit view the Visual Basic code of the macro if you want. This is a good way to make sure you don’t save extra steps, even if you don’t fully understand the code.

Example of Excel macro code

When you are satisfied, you can run the macro at any time by pressing the key combination you specified. To change the key combination later, select it from the list Macros and select Options.

Here’s an advanced tip: you can even combine macros and QAT. Once you’ve saved the macro, reopen the QAT menu and change Select commands box Macros. Select the macro you created from the list and you can add it to the QAT like any other function.

Therefore, if you have difficulty remembering macro shortcuts, you can run them from QAT instead. Alt and number.

What you do with macros is up to you, but there are many opportunities. Think of everything you do in Excel on a regular basis that you want to automate, and try to make a macro for it. Automating these tedious tasks can save you time.

Look at us a guide to making Excel macros for more ideas and help.

Easily create custom Excel shortcuts

Now you don’t have to waste time performing repetitive tasks or hunting using Excel menus to find a particular feature. Setting up keyboard shortcuts takes little time and everyone wants different ones, but they are essential for Excel efficiency.

Macros aren’t scary when you’ve done a few, and QAT is handy for everyone. But these are not the only time savers that Excel hides.

Image Credit: GooDween123 /Shutterstock

excel-time-savers-featured


About the author

.

Patriotic Hackershttps://patriotichackers.com
Patriotichackers.com is an online tech and life hacks website. You can get here all kinds of content on Simplified Technology and Crafts. So you can catch us on Social Media Platforms to stay updated with us.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments