Filed under: ASAP Utilities on May 5th, 2009 by Bastien | 7 Comments »
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.
By default you can start this utility with the shortcut Control+Alt+M.
Read more...
Filed under: ASAP Utilities on May 5th, 2009 by Bastien | 7 Comments »
Filed under: ASAP Utilities on May 5th, 2009 by Bastien | No Comments »
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 have been made.
Many thanks to everyone who has contributed their feedback!
Filed under: ASAP Utilities on May 5th, 2009 by Bastien | No Comments »
Filed under: ASAP Utilities on April 13th, 2009 by Bastien | 4 Comments »
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:
http://www.asap-utilities.com/asap-utilities-newsletter-2009-02.php
Filed under: ASAP Utilities on April 13th, 2009 by Bastien | 4 Comments »
Filed under: ASAP Utilities on March 27th, 2009 by Bastien | No Comments »
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 home
Unfortunately Google Translate doesn't work completely good on the translation of the article, but it it did help me a bit to get an understanding of the article:
"Perfect software is not there, even the best application is missing a useful function. A perfect example is the Office 2007, which - in principle - knows all about what a complete package of office programs expect. We nevertheless found a dozen applications and a small addition of useful new features for our favorite office package." Read more...
Filed under: ASAP Utilities on March 27th, 2009 by Bastien | No Comments »
Filed under: ASAP Utilities on March 25th, 2009 by Bastien | 4 Comments »
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:
http://www.asap-utilities.com/asap-utilities-pre-release-version-430.php
Filed under: ASAP Utilities on March 25th, 2009 by Bastien | 4 Comments »
Filed under: ASAP Utilities on March 6th, 2009 by Bastien | 2 Comments »
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 Word, Excel & Co. and believe you know all the finesse of the office suite? We provide you with useful tools and extensions that allow you get get the most out of the software.
Everybody can use Word and Excel: open documents, write text, create tables, format it and print it out. MS Office believes that that is a huge wealth of options. But there is more: you can upgrade it with some handy features that are missing from the package - until now. We present you the smartest free addons, tools and enhancements for Office & Co."
The part on ASAP Utilities:
"For Excel fans is the collection macros from ASAP Utilities. She makes a variety of functions quickly and easily available, which you would otherwise only have achieved with difficulty.
Already ten years there is this collection of hundreds of tools for formatting worksheets and and cells, highlighting ranges or for direct access to data that meets certain conditions. Also creating an index-sheets and data exports are easier than in Excel itself. The toolset creates its own menu, or in Excel 2007 its own tab in the ribbon. For private use, ASAP Utilities is free."
Read more...
Filed under: ASAP Utilities on March 6th, 2009 by Bastien | 2 Comments »
Filed under: ASAP Utilities, how to on February 10th, 2009 by Bastien | Comments Off
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 question mark you will be taken to the description of the particular utility on our website.
In the main menu the "User Guide (pdf)" has been replaced with "Find and run a utility...". The link to the manual is now located at:
ASAP Utilities Options » Open the ASAP Utilities User Guide (English, PDF)...
The "Find and run a tool..." is more powerful and therefore now located in the main menu.
With this utility you can search for a tool, view the description and immediately press the "run" button.
For example if you want to select all cells that are italic but you don't know if this can be done or you don't remember anymore how you did this previously, then this tool can be very useful:
Filed under: ASAP Utilities, how to on February 10th, 2009 by Bastien | Comments Off
Filed under: ASAP Utilities, how to on February 10th, 2009 by Bastien | Comments Off
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 Utilities » Text » Advanced character removal/replace...
- Select the cells
- Start the utility ASAP Utilities » Text » Advanced character removal/replace...
- Click on the "All" button
- Click on the "1,2,3" button
This way all characters, except the numbers, will be removed in the selected cells.
Make sure the 'Replace characters with' box is empty.
- Press the OK button
Filed under: ASAP Utilities, how to on February 10th, 2009 by Bastien | Comments Off
Filed under: ASAP Utilities, how to on February 10th, 2009 by 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 in Excel
Although a bit awkward and hidden, you can do this in just Excel:
Hold down the Alt key while typing 010 on the numeric keypad in the search box.
The number 10 is the ASCII code for the newline character. This way you can replace the newline character with something else. Make sure that you enter the 010 on the numeric keypad; it does not work if you use the numbers at the top of your keyboard.
If you enter Alt+010 twice in the 'Find what' box and Alt+010 once in the 'Replace with' box, you can replace the blank empty lines within your cells with a single new line character. If the cells contain multiple empty lines after each other you might have to do this search en replace a couple of times after each other until all double newline characters are removed.
Limitation:
You cannot use this method if your cells contains too much text, in that case Excel presents you with the error "Formula is too long".
In Excel you can receive the error "Formula is too long". It will find what you are looking for but you cannot replace the text. This error has nothing to do with formulas; you can also get it if your cells contain only text. In such a case you can use ASAP Utilities to replace the text, because that does not have the limitation.
Method 2: Do it with ASAP Utilities
The benefit of ASAP Utilities is that you see the character you type and the replace is not limited to cells with a certain length
- In the Excel menu choose: ASAP Utilities » Range » Find / Replace in all sheets...
- Find what: {lf}{lf}
Replace with: {lf}
Then press the 'Find all' button and then the 'Replace all' button. If the cells contain multiple empty lines after each other you might have to press the replace button a couple of times until all double newline characters are removed.
If you need to remove certain characters of replace them with another character the ASAP Utilities "Advanced character removal/replace..." utility might also be interesting to know about.
Filed under: ASAP Utilities, how to on February 10th, 2009 by Bastien | 1 Comment »
Filed under: ASAP Utilities, how to on February 4th, 2009 by Bastien | Comments Off
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 and filtering. Many people just click on the sorting or filter button and rely in Excel selecting the data range. But when there is an empty row, Excel's "auto detect" assumes that this is the end of your table/data range (which most of the times is the case). If you want to do the sorting of filtering on a table with empty rows, you first have to manually select the entire data range and then do the sorting or filtering.
You can use ASAP Utilities to remove all blank/empty rows in in your worksheet.
The following utility will remove all rows that contain no data within the used range of your worksheet:
ASAP Utilities » Columns & Rows » Remove all empty rows
If you want to remove the blank rows or columns withing your selected range you can use the following utility:
ASAP Utilities » Columns & Rows » Conditional row and column select, hide or delete...
and then choose the option to select, hide or remove the completely empty rows or columns.
Some people emailed me because they expected this utility to reduce the amount of available rows in the worksheet, but it doesn't work like that. The utility only removes the empty rows between your data. It will not reduce the amount of available rows in your worksheets (65536 rows in Excel prior to version 2007 and 1048576 row in Excel 2007).
If a row is removed, a new row is automatically added by Excel at the bottom of your worksheet. That is the normal way Excel works.
*You can select the entire sheet and sort the data to shift the empty rows to the bottom, but that will also change the order of all data.
If you want to do this with a macro yourself, you could use a macro such as the following:
Read more...
Filed under: ASAP Utilities, how to on February 4th, 2009 by Bastien | Comments Off
