Ampler lets you build your own Excel toolbar in a drag-and-drop editor — choose from hundreds of built-in and custom tools and lay out the ribbon exactly how you work.
Quick answer: Open Toolbar in the Settings dropdown, copy a starting-point toolbar, then drag functional groups and buttons into it and set its name, position, and colour.
How to use it
Create a new custom toolbar
Copy a starting toolbar, name it, and activate it.
- Click Toolbar in the Settings dropdown menu.
- Select a starting-point toolbar and click Copy selected from the New dropdown.
- Select a folder, type a name for the toolbar, and click Save.
- Activate the toolbar by clicking its green tick mark.
Change the toolbar name, position, and colour
Rename the toolbar, set its position, and set the button colour.
- Click and type the toolbar name.
- Set the toolbar position — before Home is recommended.
- Set the colour of the buttons, for example to your company brand colour.
Add and move functional groups
Drag functional groups into the toolbar and reorder them.
- Drag functional groups into the toolbar.
- Reorder them to match the way you work.
Add new buttons
Choose from hundreds of built-in and custom tools.
- Add buttons from the hundreds of built-in and custom tools available.
- Place each button in the group where you want it.
Add separators and align buttons
Add separators and align buttons for a clean layout.
- Add separators to group related buttons.
- Align the buttons for a clean, readable toolbar.
The drag-and-drop editor lets you shape the whole ribbon to your workflow.
Keyboard shortcut
The toolbar editor opens from Settings → Toolbar. To assign a shortcut to a function you’ve added, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Modify on the function, and press your key combination.
Why use it
The default ribbon rarely matches how any one person works. Building a custom toolbar puts the functions you actually use, grouped the way you think, one click away, and lets a team standardise on a shared layout.
How consultants use it
Modellers spend long stretches in Excel, so the workspace is worth optimising, and firms often standardise a toolbar so everyone works the same way. Three conventions apply:
- Tailor the workspace: the tools used most are surfaced and grouped by workflow.
- A firm-standard toolbar: a shared layout means consistency and easy hand-offs.
- On-brand, even here: button colours can match the company brand.
A custom toolbar shapes Excel around how the team actually works.
Tips & best practices
- Position the toolbar before Home so Excel keeps returning to it.
- Group buttons with separators so the toolbar stays readable.
- Share a standard toolbar across the team for consistency.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you customise the Ampler toolbar in Excel?
Open Toolbar in the Settings dropdown, copy a starting-point toolbar and activate it, then drag functional groups and buttons into it in the editor and set its name, position, and colour.
Can you choose which tools appear on the ribbon in Excel?
Yes. The drag-and-drop editor offers hundreds of built-in and custom tools to add, arrange, and group.
Where should you position a custom toolbar?
Before Home is recommended, so Excel keeps returning to it.