Author: Bastien

Quickly reset the last cell and minimize the used range

Quickly reset the last cell on your sheet and minimize the used rangeSave 5 minutes a day by using ASAP Utilities to quickly reset the used range on your worksheet. “Easily reset the last cell on your sheet” Have you ever been frustrated when Excel acts as if the active area of your worksheet is significantly larger than the actual area where you have data? Sometimes the […]

Easy ways to combine the contents of multiple cells

Merge column data (join cells)Save 5 minutes a day by using ASAP Utilities to quickly combine the contents of multiple cells into once cell. “Is there a quick way to merge the contents of multiple cells?” We were recently asked: “Does ASAP have a quick alternative for merging the contents of many cells into a single one? Using ampersands […]

Quickly fix the trailing minus sign for negative numbers

Fix trailing minus sign for negative numbersSave 5 minutes a day by using ASAP Utilities to quickly fix numbers with a trailing minus sign. “How can I flip the minus sign and make it a real negative number?” We were recently asked: “I have downloaded a report that shows negative numbers as follows: 123.25- How can I make the negative symbol […]

Learn to Easily transpose 1 column into multiple rows, creating a table

Transposes data from one column into a tableSave 5 minutes a day by using ASAP Utilities to quickly transpose your single column into a table. “How to quickly change a long list to a table?” Have you ever had data in a single column that you manually needed to “Copy > Paste Special > Transpose” over and over again to get it […]

Easily insert an English formula in your non-English Excel version

Easily paste English formulas into your local Excel version, such as for example a Dutch Excel versionSave 5 minutes a day by using ASAP Utilities to insert English formulas you found as examples. “How to use English formula examples in your local Excel version?” On the Internet you can find an enormous amount of useful formulas for Excel. Most of these examples use the “international” formula notation. They use English function […]