XLEV8 EXCEL PRODUCT MANUAL

 

BULK EDIT SEARCH SHORTCUTS

Details

What it does
Uses a settings sheet (Bulk_Edit_Search_Shortcuts) to allow you to edit the list of keyboard shortcuts that can be found with the Search Shortcuts macro.

When to use it
When you want to update the list of searchable keyboard shortcuts for custom shortcuts, Alt-string shortcuts, or less common shortcuts.

Why to use it
It’s an easy way to update the list of searchable shortcuts for new shortcuts, edit the descriptions, or remove shortcuts you don’t want to appear on the list.

Default shortcut
None

Other Details

  • Category: Productivity / Other
  • Difficulty: 3/5
  • Usage/frequency: 2/5
  • Automation factor: 5/5 (estimated 300 seconds saved each time used)
  • Type: Bulk
  • Date added: 7/7/2026
  • Tags: shortcuts, bulk
Related Macros and Articles

Related Macros
Search Shortcuts

Other Articles
None

Example Files

None

 

Instructions

Prerequisites
None

Instructions
The first time you run the Bulk Edit Search Shortcuts macro, it will create a sheet called Bulk_Edit_Search_Shortcuts.  This is where you’ll add, update, or delete keyboard shortcuts that you want to have populate the Search Shortcuts box.  After filling in the values, run the Bulk Edit Search Shortcuts macro again to process the contents.  These are the fields in the Bulk_Edit_Search_Shortcuts sheet that you’ll want to fill in:

  • Column A – Shortcut Keys (required): enter the shortcut keys that should be pressed to perform the action.  For combo shortcuts (keys pressed together such as Ctrl+b to bold), use the + (plus) symbol to combine the keys.  For string shortcuts (keys pressed in a sequence, such as Alt-h-v-f to paste formulas), use the – (dash) symbol to combine the keys.  Note – make sure to use the exact key to press, not the resulting symbol. For example, Ctrl+Shift+; inserts the current time – don’t insert Ctrl+Shift+:.
  • Column B – Send Keys (required) – enter the key codes that are processed when running a shortcut from the search box. There are specific characters that map to many keys. For example, Ctrl is represented by the ^ (carat) symbol, so the shortcut for bold formatting (Ctrl+b) would be represented by ^b in this column.  For a full reference on characters that should be used as Send Keys, see the Send Keys Microsoft support page.
  • Column C – Category (required) – select a category for the shortcut from the drop-down list.
  • Column D – Action (required) – enter a brief description of what action the keyboard shortcut performs.  Because this is included with the text used in the search box, feel free to use synonyms that help you search for and run the shortcut.
  • Column E – Search String (informational) -this is the text string that will be displayed in the search box. It is based on a formula referring to the shortcut keys, category, and action.
Screenshots

Screenshot of Bulk Edit Search Shortcuts macro.

Video
None

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Don't miss great tips, tricks, news, and events!

  • Get our 105 Excel Tips e-book free!
  • Get monthly insights and news
  • Valuable time-saving best practices
  • Unlock exclusive resources

Almost there! We just need to confirm the email address is yours. Please check your email for a confirmation message.