Excel Keyboard Shortcuts: How to Change or Customize Them

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, you cannot use a built-in settings page to remap any keyboard shortcut to any command. You can, however, give frequently used commands quick access with the Quick Access Toolbar, assign shortcuts to macros, or—on a Mac—use macOS app shortcuts for menu commands.

What Excel lets you change

Excel has many built-in shortcuts, such as Ctrl+C to copy and Ctrl+Z to undo, but it does not include a general-purpose shortcut editor for replacing those combinations. For example, there is no Excel setting that changes Ctrl+P from Print to another command or makes Ctrl+Shift+S run a chosen feature. This distinction matters: adding a convenient way to launch a command is possible, but changing the behavior of every existing key combination is not a standard Excel customization.

There are three practical approaches, depending on what you want:

  • For a built-in command: add it to the Quick Access Toolbar and use its KeyTip.
  • For a repeated sequence of actions: record or write a macro and assign it a shortcut.
  • For a Mac menu command: create an app-specific shortcut in macOS, if the command appears in Excel’s menus.

Each approach has limits. A Quick Access Toolbar key launches a button; it does not replace another shortcut. A macro can automate actions, but its shortcut can collide with Excel’s own shortcuts. A macOS app shortcut applies to a menu item, not every Excel feature.

Use Quick Access Toolbar KeyTips

The Quick Access Toolbar (QAT) is a small row of commands, usually displayed above or below the ribbon. In Excel for Windows, its commands can be reached with Alt followed by a KeyTip. The number or letter shown depends on the toolbar’s current contents and order, so use the on-screen KeyTips rather than assuming a particular command always has the same key.

To add a command and use its KeyTip:

  1. Open File > Options > Quick Access Toolbar.
  2. In the command list, find the command you want. If it is not in the current list, use the “Choose commands from” menu to look in another category, such as All Commands.
  3. Select the command and choose Add. Use the controls on the right to change its position if needed, then select OK.
  4. Press Alt in the worksheet. Excel displays KeyTips. Press the one shown for the QAT command.

For example, if you add a command used for page setup, pressing Alt and then the KeyTip displayed beside that QAT button can be quicker than finding it in the ribbon. The exact KeyTip may change if you reorder the buttons or change the toolbar, so check the displayed prompt after customizing it. You can also add commands from the ribbon by right-clicking a command and choosing Add to Quick Access Toolbar.

This is often the safest choice for a built-in command because it does not take over a familiar shortcut such as Ctrl+C. It is less convenient if the command is buried far along the toolbar, and it does not let you assign a personally chosen two-key combination.

Assign a shortcut to a macro

A macro can run a series of actions, and Excel for Windows lets you assign a shortcut to a macro. This can approximate a custom shortcut for a task, but it is not the same as remapping an Excel command: the shortcut runs the macro, and the macro must contain the actions you want.

To assign a shortcut, first make or record a macro. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon by checking Developer. Then open Developer > Macros, select the macro, choose Options, and enter a letter in the shortcut-key box. A lowercase letter assigns Ctrl+letter; an uppercase letter assigns Ctrl+Shift+letter. The dialog shows the macro name and lets you choose its shortcut.

Think carefully before choosing the key. Assigning Ctrl+C, for example, can interfere with copying while the macro is available. Excel’s built-in shortcut behavior may be overridden by a macro assignment, so use a combination you do not rely on and test it in a copy of the workbook. A macro stored in the workbook is available when that workbook is open; for macros intended for broader use, users commonly store them in the Personal Macro Workbook. Save macro-enabled workbooks in a format that supports macros, such as .xlsm, and follow your organization’s macro security rules.

Macro shortcuts also have practical limits. They do not turn an arbitrary ribbon command into a native Excel shortcut, and a macro cannot be undone with Ctrl+Z in the way ordinary cell edits often can. A macro that changes data may make a change that is difficult to reverse. Keep a backup before running unfamiliar or consequential macros, and do not enable macros in files from untrusted sources.

Change shortcuts on a Mac

Excel for Mac does not use the Windows Alt-based QAT KeyTip system in the same way. Mac users can add or rearrange Quick Access Toolbar commands in Excel’s preferences, but the Windows instructions for pressing Alt and a displayed number are not a direct Mac equivalent. For many Excel commands, use the shortcut listed in the Mac version’s menus or Excel’s shortcut documentation; some combinations differ from Windows because macOS uses its own system shortcuts.

macOS also provides app-specific shortcuts for menu commands. In current macOS versions, open Apple menu > System Settings > Keyboard > Keyboard Shortcuts > App Shortcuts, select the plus button, choose Microsoft Excel as the application, enter the menu command’s name exactly as it appears, and specify a key combination. The shortcut is useful only if Excel exposes that command as a menu item and the chosen combination does not conflict with another shortcut. Menu wording must match, including punctuation where relevant. Older macOS releases use System Preferences rather than System Settings.

This operating-system feature changes access to a menu item; it does not create a general Excel shortcut editor. It may not work for commands that exist only as ribbon controls or for items whose menu names vary by context. If it fails, check the exact menu title, remove conflicting shortcuts, and try a combination that is not already assigned.

Excel for the web and shortcut differences

Excel for the web runs in a browser, so its keyboard behavior can be affected by the browser and operating system as well as by Excel. A shortcut that works in desktop Excel may instead be handled by the browser, may have a different effect, or may not be available. Use the web app’s Help or keyboard-shortcut reference for the current supported commands, and check whether the browser is intercepting the key combination.

The desktop macro instructions above are for Excel on Windows. Excel for the web can open a workbook that contains VBA, but it cannot create, run, or edit VBA macros. Office Scripts are a separate automation feature and should not be confused with VBA macro shortcut assignments. If a task depends on a VBA macro or its assigned key, use a supported desktop version of Excel rather than expecting the browser version to run it.

Choose the right workaround

The best option depends on whether you are trying to speed up one command or automate a whole task. A shortcut is only helpful if it is easy to remember and does not disrupt a key you already use. Consider these factors before changing your setup:

  • One built-in command: put it on the QAT and use its displayed KeyTip. This is straightforward and avoids assigning a macro.
  • A repeated workflow: consider a macro if the steps are consistent and you understand the file’s macro requirements.
  • A Mac menu item: try a macOS app shortcut, while checking for exact menu wording and conflicts.
  • A shortcut used by a team: favor a visible QAT button or documented workflow. A personal macro or system shortcut may not transfer to coworkers’ computers.
  • A browser-based workflow: use shortcuts supported by Excel for the web and account for browser conflicts; do not assume desktop customizations carry over.

If what you really want is to change a built-in key such as Ctrl+S everywhere, Excel’s built-in settings do not provide that general remapping feature. Third-party keyboard remapping tools may alter keys outside Excel or intercept them before Excel receives them, but they are separate software, can introduce conflicts, and may be restricted on managed computers. They are not a native Excel solution.

Common problems and how to fix them

If Alt does not show the expected KeyTips, confirm that Excel has focus and that the command is actually on the QAT. Press Alt again to see the current prompts; they can change with the interface and toolbar order. If a command is hard to find in the Options list, switch “Choose commands from” to All Commands, if available, and look for its displayed name.

If a macro shortcut does nothing, check that the workbook containing the macro is open, that the macro is enabled under your organization’s security policy, and that the assigned key was entered as intended. Also check whether the macro is stored in another workbook or the Personal Macro Workbook. If the key triggers an unexpected action, suspect a conflict with a built-in shortcut and assign a different combination. Do not troubleshoot by repeatedly running a macro that changes important data; make a copy first.

If an app shortcut on a Mac fails, verify that Microsoft Excel—not another application—is selected and that the menu command text matches Excel’s menu exactly. A shortcut may also be ignored if another macOS or Excel shortcut already uses it. Some menu commands are context-sensitive, so the same command may not be available in every worksheet or selection.

Frequently Asked Questions

Can I change Ctrl+C or Ctrl+V in Excel?
Excel does not have a built-in general shortcut editor for replacing these standard shortcuts. You may be able to intercept keys with external remapping software, but that is outside Excel and can affect other applications or create conflicts.

Can I assign a keyboard shortcut to a ribbon command?
Not directly through a general Excel shortcut-assignment screen. Add the command to the Quick Access Toolbar and use its displayed KeyTip, or create a macro that performs the task and assign a shortcut to that macro.

Can I use a macro shortcut in every workbook?
A macro stored in a particular workbook is generally available while that workbook is open. For use across workbooks, it can be stored in the Personal Macro Workbook, subject to macro security settings. Macro assignments can still conflict with built-in shortcuts.

Does Excel for Mac have the same shortcut options as Windows?
No. Windows uses Alt-based KeyTips for ribbon and QAT access, while Mac uses different keyboard conventions. macOS can assign shortcuts to Excel menu items through App Shortcuts, but that is not a universal remapping tool.

Can I customize shortcuts in Excel for the web?
Excel for the web supports its own keyboard commands, but it does not offer the Windows desktop macro shortcut workflow. Browser shortcuts can also interfere, so check the web app’s shortcut reference and use desktop Excel for VBA tasks.

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.