Ampler draws company-standard borders and cycles through border styles — with buttons or a keyboard shortcut — so a range is bordered cleanly and consistently.
Quick answer: Select the cells and click the Cycle border buttons, or press Ctrl+Alt+Shift with the arrow keys to draw borders; click again to cycle to the next border style.
How to use it
Select the cells, then cycle or draw borders with shortcuts.
- Select the cells you wish to draw borders around.
- Click the Cycle border buttons, or press Ctrl+Alt+Shift and use the arrow keys (up, down, left, right) to draw borders.
- Click again to draw the next border style.
The formats it cycles through are the ones defined under Settings → Cycles, so you can set them to your company standards.
Keyboard shortcut
Ctrl+Alt+Shift with the arrow keys draws borders; Ampler functions can be assigned shortcuts in Settings → Shortcuts.
Why use it
Excel’s border controls are fiddly, and borders end up inconsistent across a workbook. Ampler cycles through your standard border styles — and lets you draw them with a shortcut — so ranges are bordered cleanly and the same way each time.
How consultants use it
Clean, consistent borders are part of a professional exhibit or model table. Three habits apply:
- Consistent borders: ranges are bordered in the same company style
- Fast with shortcuts: borders are drawn with a keystroke, not the border menu
- On the standard: the styles come from the defined cycle
Cycling borders keeps a workbook’s tables bordered cleanly and consistently.
Tips & best practices
- Use the Ctrl+Alt+Shift arrows to draw borders fast.
- Cycle to the border style your firm uses.
- Define border styles under Settings → Cycles.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you add borders quickly in Excel?
Select the cells and use Ampler’s Cycle border buttons, or press Ctrl+Alt+Shift with the arrow keys to draw borders.
Can you set company-standard borders in Excel?
Yes. The border styles are defined under Settings → Cycles, so they match your standard.
What is the shortcut to draw borders?
Ctrl+Alt+Shift with the arrow keys (up, down, left, right).