Ampler’s My Library lets you reuse workbook templates, template sheets, cell regions, and company content in Excel, so standard model parts are inserted rather than rebuilt.
Quick answer: Click My Library (Ctrl+Shift+M) on the Ampler ribbon, search or browse for workbooks, sheets, cells, or content, and insert what you need.
How to use it
Search or browse the library, then insert a template, sheet, or cell region.
- Click My Library (Ctrl+Shift+M) on the Ampler ribbon.
- Search or browse for workbook templates, sheets, cell regions, or company content.
- Insert the item you need into the workbook.
The library holds workbook templates, reusable template sheets, cell regions with frequently used model parts, and company content such as shapes, logos, and images.
Keyboard shortcut
My Library is Ctrl+Shift+M by default; you can reassign it in the Ampler Settings → Shortcuts.
Why use it
Standard model parts — a template sheet, a block of calculations, a company logo — get rebuilt over and over. My Library keeps them searchable and reusable, so you insert the approved version instead of reinventing the wheel.
How consultants use it
Models reuse a great deal of standard structure, and firms maintain libraries so teams build on prior work rather than starting cold. Three conventions apply:
- Reuse model parts: template sheets and cell regions are inserted, not rebuilt.
- Start from templates: workbook templates save time on every new project.
- Consistent company content: shared shapes, logos, and images keep outputs on-brand.
Using the library well makes standard model parts reusable across projects.
Tips & best practices
- Save reusable template sheets and calculation blocks to the library.
- Search by keyword rather than scrolling folders.
- Share a source across the team so everyone reuses the same parts.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you reuse a template sheet in Excel?
Click My Library (Ctrl+Shift+M) on the Ampler ribbon, find the template sheet, and insert it into the workbook.
How do you insert saved model parts in Excel?
Use Ampler’s My Library to search or browse for cell regions and template sheets, then insert them.
What can you store in the Ampler Excel library?
Workbook templates, template sheets, cell regions with frequently used model parts, and company content such as shapes, logos, and images.