Tip: Insert a border or blank row after repeating cell values in a column

Insert a blank row at every change in value in a given column

Save 5 minutes a day by using ASAP Utilities to quickly insert borders or empty rows between repeated values. "Quickly recognize groups of data" Groups of repeated values are easier recognizable if they are separated by an empty row, border line or color. You can quickly do that with the following tool: ASAP Utilities » Columns & Rows » Detect ...

Tip: Select cells automatically based on their contents, formatting, etc.

Select cells based on their value, lenght, etc.

Save 5 minutes a day by using the "Select » Select cells based on content, formatting and more..." tool: Quickly select certain cells automatically? You can have cells selected automatically for you, with the following tool: ASAP Utilities » Select » Select cells based on content, formatting and more... Especially when you need to select more than a dozen ...

Tip: Get rid of unwanted spaces in your data

Delete leading, trailing and excessive spaces

Save 5 minutes a day by using the "Text » Delete leading, trailing and excessive spaces" data cleanup tool: Quickly remove all unnecessary spaces With: ASAP Utilities » Text » Delete leading, trailing and excessive spaces Remove all spaces from the beginning and end of your data and replace duplicated spaces between words with a single space. Do you ...