How to Change Excel Shortcut Keys in Microsoft 365

To change an Excel shortcut on Windows, assign a shortcut to a macro in Developer > Macros > Options, or add a command to the Quick Access Toolbar and use its Alt-number key. Excel does not include a general setting for remapping every built-in shortcut, such as Ctrl+C. The right method depends on whether you want to run a macro, reach a ribbon command faster, or remap keys across Windows.

The steps below are for Excel for Microsoft 365 on Windows. Save your work before changing macros or using a keyboard-remapping tool. If you use Excel for Mac or Excel for the web, check the differences noted below; not all desktop options are available in those versions.

What You’ll Need

Excel for Microsoft 365 on Windows for the macro and Quick Access Toolbar steps.
A macro you can safely run if you want a shortcut for a custom action. You can use an existing macro or create one; you do not need VBA knowledge to record a basic macro.
Permission to save a macro-enabled workbook, or access to your Personal Macro Workbook, if the shortcut should run a macro.
For a shortcut that remaps an ordinary key combination rather than launching a macro, an approved Windows keyboard-remapping utility. This is optional and affects keyboard behavior outside Excel unless you configure it carefully.

Step-by-Step

Decide what you want the shortcut to do. Use a macro shortcut for a repeatable sequence of actions, such as applying a standard format or preparing a report. Use the Quick Access Toolbar (QAT) for an existing Excel command you want to reach with fewer clicks. If your goal is to replace a built-in combination such as Ctrl+F, Excel has no general-purpose shortcut editor for that command; consider a Windows remapper only if you understand its wider effects. Choosing the method first prevents you from creating a macro when you only need a ribbon command.
Show the Developer tab if it is missing. In Excel for Windows, select File > Options > Customize Ribbon. In the Main Tabs list, check Developer, then select OK. The Developer tab contains the macro controls used in the next steps. If the tab is already visible, leave your ribbon settings as they are. On a work-managed computer, an administrator may restrict macros or ribbon changes, so you might need approval before proceeding.
Create or identify the macro you want to run. To record a straightforward action, select Developer > Record Macro, enter a name without spaces, and choose where to store it. Choose This Workbook if the macro is only for that file; choose Personal Macro Workbook if it should be available when you use Excel on this computer. Perform the actions to record, then select Developer > Stop Recording. If you already have a macro, skip recording and use that macro instead. A recorded macro captures steps, not your intention, so check that it behaves correctly before assigning a shortcut.
Assign a keyboard combination to the macro. Select Developer > Macros. In the list, select the macro and choose Options. Enter a letter in the Shortcut key box, then select OK and close the Macros dialog. In Windows Excel, a lowercase letter creates a Ctrl+letter shortcut; an uppercase letter creates Ctrl+Shift+letter. For example, entering an uppercase R assigns Ctrl+Shift+R. Prefer a combination that is not already used for a familiar Excel command. If the dialog does not show Options, confirm that you selected a macro and that macros are available in your Excel setup.
Choose where the macro is stored and save appropriately. A macro stored in This Workbook is available only while that workbook is open. Save a workbook containing VBA as an Excel Macro-Enabled Workbook (.xlsm); saving it as a standard .xlsx file removes the macro. A macro stored in Personal Macro Workbook is generally available in Excel on that computer, but it does not automatically travel with the workbook to another computer. If you share a file, tell recipients what the macro does and provide it through an appropriate trusted channel. Excel may block macros from files downloaded from the internet or restrict them through organizational policy.
Add a frequently used command to the Quick Access Toolbar instead. Select File > Options > Quick Access Toolbar. In the Choose commands from list, select a category, choose the command, and select Add. Use the up and down controls to place it where you want, then select OK. Excel assigns the QAT buttons position-based KeyTips. Press and release Alt to display the available KeyTips; on many Windows installations, the first QAT buttons are reached with Alt+1, Alt+2, and so on. Check the labels displayed on your own screen rather than assuming a position, especially if you have customized the ribbon or QAT. Reordering the buttons can change which Alt-number reaches a command.
Test the shortcut in a safe context. Save the workbook, then run the assigned macro on a copy or on harmless sample data. Confirm that it performs the intended actions and does not change unrelated cells, sheets, or files. For a QAT command, press Alt and follow the displayed KeyTip to verify that the intended command runs. If you assigned a combination that conflicts with a built-in shortcut, test the familiar command too. Remove or change the assignment if it causes confusion. Close and reopen Excel to check whether the macro is available in the way you expect.
Use a remapper only for shortcuts Excel cannot assign. A Windows utility such as Microsoft PowerToys Keyboard Manager can remap keys or key combinations at the operating-system level. Configure an Excel-specific target if the version and feature you are using support it, and test the mapping in a noncritical workbook. A remap may affect other applications if it is not limited to Excel, and it may not work in every secure, elevated, or remote desktop session. Do not use a remapper to imitate a shortcut that performs a critical action unless you have tested how conflicts and undo behavior work.

On Mac: Excel for Mac has different menus and keyboard conventions. Look for the macro list and its Options control in the Developer tab or the Macros command, then follow the modifier keys shown in the dialog; do not assume Windows Ctrl combinations behave the same on a Mac. Excel for the web does not run VBA macros, so macro keyboard assignments made in desktop Excel will not provide that functionality in the browser. The Windows File > Options paths above also do not apply to Mac.

Common Mistakes

Expecting to edit every Excel shortcut in Options. Excel does not offer a universal interface for changing the key combination of each built-in command. Macro assignments and QAT KeyTips are workarounds for different needs, not a complete shortcut editor.
Overwriting a shortcut you already rely on. A macro shortcut can take precedence over a built-in Excel shortcut while the macro is available. Avoid common combinations such as Ctrl+C, Ctrl+V, Ctrl+S, or Ctrl+Z. A shortcut that is technically assignable may still be a poor choice if it disrupts daily work.
Saving a macro workbook in the wrong format. The .xlsx format does not preserve VBA. Save a workbook with macros as .xlsm, and keep a clean copy before changing or testing macros.
Assuming a macro follows the workbook everywhere. A shortcut assigned to a macro in one workbook only works when that macro is available. A macro in Personal Macro Workbook is local to that Excel installation unless you deliberately move or deploy it.
Confusing QAT KeyTips with a custom key assignment. The Alt-number sequence depends on the command’s position and the KeyTips Excel displays. It is not a permanent, freely chosen key combination for that command.
Using a remapper without checking its scope. A system-level change can affect other apps, remote sessions, or accessibility shortcuts. Make sure you know how to disable or reverse the mapping before relying on it.

Tips

Use Ctrl+Shift+letter for a macro when you want to reduce the chance of colliding with common Ctrl+letter shortcuts. Still check for conflicts before settling on a combination.
Give macros clear names and descriptions. When you revisit the Macro Options dialog, a useful name makes it easier to identify what a shortcut will run.
Keep macros short and focused. A single shortcut that does one predictable task is easier to understand and troubleshoot than a long recorded sequence with hidden assumptions about the active sheet.
For a command that already exists in Excel, try adding it to the QAT before installing a remapping tool. It is easy to remove, and its displayed KeyTips help you see the current access sequence.
When setting up a shared workbook, explain whether the macro is stored in the file or in your Personal Macro Workbook. The latter is not included when you send the workbook.
On Excel for the web, use the available ribbon and browser features rather than expecting desktop VBA shortcuts to work. For a repeatable automation task, check whether an approved cloud-based automation option is available in your Microsoft 365 organization.

Troubleshooting

The shortcut does nothing: Confirm that the macro is stored in the open workbook or in Personal Macro Workbook, and check that macros are enabled under your organization’s security rules. Reopen the Macros dialog and verify the assigned letter. Also make sure you are pressing the correct modifiers; an uppercase letter in the Windows assignment means Ctrl+Shift+letter.

The shortcut runs the wrong action: Check for a conflict with an Excel shortcut or another macro. Return to Developer > Macros > select the macro > Options, then choose a less-conflicting letter or clear the assignment if the dialog permits. Test the replacement before using it on important data.

The macro disappeared after saving: Check whether the workbook was saved as .xlsx. If so, the VBA may have been removed; use a backed-up .xlsm copy if available. For future saves, select Excel Macro-Enabled Workbook (*.xlsm) in the Save As file type list.

The QAT command is not reached with the expected number: Press Alt and read the KeyTips shown on screen. The command may be in a different position than expected, or the QAT may have changed. Reorder its buttons in File > Options > Quick Access Toolbar, select OK, and check the displayed KeyTips again.

A remapping behaves differently in another app: Disable the mapping in the remapper and review its target-application settings. If Excel is running with different permissions, or through remote desktop, the remapper may not apply consistently. Avoid adding more mappings until you have isolated the cause.

Frequently Asked Questions

Can I change Ctrl+C or another built-in Excel shortcut?

Not through a general Excel shortcut-customization setting. You can assign a shortcut to a macro or use a Windows remapper, but a remapper can affect other apps and may interfere with expected behavior. It is usually safer to leave common shortcuts unchanged.

Can I assign a shortcut to any Excel command?

Not directly through Excel’s macro shortcut dialog; that dialog assigns a key combination to a macro. For an existing command, add it to the Quick Access Toolbar and use the KeyTip Excel displays, or consider a carefully scoped Windows remapper.

Will a macro shortcut work in every workbook?

Only if the macro it calls is available. A macro saved in a particular workbook requires that workbook to be open. A macro in Personal Macro Workbook can be available across workbooks on that computer, but is not automatically shared with other people or devices.

Can I use a macro shortcut in Excel for the web?

No. Excel for the web does not run VBA macros, so a desktop macro shortcut will not run there. Open the workbook in desktop Excel for Windows or Mac to use its VBA macro features, subject to macro security settings.

How do I remove or change a macro shortcut?

In desktop Excel, open Developer > Macros, select the macro, and choose Options. Change the shortcut letter or clear the shortcut entry, if available, then select OK. If the shortcut comes from a remapping utility instead, remove it in that utility; changing the macro settings will not remove an operating-system remap.

Does Excel for Mac use the same shortcut keys as Windows?

No. Some shortcuts and modifier keys differ between platforms, and Mac keyboard settings can affect them. Use the shortcut information shown in Excel for Mac and the macro Options dialog on that installation; do not assume a Windows Ctrl-based assignment will transfer unchanged.

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.