ASAP Utilities, description of our Excel tools

Language:

ASAP Utilities Options » Edit your favorite tools and shortcut keys...

ASAP Utilities contains a lot of different utilities.
With the "Favorite tools" you can add the tools from ASAP Utilities that you use most frequently and assign your own shortcuts to them.

By default the list is filled with the following tools:

Ctrl+Alt+A: Select adjacent cells in column with the same value
Ctrl+Alt+B: Reload all installed add-ins (rebuilds the menu)
Ctrl+Alt+C: Color each n'th row or column in selection...
Ctrl+Alt+D: Deselect cells...
Ctrl+Alt+E: Set default path to current file
Ctrl+Alt+F: Create a list of filenames and properties in a folder...
Ctrl+Alt+G: Export selection or active sheet as new file...
Ctrl+Alt+H: Find and/or replace in all sheets...
Ctrl+Alt+I: Apply formula/calculation to selected cells...
Ctrl+Alt+J: Start the last used utility again...
Ctrl+Alt+K: Expand selection to last used column
Ctrl+Alt+L: Expand selection to last used row
Ctrl+Alt+M: Move or resize selected range...
Ctrl+Alt+N: Add new worksheet (fill in a name)...
Ctrl+Alt+O: Select cells based on content, formatting and more...
Ctrl+Alt+P: Convert formulas to their values
Ctrl+Alt+Q: Quick numbering of selected cells...
Ctrl+Alt+R: Reset Excel's last cell
Ctrl+Alt+S: Save file and create backup
Ctrl+Alt+V: Vision Control...
Ctrl+Alt+X: Move selected range (only values)...
Ctrl+Alt+Y: Paste special (with combinations)...
Ctrl+Shift+D: Insert current date and time with seconds
Ctrl+Shift+T: Insert current time with seconds
Ctrl+Alt+Z: Find a utility (search help)...

The shortcuts are also visible throughout the rest of the menu.

Screenshots

Example screenshot: 1 The favorites and shortcuts menu

1 The favorites and shortcuts menu (Click to zoom)

Example screenshot: 2 Change your favorite utilities and assign your own shortcut

2 Change your favorite utilities and assign your own shortcut (Click to zoom)

Starting this utility

In the Excel menu choose: ASAP Utilities » ASAP Utilities Options » Edit your favorite tools and shortcut keys...

« Return to the list of “ASAP Utilities Options” tools.

« Previous
Settings, language and contact information...

Next »
Start the last used utility again...

Excel 2010 with ASAP Utilities in the menu

Download ASAP Utitilities

Additional keywords for this tool:
hotkey, shortcut, change or remove keyboard shortcuts, accelerator key, shortcut key, hot key, key binding, keybinding, key combo

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our "tip of the week" at: