Ampler swaps two cell selections, rows, or columns in one click — preserving their references, so you can reorder a model without breaking formulas.
Quick answer: Select the first group, hold Ctrl and select the second, then click Swap selected cells on the Ampler ribbon; references are preserved.
How to use it
Select two groups, then Swap selected cells.
- Select the first group of cells, then hold Ctrl and select the second group as well.
- Click Swap selected cells on the Ampler ribbon.
It works with cell selections, rows, and columns, and swaps their positions while preserving references — so formulas keep pointing where they should.
Keyboard shortcut
Swap selected cells has no default shortcut. To assign one, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Modify on the function, and press your key combination.
Why use it
Swapping two blocks by cut-and-paste breaks any formulas that point at them, so you have to fix the references afterwards. Ampler swaps the positions and preserves the references, so the model still works after the reorder.
How consultants use it
Models are reordered as they develop — a scenario moved, two blocks exchanged — and doing so without breaking references is essential. Three habits apply:
- Reorder safely: two blocks swap position with their references intact.
- No formula repair: nothing has to be re-pointed after the swap.
- Cells, rows, or columns: the same tool handles all three.
Swapping cells reorders a model without breaking it.
Tips & best practices
- Select the two groups with Ctrl before swapping.
- Use it on rows or columns to reorder a model safely.
- Check with Scan & Fix after large restructures.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you swap two ranges in Excel without breaking formulas?
Select the first group, hold Ctrl and select the second, then click Swap selected cells on the Ampler ribbon. The positions swap and references are preserved.
Can you swap rows or columns in Excel?
Yes. Ampler’s Swap works with cell selections, rows, and columns.
Does swapping cells break references?
No. Ampler preserves references when it swaps positions.