Bastien - ASAP Utilities Blog

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

ASAP Utilities how to with ASAP Utilities

Identify duplicates

Jul 29, 2009 Bastien 0 Comment

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

Download pre-release version 4.5.4: German edition

Jul 22, 2009 Bastien 2 Comment

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

ASAP Utilities how to with ASAP Utilities

Video: How to move or resize the selected range in Excel with ASAP Utilities

May 5, 2009 Bastien 8 Comment

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

ASAP Utilities

Just released: ASAP Utilities 4.5.2!

May 5, 2009 Bastien 0 Comment

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

New ASAP Utilities version 4.5.1 released!

Apr 13, 2009 Bastien 4 Comment

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

ASAP Utilities

Review in PCWorld.hu: Boost Office at home

Mar 27, 2009 Bastien 0 Comment

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

ASAP Utilities

Updated pre-release version 4.3 available

Mar 25, 2009 Bastien 4 Comment

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

ASAP Utilities

Review in PC-WELT: The smartest Office-Addons

Mar 6, 2009 Bastien 2 Comment

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

ASAP Utilities how to with ASAP Utilities

How to: Quickly find the utility you need

Feb 10, 2009 Bastien 0 Comment

With the new version 4.3 of ASAP Utilities it will be easier to find the utility you need with the tool "Find and run a utility...". We have improved this already existing utility. The results are presented better and you can now immediately start/run the utility from the search results. If you click on the ...

ASAP Utilities how to with ASAP Utilities

How to: Remove all spaces, dashes and other garbage from numbers

Feb 10, 2009 Bastien 0 Comment

I got a question from Ryan: I have a bunch of excel cells and I need them all to have no spaces and no dashes so the first one would be: 185444001 and so on. How can I use ASAP Utilities to remove all spaces and dashes? You can do this very quick with the following utility: ASAP ...

ASAP Utilities how to with ASAP Utilities

How to: Delete blank lines in a cell with multiple lines of text?

Feb 10, 2009 Bastien 1 Comment

I'm sure you know you can enter a new line/line break by pressing Alt+Enter. But working with these newline characters can sometimes be a bit difficult, for example if you want to remove or replace them. If you have cells with multiple empty lines it can be difficult to quickly replace them all. Method 1: Do it ...

ASAP Utilities how to with ASAP Utilities

How to: Remove all blank rows at once

Feb 4, 2009 Bastien 0 Comment

If you have a lot of data it can be difficult to identify and remove the empty rows. There is no way in standard Excel to quickly remove all empty rows* so it can be a time-consuming job. You need to use a macro for that. Empty rows in your table can cause problems with sorting ...

ASAP Utilities

Pre-release version 4.3 available

Jan 27, 2009 Bastien 3 Comment

We have been working on version 4.3 for the past year. That version has many improvements. A pre-release of the new version has been tested and reviewed by a selective group of people (thanks!) the past months. Most of the tools have been updated, improved and redesigned. A major improvement is also that you can now ...

ASAP Utilities

Just released: ASAP Utilities 4.2.10

Jan 27, 2009 Bastien 0 Comment

ASAP Utilities version 4.2.10 (January 27, 2009) has just been released! This new version fixes a few bugs. While we're working on the next big updated version (4.3), a few people have reported some bugs that are now fixed in this new release. We recommend everybody to download and install the new version.

General

List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007

Nov 19, 2008 Bastien 5 Comment

A bit off-topic but because working with shortcuts is often so much faster. I believe that shortcuts are are preferred when it comes to speed/productivity and reducing the chances on RSI. Microsoft: List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007 http://support.microsoft.com/kb/290938 Just in case you weren't aware, we have a list of the shortcuts in ...

ASAP Utilities

Soon to be released: version 4.2.9

Nov 18, 2008 Bastien 19 Comment

Text » Replace accented characters (Ã¡, Ã«, Ã± etc.)...

While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.8 that I've now fixed in version 4.2.9. More information and download of the pre-release: //www.asap-utilities.com/faq-questions-answers-detail.php?m=195 This version will probably be officially released next Thursday.

ASAP Utilities how to with ASAP Utilities

When Excel doesn't recognize empty cells correctly

Nov 13, 2008 Bastien 0 Comment

Enno asked me the following: "... When I value-copy ranges where the If-function was used with a return value of "" (empty string), the cells are not blank, hence ISBLANK() = FALSE. Could you add a feature to remove empty strings? ..." Well, you can do this already with ASAP Utilities, although you cannot find it in the description of ...

ASAP Utilities

How to insert blank rows where the value changes

Oct 30, 2008 Bastien 3 Comment

Insert a blank row where the value changes

I got the following question from Jonathan this week: ... Don't know if this can be done at the moment, perhaps you could advise... I have a range of cells and I want to select ALL the cells/rows in the selection where the value changes. I can select the first cell where the value changes using 'Select Cells' ...

General

Prepare a document before sending it to others

Oct 27, 2008 Bastien 0 Comment

When you send your Excel workbook to other people, sometimes you want to protect or hide certain parts. For example the formulas you used or temporary data in hidden columns. You can do this by using Excel's worksheet protection, however you should know that this protection is easily broken and not very secure. A better method to use ...

General

Weird looping through cells in a range object

Oct 23, 2008 Bastien 5 Comment

Below is something that I experienced a while ago and was beyond my logic. Setting a range and looping through all cells in it didn't work initially as expected. Sub WeirdCelLooping() Dim rngCel As Range Dim rngSelection As Range Range("A1:G10").Select ' Doesn't work correctly: For Each rngCel In Selection.Columns(1) ' both rngCel and the selection have now the same address Debug.Print rngCel.Address & " ...

ASAP Utilities General How to how to with ASAP Utilities

Unhide all columns and rows

Oct 21, 2008 Bastien 0 Comment

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to unhide, you can also use this tool ...

ASAP Utilities

Now available: ASAP Utilities 4.2.8

Sep 24, 2008 Bastien 12 Comment

Delete all objects in selected worksheets

Yesterday the new version of ASAP Utilities was officially released. You can read the details in the newsletter or you can immediately proceed to the download page. Besides several bugfixes, these are two new things: Objects & Comments » Delete all objects on current worksheetThis utility can now be used on multiple worksheets and has been renamed ...

ASAP Utilities General

Keep leading and remove only the trailing spaces

Sep 18, 2008 Bastien 0 Comment

Jeff recently asked: I really like your product but just came upon a capability it is missing: Delete trailing spaces (but keep all other spaces). I expect it would be simple enough to add; would you? I never expected anyone to need a tool to only remove the trailing spaces but he needs it on imported ...

ASAP Utilities General

Add trailing zeros

Sep 17, 2008 Bastien 1 Comment

Max asked the following: Can the "Fill fill up with leading zero's" option under be made to work on leading or trailing zeros? For instance, if I have three numbers: 1 12 123 I would run the option to fill them with trailing zeros so they would look like: 1000 1200 1230 We want to normalize the numbers so they would all be ...… Read more...