Quickly add a tool to your favorites menu

You can now quickly add the tool from within the result window to your Favorites-menu by pressing the + button:

In the new version of ASAP Utilities (pre-release available here), you will be able to quickly add a tool to your favorites menu from withing the "Find and run a utility..." search results: PS. If you are interested in which tools from ASAP Utilities you use the most, then you can already use this utility.

Subscript the numbers in chemical equations

Subscript the numbers in chemical equations

We just released the pre-release of the new version of ASAP Utilities (4.6.4). One of the new utilities, is a tool to automatically subscript the numbers in chemical equations: We got the suggestion to make this from Ryan: First I'd like to tell you how much I love ASAP utilities, I am doing a Masters […]

ASAP Utilities 4.6.2 has just been released

Bug

ASAP Utilities 4.6.2 is now available. The quick release after the previous version is due to an unfortunate a bug in version 4.6.1 in the "Export » Export worksheets as separate files..." utility. It produced empty files if you choosed a text-format. Our apologies for that. If you already downloaded and installed 4.6.1, then please […]

Just released: ASAP Utilities 4.6.1

Melle

The new version of ASAP Utilities, 4.6.1 has just been released! A few nice additions have been added and a few bugs were fixed. We also fixed the startup error that sometimes occurred due to a bug in Excel 2010. Download ASAP Utilities 4.6.1 View the changes. Many thanks to everyone who has contributed their […]

Now available: ASAP Utilities 4.6.0

Bugs fixed

ASAP Utilities version 4.6.0 (June 7, 2010) has just been released! This new version is released quickly after the previous version. That is because there were a few bugs in two of the most used tools ("Select cells based on content, formatting and more..." and "Export selection or active sheet as new file..."). My apologies […]

ASAP Utilities 4.5.9 has been released!

Multilanguage setup

I'm proud to tell you that the new version of ASAP Utilities, 4.5.9 has just been released! We have added a few new tools, made several improvements and fixed a few bugs. Download ASAP Utilities 4.5.9 View the changes. Many thanks to everyone who has contributed their feedback!

Almost ready: ASAP Utilities 4.5.9

Select cells by date

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

Just released: ASAP Utilities 4.5.8

The new version of ASAP Utilities has just been released

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!

How to: Set column width and row height in centimeters or inches?

Set the rowheight and columnwidht in centimers or inches

In standard Excel you can't 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 […]

How to: Quickly remove duplicated records

Remove duplicated records

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

How to: Split data table into multiple worksheets (and save time)

Export data in parts to multiple sheets

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

How to: Remove or replace line breaks and carrage returns in cells

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

How to: Create a pipe delimited file

Create a pipe-delimited text file

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

How to: Insert a blank row after every 3rd row

initial-dataset

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

Excel 2010: Use the 32 or 64 bit edition? 32 Bit might be wiser…

MS Office 2010 logo

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

Parlez-vous français? – Pre-release version 4.5.6

paris-eiffeltower-2009

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

Remove all empty rows – within your selection

remove all empty rows

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

Russian review of ASAP Utilities and other Excel add-ins

3D News - Daily Digital Digest

Today the Russion 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 […]

¿Habla usted español? – Pre-release version 4.5.5

bordersign-spain.jpg

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

New ASAP Utilities version available: 4.5.4

Home grown strawberry

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.

New tool: How much time (and money) does ASAP Utilities save you?

Show the time that ASAP Utilities has saved you

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

How to: Remove all negative numbers

Select the negative numbers

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

How to combine numerous sheets into a single sheet

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

Identify duplicates

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

Download pre-release version 4.5.4: German edition

bordersign-bundesrepublik-deutschland

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

Page 4 of 9123456789