Manage My Tools & Shortcuts...

Choose from all the tools in ASAP Utilities and keep your favorites within easy reach.

Add the tools you use most often to My Tools & Shortcuts for quick access from the ASAP Utilities tab in Excel.
You can also assign keyboard shortcuts to these tools, so you can run frequently used commands even faster.

To help you get started, the menu includes these tools and keyboard shortcuts by default:

• Control+Alt+A: Select Adjacent Matching Cells in the Column
• Control+Alt+B: Reload Installed Excel Add-ins (Refresh Menus and Commands)
• Control+Alt+C: Color Every nth Row or Column in Selection...
• Control+Alt+D: Deselect Cells...
• Control+Alt+E: Set Temporary Default File Location to Current Folder
• Control+Alt+F: List File Names and Properties from Folder...
• Control+Alt+G: Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
• Control+Alt+H: Advanced Find and Replace...
• Control+Alt+I: Apply Calculation to Selected Cells...
• Control+Alt+J: Start the Last Used Tool Again...
• Control+Alt+Shift+→: Extend Selection to the Rightmost Used Column
• Control+Alt+Shift+↓: Extend Selection to the Lowest Used Row
• Control+Alt+L: Switch Back to Previous Sheet
• Control+Alt+M: Move, Extend, or Shrink Range Selections...
• Control+Alt+N: Quickly Insert a Named Worksheet...
• Control+Alt+O: Advanced Criteria-Based Cell Selection...
• Control+Alt+P: Convert Formulas in Selection to Static Values
• Control+Alt+Q: Auto Numbering and Labeling of Selected Cells...
• Control+Alt+R: Reset Last Cell to Fix Control+End Behavior...
• Control+Alt+S: Save File and Create Backup Copy with Timestamp...
• Control+Shift+I: Display & Navigation...
• Control+Alt+X: Cut and Paste as Values (Keeping Dependents Unchanged)...
• Control+Alt+Y: Paste Special with Combined Options...
• Control+Shift+D: Insert Current Date and Time with Seconds
• Control+Shift+T: Insert Current Time with Seconds
• Control+Alt+T: Insert Date Using a Calendar Popup...
• Control+Alt+Shift+C: Clean Up Data and Formatting...
• Control+Alt+Shift+D: Count Duplicate Values in Selection (Optional Coloring)...
• Control+Alt+Shift+U: Change to UPPERCASE
• Control+Alt+Shift+T: Remove Leading and Trailing Spaces
• Control+Alt+Shift+N: Convert Numbers Stored as Text to Real Numbers
• Control+Alt+Z: Find and Run a Tool...

You can fully customize this list by adding any tool from ASAP Utilities, removing tools, or changing their order. You can also assign or change keyboard shortcuts.

Tip: Right-click any tool to add it to Excel's Quick Access Toolbar.

Starting this tool

Additional search terms to help you find this tool:
Favorite tools, Favorites, Hotkey, Shortcut, Keyboard shortcuts, Custom keyboard shortcuts, Accelerator key, Shortcut key, Key binding, Key combo, Custom key combo, Assign shortcut keys, Personalize shortcut keys, Excel shortcut customization, Manage favorite tools, Favorite tools shortcuts, Workflow accelerator

Tip:Alt+P for the previous tool.