Huge speed improvement in the "Select » Select cells based on content, formatting and more..." utility due to a new developed algorithm. The utility now works much much faster with large data-sets too. Now available for download
Posted on January 25th, 2012 by Bastien
Filed under: ASAP Utilities | No Comments »
The built in method of Excel allows you to only protect one sheet at a time. If you want to protect multiple sheets in Excel you have to protect them one by one. This can take a long time if you have many sheets and even might result in accidentally forgetting one. With this tool [...]
Posted on January 13th, 2012 by Bastien
Filed under: ASAP Utilities, How to, how to with ASAP Utilities | No Comments »
First of all: Happy new year! I wish you all the best, and less time in Excel and more time doing fun stuff like spending time with friends and family, taking long walks on the beach, swimming with your kids, riding your mountainbike, taking photographs, go geocaching, travel or whatever it is you 'd like [...]
Posted on January 6th, 2012 by Bastien
Filed under: ASAP Utilities | No Comments »
"Hi! I couldn't find the following function in ASAP Utilities: Delete cells based on content. Ex.: I would like to delete all cells (content) which is less than 3, greater than 100…. Would be nice when working with statistics." Well, you can already do this in ASAP Utilities, but with an additional step. First you [...]
Posted on November 18th, 2011 by Bastien
Filed under: ASAP Utilities, How to, how to with ASAP Utilities | No Comments »
Today we received the following email: Let me start by saying how wonderful I think your program is. It saves me a lot of time. I just created 100 sheets and named them from a list using ASAP -great! I then inserted the name of each sheet into a cell within the sheet using ASAP [...]
Posted on November 16th, 2011 by Bastien
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities | No Comments »
Every now and then people ask us if it is possible to change the shortcuts that are used by ASAP Utilities. For example: "Hello, is it possible to change the Ctrl + Alt + J shortcut to something else?" Often because people already use the same shortcut for their own macro. Well, you can already [...]
Posted on November 3rd, 2011 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | No Comments »
We're proud to officially announce the new version of ASAP Utilities! New exiting tools have been added and several improvements have been made. Do you often work with Excel's Filters or AutoFilters? Do you need to export your worksheets as separate workbooks? Did you ever wanted to change your conditional formatting to static formatting (like [...]
Posted on October 26th, 2011 by Bastien
Filed under: ASAP Utilities | No Comments »
I just received the following question from Azad from Australia: Hi, Is it possible to select a number of worksheets and export as a single workbook? As you probably already know, Excel itself doesn't have a option for this. It can be a time consuming job to save each worksheet as a separate workbook. Fortunately [...]
Posted on October 20th, 2011 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 3 Comments »
We're proud to mention that the free ASAP Utilities Home&Student edition was featured in the January 2011 edition of the German PC Welt in an article about apps (addins) for Microsoft Office. English Translation: "Useful extensions for Microsoft Excel....ASAP Utilities is a collection of Excel macros with several hundred commands for formatting worksheets and highlight [...]
Posted on October 18th, 2011 by Bastien
Filed under: ASAP Utilities | No Comments »
We're proud to mention that the free ASAP Utilities Home&Student edition is featured in the October 2011 edition of the Dutch PC Magazine in an article about apps (addins) for Microsoft Office. English Translation: "Firefox and Crome are well known for it, but Microsoft Office can also be improved with the use of extensions or [...]
Posted on October 15th, 2011 by Bastien
Filed under: ASAP Utilities | No Comments »