Excel Custom Keyboard Shortcuts: What You Can Set

How-to basics · Updated November 19, 2026

Excel for Microsoft 365 on Windows does not let you freely remap every built-in command to a shortcut of your choice. You can still create useful shortcuts by putting commands on the Quick Access Toolbar, assigning shortcuts to macros, or using VBA to map a key combination while a workbook is open.

What Excel means by a custom shortcut

A keyboard shortcut is a key combination that triggers an action, such as Ctrl+C to copy. Excel includes many built-in shortcuts, but its standard Windows settings do not provide a general editor for changing those shortcuts or assigning a new key combination to every ribbon command. The practical workarounds differ in scope: some call an existing command quickly, while others run a macro or a small piece of code.

It helps to distinguish three things that are often all called custom shortcuts:

  • A Quick Access Toolbar shortcut uses a numbered key tip to call a command you have added to the toolbar.
  • A macro shortcut runs a recorded or written macro using a key combination you assign.
  • A VBA key assignment uses code to make a key combination run a procedure, typically while a workbook is open.

These methods do not change Excel’s built-in shortcuts permanently. For example, adding a command to the Quick Access Toolbar does not replace the keyboard shortcut for another command; it gives you another way to reach the command.

Use the Quick Access Toolbar for ribbon commands

The Quick Access Toolbar (QAT) is usually the simplest choice when you want a keyboard route to a command that already exists in Excel, such as Freeze Panes or Paste Values. Add the command to the toolbar, then use its key tip. In Windows Excel, press Alt to display key tips; commands on the QAT are typically available with Alt+1 through Alt+9, according to their position. The displayed key tips are the safest guide if your layout differs.

  1. Right-click the command on the ribbon and choose Add to Quick Access Toolbar, if that option is available.
  2. Alternatively, open File > Options > Quick Access Toolbar.
  3. Choose a command from the list, select Add, and use the arrows to arrange the QAT order.
  4. Select OK, press Alt, and check the key tip shown for the command you want.

For example, if Paste Values is first on your QAT, Excel may show Alt+1 for it. If you reorder the toolbar, its number can change. Keep frequently used commands near the beginning, and check the displayed tip rather than memorizing a number that may no longer match your setup. You can add commands that are not visible on the ribbon by looking through the available-command list in Options.

This method is convenient because it does not require a macro or a macro-enabled file. Its limitation is that the shortcut is a numbered key tip, not an arbitrary combination such as Ctrl+Shift+V. It also calls only commands you can place on the toolbar; it cannot turn a sequence of several actions into one new operation.

Assign a shortcut to a macro

Use a macro shortcut when the task is a repeatable action that Excel does not provide as one command. A macro can be recorded for many routine operations or written in VBA. On Windows, assign its shortcut through the Macro Options dialog:

  1. Open Developer > Macros. If the Developer tab is missing, enable it in File > Options > Customize Ribbon by checking Developer.
  2. Select the macro name and choose Options.
  3. Enter a letter in the shortcut-key box. Excel uses Ctrl plus that letter; entering an uppercase letter by holding Shift assigns a Ctrl+Shift combination.
  4. Choose OK, then close the dialog. Save the workbook in a macro-enabled format, such as .xlsm, if it contains VBA.

Suppose you record a macro that formats a selected range as a particular report style. Assigning Ctrl+Shift+R can make it easy to run, provided that combination is free for your purposes. Be cautious with Ctrl plus a letter: it can override a familiar Excel shortcut while that macro is available. Ctrl+Shift combinations are often a safer starting point, but check for conflicts and choose a combination you can remember.

A macro shortcut is tied to where the macro is stored. If the macro is in one workbook, it is generally useful when that workbook is open. For a macro you want available across workbooks, users often store it in the Personal Macro Workbook, named PERSONAL.XLSB. That workbook is intended to load when Excel starts, but it must be created and saved appropriately. A macro stored in a workbook another person does not have will not automatically give that person the same shortcut.

Use VBA when you need a temporary key mapping

VBA’s Application.OnKey method can associate a key combination with a macro. Unlike the Macro Options shortcut, this approach can be set when a workbook opens and cleared when it closes. The following Windows example maps Ctrl+Shift+J to a macro that writes today’s date into the active cell. Put the first two procedures in a standard module and the workbook event procedures in the workbook’s ThisWorkbook module.

Public Sub InsertTodayDate()
    ' Write the current date into the selected cell.
    Dim target As Range
    Set target = ActiveCell
    target.Value = Date
End Sub

Private Sub Workbook_Open()
    ' Map Ctrl+Shift+J while this workbook is open.
    Application.OnKey "^+j", "InsertTodayDate"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ' Restore Excel's normal handling of Ctrl+Shift+J.
    Application.OnKey "^+j"
End Sub

In this notation, the caret represents Ctrl and the plus sign represents Shift. The macro changes the active cell, so select the intended cell first; if it contains something important, the value will be replaced. Also, the BeforeClose event restores the key assignment only when that event runs. If Excel stops unexpectedly, the mapping may remain in effect until the Excel session ends. Save a copy of the workbook before running a new macro: macro actions cannot be undone with Ctrl+Z.

VBA key mappings are more flexible than a QAT key tip, but they are also easier to mismanage. The mapping applies to the Excel application session, not just to a single worksheet, and another open workbook or add-in may use the same key. Use a distinctive combination, document what it does, and test it in a copy of the file before relying on it.

Choose the approach that fits the task

For a command you already use, the QAT is usually the lowest-maintenance option. For a sequence of steps, a macro shortcut may be more useful. VBA OnKey is worth considering when the mapping needs to be set and cleared automatically or when you need more control over when it is active.

  • Choose the QAT for a built-in command, a no-macro solution, or a shortcut you want to keep simple.
  • Choose a macro shortcut for a repeatable task, especially one that a recorded macro can perform.
  • Choose OnKey if you can maintain VBA and want workbook code to establish a temporary mapping.
  • Keep the built-in shortcut if the task is already quick or if changing its behavior would confuse other users.

Think about who will use the file, too. A personal workbook can suit a shortcut that only you need. A shared workbook calls for clear instructions, a file format that supports macros if needed, and a plan for users whose security settings block macros. A keyboard shortcut is only helpful if people know what it does and can access the code or command behind it.

Conflicts, limitations, and common problems

The most common surprise is that a shortcut works in one workbook but not another. That often happens because the macro belongs to a workbook that is closed, or because the QAT configuration differs between Excel installations. Another frequent issue is a key conflict: assigning a macro to a familiar Ctrl combination can make Excel’s usual action unavailable while the macro shortcut takes precedence.

  • Nothing happens: confirm that the macro exists, the workbook containing it is open, and macros are permitted by your organization’s security settings.
  • The wrong macro runs: check for duplicate macro names or another open workbook using the same shortcut.
  • The QAT number changed: press Alt and follow the key tip Excel currently displays; changing the toolbar order can change the number.
  • The shortcut is not available to colleagues: check whether the macro is in a file they have, whether the file is .xlsm, and whether their Excel settings allow it.

Excel’s ribbon Key Tips are another feature that can look like custom shortcuts. Pressing Alt reveals letters or numbers for ribbon tabs and commands. Those are navigation hints for the existing interface, not a general facility for assigning a new permanent Ctrl combination to any command. They can be useful without changing settings, but the displayed sequence may depend on the current ribbon and window.

Windows, Mac, and Excel for the web

The menu paths and key combinations above are for Excel for Microsoft 365 on Windows. On Mac, ribbon layouts and keyboard conventions differ, and some Windows combinations are used by macOS or have different meanings in Excel. The macro dialog and available key combinations can differ as well. If assigning a macro shortcut on Mac, use the shortcut options presented by that version of Excel and avoid assuming that a Windows Ctrl combination will behave identically.

Excel for the web does not run VBA macros, so VBA-based shortcuts and macro assignments are not a suitable way to add custom behavior there. The web version has its own keyboard shortcuts and interface, and some workbook features depend on opening the file in the desktop application. A QAT setup or macro workflow that works in desktop Excel should not be assumed to transfer unchanged to the browser or to another computer.

Save, security, and sharing considerations

Macros can make repetitive work faster, but they can also change or overwrite workbook data. Use a copy while building and checking a macro, and be particularly careful with code that affects selected cells, whole sheets, or multiple workbooks. Ctrl+Z does not reverse changes made by VBA, so a test copy and a saved backup are more dependable safeguards than relying on Undo.

Save a workbook containing VBA as an Excel Macro-Enabled Workbook (.xlsm); saving it as a standard .xlsx file removes the VBA project. Excel may also block macros or display a security warning, especially for files from the internet or an untrusted location. Do not enable macros just to make a shortcut work unless you trust the workbook and understand what the code does. For a shared file, explain the shortcut and provide a non-macro way to complete the task when possible.

Frequently Asked Questions

Can I assign Ctrl+Shift+V to Paste Values in Excel?
Excel’s standard Windows options do not provide a general way to assign that combination directly to the built-in Paste Values command. You can add Paste Values to the Quick Access Toolbar and use its Alt key tip, or create a macro that performs the desired paste and assign the macro a shortcut. The macro approach is a workaround, not a remapping of Excel’s built-in command.

Can I change an existing Excel shortcut?
Not through a general built-in shortcut editor in Excel for Windows. A macro can take over a combination while it is available, but doing so may interfere with the original action. If you only need faster access to a ribbon command, adding it to the QAT avoids replacing an existing shortcut.

Do custom shortcuts work in every workbook?
Not automatically. A macro shortcut is available when Excel can access the macro, such as when its workbook is open or when it is stored in the Personal Macro Workbook. QAT settings may also be specific to an Excel installation. Test the setup on the computer and in the files where you intend to use it.

Can I use a macro shortcut in Excel for the web?
No. Excel for the web does not run VBA macros. Open the workbook in desktop Excel to use a VBA macro shortcut, if your organization permits macros and the workbook contains the required code.

Will Ctrl+Z undo a macro?
Usually not. VBA actions generally clear or bypass Excel’s normal undo history, so Ctrl+Z cannot be relied on to reverse them. Save a copy before running unfamiliar code, and test macros on sample data first.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.