Ampler cycles column width and row height through your company’s defined standards, so sheets share exact, professional dimensions.
Quick answer: Select the cells and click Cycle column width (Ctrl+Alt+Page Up) or Cycle row height (Ctrl+Alt+Page Down); click again to cycle to the next standard size.
How to use it
Cycle the width or height to the next standard size.
- Select the cells corresponding to the columns or rows to adjust.
- Click Cycle column width (Ctrl+Alt+Page Up) or Cycle row height (Ctrl+Alt+Page Down).
- Click again to cycle to the next width or height.
The widths and heights it cycles through are defined under Settings → Cycles, so they match your company standards.
Keyboard shortcut
Cycle column width is Ctrl+Alt+Page Up and Cycle row height is Ctrl+Alt+Page Down by default; reassign them in the Ampler Settings → Shortcuts.
Why use it
Dragging columns to a consistent width by eye never quite matches across sheets. Cycling through defined standard widths and heights gives every sheet exact, consistent dimensions in a keystroke.
How consultants use it
Consistent column widths and row heights give a model a professional, uniform look across sheets. Three habits apply:
- Exact, standard dimensions: widths and heights come from a defined set, not the eye.
- Consistent across sheets: every sheet uses the same standard sizes.
- Fast with shortcuts: a keystroke cycles to the next size.
Cycling width and height keeps a model’s dimensions consistent and professional.
Tips & best practices
- Define your standard widths and heights under Settings → Cycles.
- Use the Page Up/Page Down shortcuts to cycle as you build.
- Combine with Auto-fit where content should drive the size.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you set a standard column width in Excel?
Select the cells and click Cycle column width (Ctrl+Alt+Page Up) on the Ampler ribbon to cycle through your company’s standard widths.
What are the shortcuts for column width and row height?
Ctrl+Alt+Page Up cycles column width and Ctrl+Alt+Page Down cycles row height.
Where are the standard sizes defined?
Under Settings → Cycles, so they match your company standard.