Tip: Fast calculation on selected cells

Fast calculation on selected cells

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 […]

Tip: Easily remove certain or several characters at once

Advanced character remove or replace

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 […]

Tip: Quickly fill blank cells with value above in Excel

Copy values to empty cells below filled cells in selection

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 […]

Tip: 'AutoFit Row Height' on merged cells too

Autofit rowheight also on merged cells

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 […]