Ampler copies a cell’s formatting and applies it to others — the format-painter idea from PowerPoint, with keyboard shortcuts — so a range matches an example exactly.
Quick answer: Select the cells to copy from and press Ctrl+Shift+C (Pick up cell style), then select the target cells and press Ctrl+Shift+V (Apply cell style).
How to use it
Pick up a cell style, then apply it to other cells.
- Select the cells you wish to copy formatting from and click Pick up cell style (Ctrl+Shift+C).
- Select the cells to paste formatting to and click Apply cell style (Ctrl+Shift+V).
Keyboard shortcut
Pick up is Ctrl+Shift+C and Apply is Ctrl+Shift+V by default; both can be reassigned in the Ampler Settings → Shortcuts.
Why use it
Matching one cell’s formatting to others by re-setting each attribute is slow. Picking up a cell’s style and applying it — with the same shortcuts as PowerPoint’s format painter — makes the match exact and fast.
How consultants use it
Consistent cell formatting is part of a clean model, and propagating one good style is the fast way to hold it. Three habits apply:
- Format once, propagate: a well-formatted cell becomes the template the others copy
- Exact matches: the style is copied precisely, not re-set by hand
- Familiar shortcuts: the same Ctrl+Shift+C / V as PowerPoint
Pick up and apply keeps cell formatting consistent across a model.
Tips & best practices
- Format a reference cell, then propagate its style.
- Apply to a whole range at once.
- Use the same shortcuts you know from PowerPoint.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you copy cell formatting in Excel with a shortcut?
Select the source and press Ctrl+Shift+C (Pick up cell style), then select the targets and press Ctrl+Shift+V (Apply cell style) with Ampler.
Is there a format painter for Excel?
Yes. Ampler’s pick-up and apply cell style works like PowerPoint’s format painter, with keyboard shortcuts.
What are the shortcuts?
Ctrl+Shift+C to pick up and Ctrl+Shift+V to apply, both reassignable.