Tip of the Day | Thursday December 7th, 2023
Discover new tools to get things done.
Detect and visualize adjacent data/group changes...
With this utility you can easily make the differences visible between groups of cells with the same content.You can do the following when the value in a row changes:
You can use this for example to identify different groups of data in your worksheet by inserting a blank row when the value changes or inserting a line in between.
Your last used settings will be remembered.
Note:
This utility only works on the rows (data) in a single column.
Screenshots
Example screenshot: 1 Insert an empty row between groups
Example screenshot: 2 Insert a pagebreak between groups
Example screenshot: 3 Insert a border line between groups
Example screenshot: 4 Color banding per group
Starting this tool
- Click ASAP Utilities › Format › 4. Detect and visualize adjacent data/group changes...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
