Excel Keyboard Shortcuts: What You Can Customize in Excel

In Excel for Microsoft 365 on Windows, you cannot directly remap most built-in keyboard shortcuts through an Excel settings screen. You can customize the Quick Access Toolbar and reach its commands with Alt-number shortcuts, or assign a shortcut to a macro; those are the practical Excel-level options for making frequent actions easier to invoke.

What Excel lets you customize

Excel’s built-in shortcuts, such as Ctrl+C, Ctrl+V and Ctrl+Z, are part of the application’s keyboard behavior. Excel does not provide a general keyboard-shortcut editor that lets you change Ctrl+C to a different key combination or assign any ribbon command to any key you choose. That differs from some Office applications that have a dedicated keyboard customization dialog.

However, “customizing shortcuts” can mean several things. You can put a command on the Quick Access Toolbar (QAT), assign a key combination to a macro, or use an operating-system utility to remap keys. These approaches have different reach and trade-offs:

Quick Access Toolbar: Add existing Excel commands and call them by their QAT position using an Alt-number shortcut on Windows.
Macro shortcut: Run a recorded or written macro with a Ctrl-based shortcut that you assign in the macro options.
External remapping: Change how keys behave outside Excel or in selected applications using a separate tool. This is not an Excel setting and can affect other programs.

Choosing the right option depends on whether you want fast access to an existing command, a sequence of actions, or a genuine change to key behavior.

Customize the Quick Access Toolbar

The QAT is a small, customizable toolbar that can hold commands such as Save, Print Preview, Freeze Panes or commands that are otherwise harder to reach. Each command’s position matters: on Windows, pressing Alt+1 activates the first QAT command, Alt+2 the second, and so on. This does not change a built-in shortcut; it gives a command a new route through its toolbar position.

Open File > Options > Quick Access Toolbar.
In Choose commands from, select a category such as Popular Commands or All Commands.
Select a command and choose Add. Use the up and down controls to arrange the commands in the order you want.
Choose whether the toolbar applies to all documents or to the current workbook, if that choice is available, then select OK.
Use Alt+1 for the first command, Alt+2 for the second, and continue according to the displayed order.

For example, if Freeze Panes is the first QAT item, Alt+1 invokes it. If Save is first and Freeze Panes is second, use Alt+2 for Freeze Panes. Keep the most-used commands near the beginning so they need fewer keystrokes. You can also click the QAT’s drop-down control and select commands there, but the keyboard route is the point of arranging the toolbar.

The exact command names and available categories can vary with Excel updates and the workbook context. Some commands are available only when a particular feature or object is selected. The QAT is useful for direct access to commands; it does not combine multiple commands into one action.

Assign a shortcut to a macro

A macro is a recorded or programmed set of actions. In desktop Excel for Windows, you can assign a shortcut to a macro from the Macros dialog. This is a better fit than the QAT when one keystroke should perform a repeatable sequence, such as applying a standard layout or cleaning up a report.

Open View > Macros > View Macros, or use the Macros command on the Developer tab.
Select the macro and choose Options.
Enter a letter in the Shortcut key box. A lowercase letter assigns Ctrl+letter; an uppercase letter assigns Ctrl+Shift+letter.
Choose OK, close the dialog, and save the workbook in a macro-enabled format, such as .xlsm, if the macro is stored in that workbook.

For example, assigning lowercase J makes Ctrl+J run that macro while the workbook containing it is available. Assigning uppercase J uses Ctrl+Shift+J. Excel does not show a warning that fully protects you from choosing a combination people already use, so check the shortcut before assigning it. A macro shortcut can override a built-in shortcut while that macro is available; avoid replacing familiar combinations unless the change is intentional.

A macro stored in the current workbook is generally available when that workbook is open. To make a macro available across workbooks, it can be stored in the Personal Macro Workbook, which Excel loads in the background when it starts. That setup is more involved than adding a QAT command, and the macro still depends on macro availability and security settings. Keep a backup before changing or running macros: Excel’s undo command, Ctrl+Z, cannot undo a macro’s actions.

Choose between the QAT and a macro

Use the QAT when you want a shortcut to an existing Excel command without writing or recording code. It is usually the simplest choice for commands such as Freeze Panes, Sort, or a feature you use repeatedly but cannot easily reach from the ribbon. Its limitation is that a QAT key activates one toolbar command at a time.

Use a macro when you want to automate multiple steps or apply a repeatable procedure. For example, a macro could apply a chosen number format, set column widths, and add a header. Unlike a QAT command, it can change workbook contents, so verify the macro’s actions on a copy before relying on it. A recorded macro may also capture selections and layout assumptions that do not suit every worksheet.

If you only need to make a command easier to find, consider adding it to the ribbon or QAT rather than creating a macro. If you need a shortcut that works consistently across many workbooks, decide where the macro will be stored and how it will be shared before assigning the key. A shortcut is only useful if the command or macro is available in the workbook where you expect to use it.

Can you change built-in shortcuts?

Not through Excel’s standard Windows options. The QAT gives commands positional Alt-number access, and the macro dialog gives a shortcut to a macro; neither lets you freely edit Excel’s built-in shortcut map. Ribbon KeyTips, which appear after pressing Alt, also provide keyboard navigation, but they are generated from the ribbon layout rather than being a general remapping tool.

Windows utilities can remap keys or combinations at the operating-system level, and automation tools can send keystrokes or trigger actions. Those are separate from Excel and may change behavior in other applications, behave differently across keyboard layouts, or conflict with Excel. Use them only when Excel’s own options do not meet the need, and check the utility’s scope and settings carefully.

Windows, Mac and Excel for the web

The steps above are for desktop Excel on Windows. Excel for Mac has its own settings and keyboard conventions. Its ribbon and toolbar customization controls differ from the Windows File > Options path, and Windows Alt+1, Alt+2 QAT access should not be assumed to work the same way on a Mac. Shortcut combinations involving Control, Command and Option also vary by platform. Check the Mac version’s menus and the shortcut shown in its dialog rather than applying a Windows combination blindly.

Excel for the web does not provide the same desktop VBA macro workflow or macro-shortcut assignment. Some keyboard shortcuts work in the browser, but browser shortcuts can compete with spreadsheet shortcuts, and the available behavior may depend on the browser. If a task requires a VBA macro, use desktop Excel. If you need a command available in a shared online workbook, consider whether a standard ribbon or QAT command—or an Excel feature supported in the web app—can accomplish it instead.

Common problems and safe use

The Alt-number shortcut runs the wrong command: Check the QAT order. Moving a command changes the number associated with its position.
A macro shortcut does nothing: Confirm the workbook containing the macro is open, the macro name is available, and macros are permitted by the organization’s security settings.
A shortcut stops working in another workbook: The macro may be stored only in the first workbook rather than in the Personal Macro Workbook or another available location.
A familiar shortcut behaves differently: Review the macro’s assigned letter and whether another program or remapping tool is intercepting the keys.

Macros can modify data and are a security risk if they come from an untrusted source. Do not enable a macro simply to test an unfamiliar workbook. Follow your organization’s policy and use trusted files; security settings may be managed by an administrator. Since macro actions cannot be reversed with Ctrl+Z, save a separate copy before running a macro that changes data.

Frequently Asked Questions

Can I customize Ctrl+C or Ctrl+V in Excel?
No, Excel does not include a standard setting for remapping built-in shortcuts such as copy and paste. An external remapping tool may alter key behavior, but it operates outside Excel and could affect other applications.

How do I create a keyboard shortcut for a command?
Add the command to the Quick Access Toolbar and use its Alt-number position on Windows. If the command should perform a sequence of actions, create or record a macro and assign a shortcut in the macro’s Options dialog.

Can I assign Ctrl+Shift to a macro?
The macro shortcut box accepts a letter. Use a capital letter to assign Ctrl+Shift+that letter; a lowercase letter assigns Ctrl+that letter. Check for conflicts before using the shortcut.

Can I use a custom macro shortcut in every workbook?
Only if the macro is available in those workbooks. A macro saved in one workbook normally requires that workbook to be open. Storing it in the Personal Macro Workbook can make it available across workbooks on that computer.

Can I customize Excel shortcuts online?
Excel for the web does not offer the same VBA macro-shortcut workflow as desktop Excel. Use available web-app commands and shortcuts, or open the workbook in desktop Excel if the task depends on a VBA macro.

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.