Ampler cycles the selected cells through your company’s standard percentage formats in a keystroke, so numbers are formatted consistently across a model.
Quick answer: Select the cells and click Cycle percentage format on the Ampler ribbon; click again to cycle to the next format.
How to use it
Select the cells, then cycle the format.
- Select the cells you wish to format.
- Click Cycle percentage format (Ctrl+Shift+5), and click again to cycle to the next format.
The formats it cycles through are the ones defined under Settings → Cycles, so you can set them to your company standards.
Keyboard shortcut
Cycle percentage format is Ctrl+Shift+5 by default; reassign it in the Ampler Settings → Shortcuts.
Why use it
Percentages need consistent decimals and a house treatment for negatives (often red). Cycling through your standard percentage formats applies that in a keystroke.
How consultants use it
Consistent number formatting is a basic quality signal in a model, and applying a house standard by hand is slow. Three habits apply:
- Consistent decimals: the standard number of decimal places is applied
- Negatives on standard: negative percentages follow the house treatment, e.g. red
- On the house standard: the formats come from the defined cycle
Cycling percentage formats keeps percentages consistent, negatives included.
Tips & best practices
- Select a range and cycle to the standard format.
- Set the formats to your house standard under Settings → Cycles.
- Keep formatting consistent across the whole model.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you format percentages consistently in Excel?
Select the cells and click Cycle percentage format (Ctrl+Shift+5) on the Ampler ribbon to apply your standard decimals and negative treatment.
What is the shortcut for percentage format?
Ctrl+Shift+5 by default, reassignable in Ampler’s Settings.