Save 5 minutes a day by using ASAP Utilities to quickly get basic info and calculation results on your selection. "How can I get a quick sum, avg, min, max, no of duplicates etc.?" This utility provides info and performs a fast calculation on the selected cells. Just select the cells and then start: ASAP Utilities » Information » ...

Save 5 minutes a day by using ASAP Utilities to quickly remove or replace characters in your selection. "How to quickly get rid of multiple characters at once..." With this utility you can remove or replace certain characters in your worksheet or selected cells. You can pick one or more characters from a list, including numbers, letters, special ...

Save 5 minutes a day by using ASAP Utilities to quickly fill blank cells using the data in the cells above. Auto fill empty cells using the data from the cell above When setting up data in Excel it is good practice to ensure that all cells with labels are filled. Empty cells can lead to trouble when ...

Save 5 minutes a day by using ASAP Utilities to automatically fit the row height on merged cells too. Make the AutoFit Row Height work on merged cells Strangely, when using the AutoFit feature in Excel it completely ignores merged cells. In standard Excel, you cannot use the AutoFit feature on a row that contains a cell merged ...