Excel Keyboard Shortcuts: Settings and Customization

Excel for Microsoft 365 on Windows does not provide one settings page where you can remap every built-in keyboard shortcut. You can, however, assign shortcuts to macros, customize the Quick Access Toolbar for fast keyboard access, and use Ribbon Key Tips; the right option depends on what you want to do.

What Excel keyboard shortcut settings control

A keyboard shortcut is a key or key combination that runs a command, such as Ctrl+C for Copy or Ctrl+S for Save. Excel includes many shortcuts, but its Windows Options dialog does not offer a general editor for changing the keys assigned to built-in commands. For example, you cannot use a standard Excel setting to change Ctrl+C to a different combination.

That distinction matters when searching for a “keyboard shortcuts” setting. Excel does have customizable settings for the Quick Access Toolbar and Ribbon, and it supports shortcut keys for macros. Those features can make frequently used tasks quicker, but they are not the same as remapping every Excel command.

Also, a shortcut may be handled by Windows, another running program, or a browser before Excel receives it. Excel’s behavior can therefore depend on the app, operating system, and workbook context, not just on a setting inside the spreadsheet.

Built-in shortcuts and Ribbon Key Tips

Built-in shortcuts are the combinations Microsoft assigns to common commands. Examples include Ctrl+Z to undo, Ctrl+F to find, and Ctrl+Arrow key to move to the edge of a data region. These are ready to use and do not need to be enabled in Options. Some combinations behave differently when a cell is being edited, a dialog is open, or a particular add-in is active.

For commands without a shortcut you remember, Excel’s Ribbon Key Tips offer a keyboard-driven route. Press Alt to display letters or numbers over Ribbon tabs and commands, then press the displayed keys in sequence. For instance, pressing Alt and following the on-screen Key Tips can lead to a command without using the mouse. The exact letters can vary with the Excel version, window layout, and display language, so follow the labels shown on your screen rather than relying on a memorized sequence.

Key Tips do not change a command’s shortcut. They are a way to navigate the Ribbon by keyboard, and can be useful when you want to discover or operate a command that has no obvious standalone key combination.

Customize the Quick Access Toolbar

The Quick Access Toolbar (QAT) is a small toolbar for commands you use often, such as Save or Undo. On Windows, customize it through File > Options > Quick Access Toolbar. Select a command from the available list, choose Add, and use the ordering controls to position it. You can also right-click a Ribbon command and choose Add to Quick Access Toolbar. The toolbar can appear above or below the Ribbon.

Once a command is on the QAT, press Alt to display Key Tips. The key tip for a QAT item depends on its position and the labels Excel displays. The first items commonly have short number-based access keys, but it is safest to press Alt and read the current on-screen labels, especially if you have rearranged the toolbar. This gives keyboard access to selected commands without changing Excel’s built-in shortcut assignments.

For example, if you regularly insert a particular command from the Ribbon, adding it to the QAT can reduce the number of navigation steps. It does not create a new Ctrl-plus-letter shortcut, and it does not make the command available in every Excel environment. QAT customization is a practical choice for commands you use repeatedly but cannot easily remap.

In Excel for Mac, the interface and available customization controls differ from Windows. Look for Quick Access Toolbar options in Excel’s preferences or customization interface for your installed version. The Windows path File > Options does not apply on Mac.

Assign a shortcut to a macro

If you want a custom key combination to run a repeatable action, assigning a shortcut to a macro is Excel’s built-in workaround. On Windows, open the workbook containing the macro and press Alt+F8. Select the macro, choose Options, enter a letter in the Shortcut key box, and confirm. Excel assigns a Ctrl+letter shortcut; using an uppercase letter in the box adds Shift to the combination.

Choose carefully: a macro shortcut can take precedence over a built-in shortcut while the macro is available. For example, assigning Ctrl+S is a poor choice because it can interfere with Save. Prefer a combination you do not rely on, and document it for anyone else who uses the workbook. The shortcut is associated with the macro and is useful when the workbook containing it is open; it is not a universal setting for all Excel files.

Macros require a workbook format that supports VBA, such as .xlsm, and Excel’s macro security settings must allow the macro to run. A macro can also be stored in the Personal Macro Workbook so it is available across workbooks on that computer, but that requires setting up and maintaining the personal workbook. Macro shortcuts are not a way to alter Excel’s built-in commands globally.

On a Mac, the Macro dialog and shortcut-key behavior may differ from Windows, and the same key combination may be used by macOS. Check the controls in the installed Excel version before relying on a shortcut. Excel for the web does not support creating, editing, or running VBA macros, so this approach requires the desktop app.

Using VBA to respond to a key

For more advanced automation, VBA includes the Application.OnKey method, which can direct a key combination to a macro in the current Excel session. This is different from changing a permanent Excel preference: the assignment must be set up by code, and it can stop applying when Excel closes or when the assignment is reset. It can also make a familiar key behave unexpectedly, so a workbook that uses this method should explain what it changes and when.

VBA-based key handling is intended for desktop Excel and depends on macros being enabled. It is not supported in Excel for the web. It is also more involved than adding a command to the QAT or using a macro’s Shortcut key option. If you only need to launch one simple macro, use the Macro dialog instead of building a custom key-handling system.

Before using any macro or VBA project, keep a separate copy of the workbook. Macro actions cannot be undone with Ctrl+Z, and a mistaken automation can alter data quickly. Use trusted code and understand what it does before enabling it.

Windows, Mac, and Excel for the web

Shortcut behavior is not identical across platforms. Many Windows shortcuts use Ctrl, while Mac Excel commonly uses Command for equivalent actions; some combinations use Control or Option instead. A Windows shortcut copied from a help page may therefore not work as written on a Mac. Microsoft’s shortcut references are organized by platform, so choose the Windows, Mac, or web list that matches the app you are using.

Excel for the web runs inside a browser, where some key combinations can belong to the browser or operating system. Its available commands and shortcut support are not a complete match for desktop Excel. It can work with workbooks containing macros, but it cannot run the VBA code. If a shortcut is essential to a workflow, check it in the actual version and platform where the workbook will be used.

Settings also do not necessarily travel with a workbook. The QAT is an application customization, while macro code and its assigned shortcut are associated with a macro-enabled workbook or a personal macro workbook. A colleague opening the same file may not have your QAT arrangement or local settings.

When a shortcut does not work

Before changing settings, identify whether the shortcut is built in, a QAT Key Tip, or a macro shortcut. Then check the context in which you pressed it. A command may behave differently while editing a cell, when a chart or dialog has focus, or when a worksheet is protected. If you are using a laptop, the function-key row may require the Fn key, depending on the computer’s keyboard settings.

Press Alt and check the current Key Tips if you are trying to reach a QAT or Ribbon command.
Confirm that the workbook containing the macro is open and that macros are permitted if a macro shortcut does nothing.
Check whether another application, a browser, or the operating system is capturing the key combination.
Test the shortcut in a blank workbook or another context to see whether the issue is specific to one sheet, dialog, or add-in.
Consider whether a macro shortcut has replaced a familiar built-in combination; change or remove the macro assignment if it causes a conflict.

If a built-in shortcut appears to have changed, Excel may not be the cause. An add-in, keyboard utility, remote desktop session, or platform-specific key mapping can intercept input. Close or disable likely sources one at a time, if appropriate, and retest. Avoid assuming that reinstalling Office is necessary before checking the simpler causes.

Choosing the right customization

Use the least complicated option that solves the problem. For a built-in command you need to reach more easily, add it to the QAT or use Key Tips. For a repeated sequence of actions, record or create a macro and assign it a shortcut. For advanced session-specific behavior, VBA’s OnKey method may be appropriate, but it requires more care and documentation.

Need keyboard access to a Ribbon command? Use Alt and the displayed Key Tips, or add the command to the QAT.
Need a custom key to run automation? Assign a shortcut to a macro, avoiding combinations used for essential built-in commands.
Need to change a built-in shortcut for every workbook? Excel does not provide a general built-in remapping screen for that purpose.

This distinction helps avoid a common misconception: customizing the Ribbon or QAT does not rewrite Excel’s keyboard shortcuts. It provides another route to commands, while macro shortcuts launch automation.

Frequently Asked Questions

Can I change Ctrl+C or another built-in Excel shortcut?
Not through a general keyboard-shortcut settings page in Excel for Windows. You can use the QAT or Ribbon Key Tips to access commands, but those options do not remap the built-in combination.

How do I create a keyboard shortcut for a macro?
In desktop Excel for Windows, press Alt+F8, select the macro, choose Options, and enter a letter in Shortcut key. Excel uses Ctrl with that letter, or Ctrl+Shift if you enter an uppercase letter. Save the macro in a VBA-capable workbook and enable macros when needed.

Can I customize Excel shortcuts in the web version?
Excel for the web has browser- and web-app-specific shortcut behavior, but it does not provide the desktop VBA macro workflow or a general remapping control for built-in shortcuts. Browser and operating-system shortcuts may also take priority.

Why does my shortcut work on Windows but not on a Mac?
Excel’s platform shortcuts differ, and macOS may reserve some combinations. Check the Mac-specific shortcut reference and the installed app’s controls rather than assuming a Windows Ctrl combination has a direct Mac equivalent.

Will my Quick Access Toolbar settings appear on another computer?
Do not assume so. QAT customization is an application-level setting, not a command stored as part of an ordinary workbook. A macro shortcut and its code have different workbook-related requirements, and another user may need to configure their own interface.

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.