Tip of the Day | Friday 7 August 2026

Discover new tools to get things done.

Insert Visual Breaks Between Groups in a Column...

This tool makes it easy to visually separate groups of rows based on repeating values in a column.
It analyzes one column in your selection, detects where the value changes, and then inserts visual formatting to highlight the group breaks.

You can choose to insert:

  • Empty row(s) between groups
  • A page break between groups
  • A border below each group
    • Customize style, thickness, and color
    • Apply to the current table or region or the entire row
  • Alternating colors for each group
    • Optionally remove existing formatting first
    • Apply to the current table or region or the entire row

This makes your data easier to scan, present, or print.

Examples of use:

  • Add white space or lines between customers, regions, or product types
  • Visually group transactions by account or project
  • Shade alternating groups to improve readability

Your last used settings are automatically remembered.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: 1 Insert an empty row between groups (Here's the English version.)
1 Insert an empty row between groups
Example screenshot: 2 Insert a pagebreak between groups (Here's the English version.)
2 Insert a pagebreak between groups
Example screenshot: 3 Insert a border line between groups (Here's the English version.)
3 Insert a border line between groups
Example screenshot: 4 Color banding per group (Here's the English version.)
4 Color banding per group

Tip:Alt+P for the previous tool.