Select cells easier and faster

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

How to: Protect multiple sheets at once

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

Pre-release new version & Happy new year!

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

User question: How to delete cells based on content

"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 [...]

User question: How to enter the same value on multiple sheets (or in multiple cells at once)

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

How to: Change the shortcuts used by ASAP Utilities

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

ASAP Utilities released its new version (4.8.0) today!

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

How to: Select a number of worksheets and export each as a single workbook

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

PC Welt Germany: Useful extensions for Microsoft Excel

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

PC Magazine Netherlands: Ultimate free extra for Microsoft Excel

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

Bad Behavior has blocked 157 access attempts in the last 7 days.