Ampler lets you assign shortcuts to its Excel functions — and to built-in Excel functions — so the tools you use most are a keystroke away.
Quick answer: Open the Settings dropdown, choose Shortcuts, click Modify on a function, press your key combination, and click OK.
How to use it
Open Shortcuts, Modify a function, and press the keys.
- Click the Settings dropdown and select Shortcuts.
- Click Modify on a function to edit or create a shortcut.
- Press the keys of the shortcut and click OK.
You can set shortcuts for Ampler’s custom functions and for built-in Excel functions; press Ctrl+P in the panel to print a list of useful Excel shortcuts.
Keyboard shortcut
This is the shortcuts panel itself — open it from Settings → Shortcuts. Common defaults include New Workbook (Ctrl+Shift+N), Save As (Ctrl+Shift+S), Scan & Fix (Ctrl+Shift+P), and My Library (Ctrl+Shift+M).
Why use it
Reaching for the ribbon for a function you use constantly is slow. Binding functions — Ampler’s or Excel’s own — to shortcuts turns them into muscle memory, so the tools you rely on are always a keystroke away.
How consultants use it
Modellers work fast and keep their hands on the keyboard, so shortcuts matter. Three habits apply:
- Bind the daily drivers: the functions used constantly get shortcuts.
- Excel functions too: shortcuts can be set for built-in Excel functions, not just Ampler’s.
- A consistent set: a shared scheme means anyone can sit at anyone’s Excel.
Custom shortcuts turn frequent actions into reflexes.
Tips & best practices
- Start with the five functions you use most.
- Set shortcuts for built-in Excel functions you reach for often.
- Print the shortcut list with Ctrl+P for reference.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you set a keyboard shortcut in Ampler for Excel?
Open the Settings dropdown, choose Shortcuts, click Modify on a function, press your key combination, and click OK.
Can you set shortcuts for built-in Excel functions?
Yes. Ampler lets you assign shortcuts to built-in Excel functions as well as its own custom functions.
How do you print the Excel shortcut list?
Press Ctrl+P in the Shortcuts panel to print a list of useful Excel shortcuts.