I'm proud to mention that the new version of ASAP Utilities is almost ready! Based on the requests from many users, we have added several tools that will speed up your work in Excel. Furthermore we have improved many tools and fixed all known bugs. You can read what's new and download the pre-release from: //www.asap-utilities.com/faq-questions-answers-detail.php?m=224 One of the many ...

The new version of ASAP Utilities, 4.5.8 has just been released! We have added a few new tools, made some improvements and fixed a few bugs. Download ASAP Utilities 4.5.8 View the changes. Many thanks to everyone who has contributed their feedback!

In standard Excel you can not set the height or with of cells in centimeters or inches. Creating square cells is also difficult because Excel uses different units for the width and height of cells. Setting the width and height in centimeters or inches can be helpful if you use the Excel for drawing purposes, such ...

At this moment ASAP Utilities already contains several tools to manage duplicates. However a special tool for duplicate records was still missing... until now! You could already identify or remove duplicated records with a workaround by merging the cell contents into a temporary added column and then use ASAP Utilities' "Conditional row and column select, hide or ...

Many people have asked me the past years if ASAP Utilities has an option to split a table into several sheets. Either per so many rows, or by value. Until recently that wasn't possible, but now it is!. In cooperation with several users we have created a new utility. In the new version of ASAP Utilities ...

There are few quick methods to remove the line breaks and carriage returns in cells. By default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities. Let's say we have the following example. In this case the author has ...

Last month I received the following question: I need to know how to convert an excel file into a pipe delimited file using the ASAP software. You can use the following tool to do this: ASAP Utilities » Export » Export selection or active sheet as new file... Then choose "CSV (comma separated value) or customer separated" and specify ...

I just received the following question which might be interesting the share with you. ASAP Utilities contains many tools and one of the strengths is that you can often use a combination of the tools to accomplish what you need. The question I received this week: I want to insert a blank row after every 3rd row ...

The new version of Office, Office 2010 (Office twenty-ten) will be available in both a 32 bit and a 64 bit version. All previous version of Office were 32 bit. Office 2010 will be released in the first half of 2010. At this moment our advise is to install the 32 bit version of Office, even ...

Parlez-vous français? / Do you speak French? ...then I have good news for you! ASAP Utilities is now also available in the French language. If you have the French language version of Excel then ASAP Utilities will start the first time automatically in French (Français). You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities ...

Last week I received the following question: Bastien, First, thank you so much for the best Excel add-on ever! Is there a way to remove empty rows in a only a selected section of the worksheet, not the whole worksheet? Or have I missed this option that is already included? Surely you can do this! The utility "Columns & Rows » ...

Today the Russian website, 3D News, has written an article about Excel plugins (add-ins) and how these can speed up your work. We're proud to see that ASAP Utilities is also mentioned in the article. We are working for many years (over 10 years now) on ASAP Utilities to help you to speed up your work ...

¿Habla usted español? (Do you speak Spanish?) Then I have good news for you: ASAP Utilities is now also available in the Spanish language. If you have the Spanish language version of Excel then ASAP Utilities will start the first time automatically in Spanish (Español). You can change the language in the options dialogue: ASAP Utilities » ASAP ...

ASAP Utilities version 4.5.4 (September 1, 2009) has just been released! We're proud to announce that the new version of ASAP Utilities is available in the German language too. We have also added two new tools and made several improvements. More information is in the newsletter.

These days, with all the economical issues, it is more then ever important to see where you can save money. You have probably already heard from others or experienced yourself that ASAP Utilities can save you a lot of time with your work in Excel. But how much time (and money) does it actually save ...

Last week I received the following question: Is there an ASAP Utilities function that can remove all negative numbers from a spreadsheet? I haven't found it yet. Yes there is. You can use ASAP Utilities to help you to quickly delete negative numbers. You can use the following tool to select all cells with negative numbers (values ...

I recently receive the following question: Is there a way to combine numerous Sheets into a single Sheet? I have an Excel document with 72 sheets, that I would like to be 1 continuous sheet. Thanks again for your help. You can use the following tool to put together the rows or columns from multiple ...

I just received the following question: I will like to know how I can see the duplicates in a selection data? I'm aware I can delete duplicates, however I will like to know how to identify them first before deleted. Here's how to do this: You can use the following tool to select the cells with duplicated values: ...

ASAP Utilities is now also available in the German language. If you have the German language version of Excel, ASAP Utilities will now start in German (Deutsch). You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings... In ASAP Utilities you can now choose between the ...

The following video will show you how to how to move or resize the selected range in Excel by using ASAP Utilities. With this utility you can easily move or resize your selected range of cells. This utility will only change you selected range of cells only, not the data underneath it. Note: This has in 2021 be ...

The new version of ASAP Utilities, 4.5.2 May 1th 2009, has just been released. Download ASAP Utilities, 4.5.2 May 1th 2009 Most of the updates in this new version are bug-related. The bugs that were reported after the recent release of version 4.5.0 and 4.5.1. have been fixed in this new version. Furthermore a few (minor) improvements ...

ASAP Utilities version 4.5.1 (April 11, 2009) has just been released! This new version is improved in many ways. Most of the tools have been updated, improved and redesigned. A major improvement is that you can now switch between two languages: English and Dutch (Nederlands)! You can read the full newsletter on our website: //www.asap-utilities.com/asap-utilities-newsletter-2009-02.php

We're proud to mention that ASAP Utilities has been reviewed by the Hungarian edition of PCWorld. On March 25 they published the article "Office szervizcsomag házilag" (Boost Office at home) on their website which is about additions of Office 2007. ASAP Utilities was listed as one of the useful additions they mentioned. Boost Office at ...

The past weeks I have made several improvements to the "engine" of ASAP Utilities. One of the improvements is a rewrite of the undo procedures in ASAP Utilities. When undo is available for a utility it now also works on cells with values that contain more than 1024 characters. More information and download: //www.asap-utilities.com/asap-utilities-pre-release-version-430.php

This March the German computer magazine PC WELT has an item on add-ins for Word and Excel. They call it the Microsoft Office Service Pack 2009 ;-) We're proud to mention that ASAP Utilities was listed as one of the addons; on page 49 and 50. The article translated into English: The smartest Office Addons "You work daily with ...