Ampler reverses the order of selected rows or columns in one click — keeping references intact, so you can flip a series without cutting and pasting.
Quick answer: Select the cells and click Reverse columns (or Reverse rows) on the Ampler ribbon; the order flips and references are preserved.
How to use it
Select the range, then reverse columns or rows.
- Select the cells to reverse — by click-dragging, or hold Ctrl for multiple selections.
- Click Reverse columns (or Reverse rows).
The order is reversed while references are preserved, avoiding a run of cut-and-paste operations.
Keyboard shortcut
The reverse functions have 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
Flipping a series — oldest-to-newest into newest-to-oldest, say — by hand means a sequence of cut-and-paste moves that break references. Ampler reverses the order in one click and keeps the references, so the model stays intact.
How consultants use it
Time series and ranked lists sometimes need flipping, and doing it safely is part of clean model work. Three habits apply:
- Flip a series safely: the order reverses with references intact.
- No cut-and-paste marathon: a single click replaces a run of manual moves.
- Rows or columns: either can be reversed.
Reversing order flips a series without breaking the model.
Tips & best practices
- Use it to flip a time series’ direction.
- Select multiple ranges with Ctrl if needed.
- Confirm with Scan & Fix after big changes.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you reverse the order of columns in Excel?
Select the cells and click Reverse columns on the Ampler ribbon. The order flips and references are preserved.
How do you flip rows in Excel without losing formulas?
Use Ampler’s Reverse rows — it reverses the order while keeping references intact.
Does reversing break references?
No. Ampler preserves references when it reverses rows or columns.