Ampler’s fast fill replicates a formula or pattern across a range and detects where the series should end — better than Excel’s built-in fill.
Quick answer: Select the cells that contain the formula or pattern and click Fill right (Ctrl+R) or Fill down (Ctrl+D); Ampler extends it and stops where the data ends.
How to use it
Select the source cells, then Fill right or down.
- Select the cells that contain the formula or pattern to replicate.
- Click Fill right (Ctrl+R) or Fill down (Ctrl+D).
Ampler detects where the series should end and fills to there, so you don’t over- or under-fill the range.
Keyboard shortcut
Fill right is Ctrl+R and Fill down is Ctrl+D by default; both can be reassigned in the Ampler Settings → Shortcuts.
Why use it
Excel’s fill copies as far as you drag, so you have to select the exact range or clean up afterwards. Ampler detects where the series should end from the surrounding data and fills to there, so a formula reaches the bottom of the block and no further.
How consultants use it
A model’s formulas must reach every row of a block and stop cleanly — a formula that falls short or overruns is a classic modelling error. Three habits apply:
- Fill the whole block: the formula reaches the last row of data, not part-way.
- No overrun: the fill stops where the data ends, so there are no stray formulas below.
- Consistent rows: every row of a block carries the same formula.
Pattern-aware fill keeps a model’s blocks complete and clean.
Tips & best practices
- Select the source cells before filling so the pattern is clear.
- Use it on blocks where the built-in fill over- or under-shoots.
- Check with Scan & Fix for rows that were left unfilled.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you fill a formula down a column in Excel?
Select the source cells and press Ctrl+D (Fill down) or Ctrl+R (Fill right) with Ampler — it detects where the series ends and fills to there.
How is Ampler’s fast fill better than Excel’s?
It detects where the series should end from the surrounding data, so it fills the whole block without over- or under-filling.
What are the shortcuts for fast fill?
Ctrl+R for Fill right and Ctrl+D for Fill down, both reassignable in Ampler’s Settings.