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

Sort your data basically on anything you can think of

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

Tip: Easily count and/or color duplicate values

Count and optionally color duplicated values

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

Tip: Quickly save worksheets as separate files

Save worksheets as individual files

Save 5 minutes a day by using ASAP Utilities to quickly save the worksheets in your workbook as separate files. "How can I save my sheets as separate files?" "I have an Excel file with many worksheets. We need to export each worksheet to a separate file. Ideally the file name would be the worksheet's […]

Just released: ASAP Utilities 5

because it makes YOU rock in Excel!

We're proud to officially announce the new version 5 of ASAP Utilities! Many improvements have been made and Excel 2013 (32-bit) is now officially supported too. Download | See what's new Many thanks to everyone who has contributed their feedback and tested the pre-release! Free upgrade All existing customers get version 5 free of charge! […]

Tip: Easily remove leading characters

Save 5 minutes a day by using ASAP Utilities to quickly remove a given number of leading characters from your cells. "How to quickly remove a specified number of leading characters..." Just select the cells and then start: ASAP Utilities » Text » Delete number of leading characters... Do you recognize any of these situations? […]