Yes, but Excel for Microsoft 365 on Windows does not offer a general setting for remapping every built-in keyboard shortcut. You can assign a shortcut to a macro, add commands to the Quick Access Toolbar or Ribbon, or use VBA for more specific key handling.
What Excel lets you customize
Excel has many fixed shortcuts, such as Ctrl+C for copy and Ctrl+Z for undo, and it does not provide a universal keyboard-shortcut editor for changing those commands. There is no standard Options screen where you can select any Excel action and replace its shortcut with a key combination of your choice.
There are several useful alternatives, but they do different things:
- Macro shortcut: run a macro with a keyboard combination. This is the simplest built-in way to create a shortcut for a repeated task.
- Quick Access Toolbar (QAT): put a command or macro on the toolbar, then reach it with a numbered Alt shortcut on Windows.
- Ribbon customization: add commands or macros to a custom tab or group. This makes them easier to find, but does not let you assign an arbitrary Ctrl combination.
- VBA Application.OnKey: make a key combination call a macro while the relevant VBA setup is active. This provides more flexibility, but requires macro-enabled files and careful handling of conflicts.
These options add ways to invoke a command; they do not necessarily change the underlying shortcut for Excel’s built-in command. For example, you can create a macro that performs a particular formatting task and give the macro a shortcut, but that is different from editing Excel’s native shortcut assignment for the Format Cells dialog.
Assign a keyboard shortcut to a macro
For a task that can be recorded or written as a macro, Excel’s Macro Options dialog is often the most straightforward solution on Windows. A macro can perform a sequence such as applying a chosen number format, setting a standard print layout, or cleaning up a selected range.
- Open the workbook that contains the macro, or create one by choosing View > Macros > Record Macro. You can also use the Developer tab’s Macros command.
- Open the macro list, select the macro, and choose Options.
- Enter a letter in the shortcut key field. In the Windows dialog, a lowercase letter assigns Ctrl+letter; an uppercase letter assigns Ctrl+Shift+letter.
- Choose OK, then close the dialog. Run the shortcut while the workbook containing the macro is open and macros are allowed to run.
The shortcut is associated with the macro rather than being a universal Excel preference. If the macro is stored in a regular workbook, the shortcut is generally available while that workbook is open. If you want macros available across workbooks, Excel for Windows users commonly store them in the Personal Macro Workbook, PERSONAL.XLSB, which opens in the background when Excel starts. This option requires saving the macro there and enabling macros as appropriate.
Be careful when choosing a key combination. A macro shortcut can take precedence over an existing Excel shortcut while the macro workbook is open. For instance, assigning a macro to Ctrl+C could interfere with copying. Prefer a combination you do not rely on, and test it in a copy of the workbook before using it in important work.
Use the Quick Access Toolbar for frequent commands
The QAT is a small, customizable toolbar that can hold commands you use often, even if they are not prominent on the current Ribbon tab. On Windows, open File > Options > Quick Access Toolbar. Choose commands from the available list, add them to the toolbar, and use the ordering controls to put the most important items first. You can also add a macro to the QAT.
On Windows, pressing and releasing Alt displays key tips for Ribbon and QAT items. The first QAT items can usually be called with Alt+1, Alt+2, and so on, following their order on the toolbar. That makes this a practical alternative when you want quick access to a command but do not want to assign a macro shortcut. The exact key-tip sequence is visible on screen after you press Alt, so use that prompt rather than assuming a command’s number.
Adding a built-in command to the QAT does not change its original shortcut, and it does not create a new Ctrl combination. It gives you another route to that command. This is often a safer choice for commands you want at hand without replacing a shortcut you already use.
Customize the Ribbon without remapping keys
To organize commands, go to File > Options > Customize Ribbon on Windows. You can create a custom tab or group and add available commands or macros. Customizing the Ribbon can make a personal workflow easier to navigate, especially when several related commands are scattered across different tabs.
Ribbon key tips are not the same as arbitrary shortcut assignments. Pressing Alt reveals letters or sequences for navigating the Ribbon, and those can change with the interface, customization, or Office version. You cannot use the Customize Ribbon page to declare that an unrelated combination such as Ctrl+Shift+J should invoke any built-in Excel command. For that kind of behavior, use a macro shortcut or VBA where suitable.
Use VBA Application.OnKey for more control
VBA includes the Application.OnKey method, which can tell Excel to run a procedure when a specified key combination is pressed. In its key notation, a caret represents Ctrl, a plus sign represents Shift, and a percent sign represents Alt. A VBA developer can use this approach when the Macro Options dialog is too limited, or when a key assignment needs to be set up programmatically.
Unlike a simple macro shortcut assignment, an OnKey assignment is typically established by running VBA code, often when a workbook opens. The workbook containing the setup code must be available and macros must be enabled. The assignment affects Excel while it is active and should be deliberately removed or reset when it is no longer needed; otherwise, users may not understand why a key behaves differently. It can also conflict with Excel’s own shortcuts or with shortcuts expected by other applications.
OnKey is a VBA feature, not a settings dialog for remapping Excel. It is most appropriate when someone is comfortable maintaining macro-enabled workbooks and checking how the assignment behaves in the intended Excel environment. Save a separate copy before experimenting with macro code. Macros cannot be undone with Ctrl+Z, and a faulty key handler can make normal work confusing even if the workbook data itself is unchanged.
How to choose the right method
Start with the goal, not with the key combination. If you want to repeat several steps with one action, a macro shortcut may be the best fit. If you want one existing command close at hand, the QAT is simpler. If a team needs a visible, organized collection of tools, a custom Ribbon tab may be easier for other people to understand. Reserve OnKey for cases that justify maintaining VBA.
- Choose a macro shortcut for a repeatable action that Excel can perform through a recorded or written macro.
- Choose the QAT for a built-in command or macro you want to access quickly without taking over a familiar shortcut.
- Choose Ribbon customization when discoverability and grouping matter more than a one-keystroke launch.
- Choose OnKey when you need programmable key handling and can manage workbook events, macro security, and conflicts.
Think about portability too. A custom setup saved in a workbook may not follow you to another workbook or another computer unless the workbook, macro, or relevant Excel customization is transferred. For colleagues, document any nonstandard shortcut and ensure they have a trusted, compatible copy of the macro. A key that is convenient for one person can be a surprise to someone who expects Excel’s normal behavior.
Common problems and conflicts
If a macro shortcut does nothing, check that the workbook containing the macro is open, the macro name is available, and Excel has permitted the macro to run. A file downloaded from the internet or received by email may be subject to security restrictions. Do not enable macros in an unfamiliar file merely to make a shortcut work; only use macro-enabled workbooks from sources you trust.
If a shortcut runs the wrong action, check for a conflict with an existing Excel shortcut and whether the macro shortcut uses Ctrl or Ctrl+Shift as intended. Remember that capitalization in the Windows Macro Options field matters: entering an uppercase letter requests the Shift version. Also check whether a QAT item has moved, since its Alt+number sequence depends on its position.
Keyboard layouts and other software can affect what a combination means. Laptop function keys may require the Fn key, and Windows utilities or add-ins may intercept shortcuts before Excel handles them. If a combination works on one computer but not another, test it with add-ins or other key-mapping utilities in mind, rather than assuming the workbook is corrupt.
Windows, Mac, and Excel for the web
The main steps above describe Excel for Microsoft 365 on Windows. Excel for Mac has its own Ribbon and toolbar customization controls; depending on the release, look under Excel > Settings or Excel > Preferences for Ribbon & Toolbar. Macro support and keyboard conventions differ by platform, and the shortcut shown in the Mac macro interface may use different modifier keys. Follow the modifier displayed in that version rather than copying a Windows Ctrl combination without checking.
Excel for the web does not run VBA macros, so macro shortcuts and Application.OnKey are not a practical web-based remapping solution. Browser shortcuts may also take priority over a key combination before Excel for the web receives it. Web Excel supports many standard spreadsheet shortcuts, but its customization options are not equivalent to the Windows desktop Macro Options dialog. If a workflow depends on VBA, use a supported desktop version of Excel.
Frequently Asked Questions
Can I change Ctrl+C or Ctrl+Z in Excel?
Excel does not provide a general built-in setting for replacing native shortcuts such as copy or undo. You may be able to intercept a key with VBA, but doing so can disrupt expected behavior and is not the same as safely editing Excel’s shortcut map.
Can I assign a shortcut to a macro in Excel?
Yes. On Windows, select the macro in the Macros dialog, choose Options, and enter a letter. Lowercase assigns Ctrl+letter and uppercase assigns Ctrl+Shift+letter. The macro must be available and permitted to run.
Can I make my macro shortcut work in every workbook?
Store the macro in a location that is available across workbooks, such as PERSONAL.XLSB on Windows, and make sure that workbook loads and macros are enabled. A shortcut linked to a macro in an ordinary workbook is not a universal Excel setting.
Can I assign a keyboard shortcut to a built-in command?
Not through a general-purpose shortcut editor in Excel for Windows. You can add many commands to the QAT or Ribbon, or create a macro that performs a task, but those methods do not directly rewrite the built-in shortcut mapping.
Do Excel keyboard shortcuts work the same on Mac and in a browser?
No. Mac modifier keys and customization controls differ from Windows, while Excel for the web is also subject to browser shortcuts and does not run VBA. Check the shortcut list and options for the exact platform and version you use.
Related
- Actual vs Forecast in Excel: Compare Results
- Add a Custom Number Format in Excel: Steps & Examples
- Accounting Number Format Excel Shortcut?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Box Plot With Data Points: How to Show Every ValueYes. In Excel for Microsoft 365 on Windows, select the box-and-whisker chart, open Format Data Series, and under…
- Change Outlook Tasks Date Format in Grid ViewIn classic Outlook for Microsoft 365 on Windows, change a task grid’s date display through View > View…
- Compare Two Excel Sheets: Find Differences Step by StepTo compare two Excel sheets, use a cell-by-cell formula when corresponding cells line up, or match records by…
- Why Can’t I Insert a Signature Line in Word?You usually can’t insert a signature line because you’re using Word for the web or a mobile app,…
- Excel Split Cell in Half Horizontally: Real OptionsNo, Excel cannot split one cell into two independent cells with a horizontal boundary; every cell belongs to…
- Change Date Format in Excel: General Format ExplainedTo change dates showing as numbers in Excel, select the cells and choose Home > Number Format >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.