Tip: 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 names, a comma ...

Tip: Sort your data on anything that you can think of

Sort your data basically on anything you can think ofSave 5 minutes a day by using ASAP Utilities to sort your cells on bold, italic, color, font, etc., etc.. "Sort by bold, italic, color, font, month, etc., etc." You can easily sort your data on all kinds of characteristics with: ASAP Utilities » Range » Advanced sorting... With this utility you can sort by: Value Number format Cell Color Cell Color Indexnumber Font ...

Tip: Easily count and/or color duplicate values

Count and optionally color duplicated valuesSave 5 minutes a day by using ASAP Utilities to quickly identify the duplicated/repeated values. "How can I see which are the duplicate values?" Just select the cells and then start: ASAP Utilities » Information » Count and/or color duplicates in selection... Do you recognize any of these situations? How can I highlight duplicates in Excel? I need to quickly verify ...

Tip: Easily remove certain or several characters at once

Advanced character remove or replaceSave 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 ...

Tip: Easily strip leading zeros from your numbers

Strip leading zeros

Save 5 minutes a day by using ASAP Utilities to quickly strip the leading zeros from your numbers. Quickly remove the leading zeros from numbers Some programs export numbers with leading zeros. You quickly fix these numbers with: ASAP Utilities » Numbers & Dates » Change not recognized numbers (text?) to numbers Do you recognize any of these situations? I have ...

Tip: Quickly extend your selection down to the end without scrolling

Save 5 minutes a day by using ASAP Utilities to quickly extend your selection all the way down to the end of your data. "Easily select all the way down without the mouse/scrolling" The downside of Excel's shortcut Control+Shift+Down Arrow, is that it extends your selection down till the first empty cell that is found. However, an ...