How to Customize Excel Keyboard Shortcuts with VBA or Add-ins in WPS Office
Question details
The user needs to assign custom keyboard shortcuts in Excel or WPS Spreadsheets because there is no general built-in shortcut customization interface. The workaround is to use VBA macros, add-ins, or Ribbon customization.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user wants to create or modify keyboard shortcuts for frequent spreadsheet tasks by using VBA macros, add-ins, or Ribbon customization.
- Observed behavior
- Excel and WPS Spreadsheets do not expose a general keyboard-shortcut customization screen, so shortcuts are implemented through the Macro Options dialog or add-ins and may replace built-in assignments.
Before assigning shortcuts, open WPS Spreadsheets and make sure the Developer tab is available or that you know the Alt+F8 macro shortcut. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) so your VBA macro assignment is not lost.
Assign a Ctrl Shortcut to a VBA Macro in WPS Spreadsheets
Use this solution when you only need a simple Ctrl-based shortcut and already have a macro stored in the workbook.
This approach uses the Macro dialog to bind a shortcut key to an existing macro. It is the fastest method for basic shortcuts, but the assigned key combination can override an existing Excel or WPS shortcut.
Press Alt+F8 in WPS Spreadsheets to open the Macro dialog box.
Select your macro from the list, then click the Options button.
Click the Shortcut key box, type a letter such as E, and confirm. The shortcut becomes Ctrl+E or Ctrl+Shift+E depending on the key combination you enter.
Save the file in .xlsm format so the macro and shortcut remain available next time.
Create Advanced Shortcuts with an Add-in or Ribbon Customization
Use this solution when you need more than a simple Ctrl shortcut, such as multi-key sequences or custom Ribbon buttons shared across workbooks.
Customize Spreadsheet Keyboard Shortcuts in WPS Office Using VBA Macros
Use the Macro dialog in WPS Spreadsheets to assign a shortcut to your VBA macro, save the workbook in .xlsm format, and test the shortcut. For advanced bindings, install a trusted add-in from the Add-ins options.
- 1. Open your macro-enabled workbook: Launch WPS Spreadsheets and open the .xlsx or .xlsm workbook that contains your VBA macro.
- 2. Open the Macro dialog: Press Alt+F8 to open the Macro dialog, select the macro, and click Options.
- 3. Assign the shortcut key: In the Shortcut key field, type a letter to create a Ctrl-based shortcut, then click OK.
- 4. Save as a macro-enabled workbook: Go to File > Save As, set the file type to Excel Macro-Enabled Workbook (*.xlsm), and save.
- 5. Test the shortcut: Return to the worksheet and press your assigned shortcut to confirm it runs the macro.
Frequently Asked Questions
Can I customize Excel keyboard shortcuts from Excel Options?
No, Excel does not provide a general built-in interface for assigning custom keyboard shortcuts like Word does. You can use the Macro dialog Options button to assign a Ctrl shortcut, or use an add-in for advanced shortcuts.
Will assigning a macro shortcut override existing Excel shortcuts?
Yes, a Ctrl-based macro shortcut can override an existing Excel or WPS Spreadsheets shortcut. Choose a key combination that you do not already use for a standard task.
Does WPS Spreadsheets support VBA macros and .xlsm files?
WPS Spreadsheets supports VBA macros and Excel .xlsm macro-enabled workbooks on compatible versions. Macro availability may depend on your WPS Office version and security settings.
How do I enable macros safely?
Open File > Options in WPS Spreadsheets, go to Macro Settings or Trust Center, and enable macros only from trusted sources. Avoid enabling all macros unless you are certain the file is safe.
Can I use add-ins to create shortcuts that are not Ctrl-based?
Yes, add-ins can register additional key combinations or custom Ribbon commands. Only install add-ins from trusted sources because they can run code that affects your files.
