logo ASAP Utilities

“The right tools help you save money!”

Excel with ASAP Utilities in it's menu

Version history

A history of the various updates and improvements throughout the years

Awards & Reviews

Read the awards & reviews from magazines, newsletters and radio shows.

Reviews from users

See what our users are saying about ASAP Utilities

Receive our newsletter

Receive an email as soon as a new version of ASAP Utilities is released

Trusted daily by over 26,000 organizations

Our list of clients exceeds 26,500 organizations in more than 140 countries.

ASAP Utilities released its new version (4.0) today!

Date: August 30, 2006

We're proud to officially announce the new version of ASAP Utilities!

Version 4.0 is compatible with Excel 2000 and all future Excel versions. This new version has a lot of improvements in comparison to the previous version 3.10c.

A comprehensive User Guide will show you how to get the best out of ASAP Utilities. This 141 pages document can be downloaded as PDF.

My thanks goes out to each and every one of you for your suggestions and bug-reports the past years. ASAP Utilities continues to grow and improve thanks to your support, your suggestions and your encouragement.

ASAP Utilities is (as always) free and contains no spyware!

Kind regards,

Bastien Mensink
ASAP Utilities


The major changes in this new version 4.0

  • ASAP Utilities is now partly a COM Add-in (ASAP Utilities.dll).
    This gives some substantial benefits:

    1. Excel's startup with ASAP Utilities is (much) faster.
    2. The utilities run faster
    3. We previously had split the utility into several files (sheet.asap, format.asap, etc.). Whenever a utility was run the first time from one of these files, the file had to be opened, which in some cases caused some delay due to a virus scanner or slow network. This is gone now which improves speed.
    4. The code is easier to maintain for us and upgrades can be provided much quicker.
    5. Control+Shift shortcuts can be used (again) in the favorites menu.

    The only disadvantage is that Excel 97 is not supported by this new version. We will create a special version for the people that still use Excel 97.

  • Expanded undo.
    Much more utilities now can be undone.
  • Range » Advanced sort... (new)
    Extend the sorting capabilities of Excel. You can now sort on 5 columns and we have extended the characteristics to sort on.
    You can sort on:
    1. Value
    2. Number Format
    3. Cell Color
    4. Cell Color Indexnr.
    5. Font Color
    6. Font Color Indexnr.
    7. Font Size
    8. Font Name
    9. Bold
    10. Italic
    11. Underline
    12. Strikethrough
    13. Text length
    14. Shuffle (randomize order)
    15. Formula
    16. Email address host (@...)
    17. Year-Month-Day
    18. Year-Day-Month
    19. Month-Day-Year
    20. Month-Year-Day
    21. Day-Year-Month
    22. Day-Month-Year
  • Range » Apply formula (improved)
    Better error handling and detection for formulas that result in a circular reference.
  • Export » Export selected chart or range as image (file)...
    Now also supports the vector format EMF. Vector graphics in EMF (enhanced version of WMF) format can be scaled and fully edited in MS Office and other Windows applications. They generally produce the best quality for printing.
  • Updated Menu
    The shortcuts assigned in the favorites menu will now also be displayed in the rest of the menu. Utilities that require additional input or show a form are now recognizable in the menu by the dots at the end of the description ...
  • Hyperlink in cell to hyperlink 2 click
    Has been renamed to make more clear what it does: "Activate hyperlinks (create from cell-value)"
  • General
    I've added an option to switch on/off the question that sometimes is asked before running the utility, e.g. questions like "Do you want to convert all text characters in selected cells to UPPERCASE?" can now be turned off in the ASAP Utilities » ASAP » Options dialog.
  • Web » Clean Web Imported data...
    The layout is improved. Your last used settings will be remembered.
    Fixed the bug that could incorrectly convert dates. These cells are now skipped.
  • Export » Export selection as HTML table to clipboard...
    Your last used settings will be remembered.
    < STRIKE > is added for text that is formatted as strikethrough.
    Works much faster on large tables (> 500 cells).
    The HTML code is improved, partly because current browsers support CSS better.
  • Export » Export selection or active sheet as new file...
    Your last used settings will be remembered.
  • Export » Export selected chart or range as image (file)...
    Your last used settings will be remembered.
  • Sheets » Protect all sheets
    It also has the option to protect only selected or all sheets.
  • Sheets » Unprotect all sheets
    It also has the option to unprotect only selected or all sheets.
  • Format » Copy a sheet's page and print settings...
    The settings for "fit pages" (x pages with and x pages wide) can now be copied too.
  • Text » Convert dates...
    Your last used settings will be remembered.
  • Text » Make first character uppercase, the rest lowercase
    Makes the first character uppercase and the rest of the text lowercase: for example BASTIEN will become Bastien.
  • Sheets » Export worksheets as separate files...
    Save worksheets as separate files in a folder you select.
  • Web » Extract hyperlinks
    Hyperlinks from shapes/images can now be extracted too.
  • Text » Advanced character removal
    Besides removing the characters you can now also have them replaced with a
    certain character.
  • Select » Expand selection to last row
    The last cell will be reset first before expanding your selection to the last row.
    Will now also work on protected worksheets.
  • Select » Expand selection to last column
    The last cell will be reset first before expanding your selection to the last column.
    Will now also work on protected worksheets.
  • Export » Export selection as values to clipboard
    Will give you a warning message if your selection contains cells with an
    error. You can then choose to continue or correct the errors first.
  • System » Close all files except the current one
    Has been renamed to:
    System » Close multiple files at once...
  • General
    Improved progress indicators.
  • Numbers » Change decimals (not formatting, but changing)
    Has been renamed to
    Numbers » Round numbers (not formatting, but changing)...
  • Range » Empty duplicates on selection.
    Now works on multiple columns. Cells with more than 255 characters are now
    supported too.
  • Fill » Insert filename...
    Now has an extra option to create hyperlinks to the files. A copy of this utility
    has been made in the "Information" menu with the name "List filenames in folder..."
    Your settings will be saved and if you have Excel 2002/XP or later the "pick a folder"
    dialog will start with your last used folder.
  • ASAP » Options...
    A new option is added where you can choose to use the F11 key to switch between
    fullscreen mode. By default the F11 key inserts a chart sheet in Excel and so
    will Alt+F1.
  • NEW: System » Reopen current file without saving changes.
    Closes the current workbook without saving changes and then opens the last saved
    copy of the file.
  • NEW: Text » Replace accented vowels (á, ë, etc.)...
    Replace the accented vowels in your selected cells with non-accented vowels.
    For example replace ë, é, Ã, ê with the vowel e. In some cases the accented
    characters are not allowed and now you can quickly replace these accented vowels.
    You can customize the settings.
  • Text » Advanced character removal...
    Contains a new option where you can specify whether you want to replace in cells with constants, formulas or both.
  • NEW: worksheet function =ASAPSPELLNUMBERS().
    This is a worksheetfunction of the utility Numbers » Spell numbers or amounts (EN, DE, NL)...
    A detailed description of this function is given in the User Guide.
  • System » Close and delete current file.
    If possible the file will not be deleted but send to the Recycle Bin. If that is not
    possible you will get a question of you want to delete the file permanently.
  • System » Create a lot of folders.
    If you have Excel 2002/XP or later the "pick a folder" dialog will start with your last used folder.
  • Format » Delete all lines inside selection
    Has been renamed to Delete all borders inside selection.
    This utility has also been updated to really remove only the interior borders.
    It used to remove all borders in your selection.
  • Excel 2007
    This version will work in Excel 2007 beta too, although not all utilities have been fully tested in the new version of Excel (yet).
  • Sheets » Sort all sheets in alphabetical order
    Used to sort only the worksheets. It now sorts all sheets.
  • NEW: Columns / Rows » Remove all empty columns
    This utility will remove all empty columns in your selection. An empty column is defined as a column where none of the cells contains data.
  • Columns / Rows » Color each n'th row or column in selection...
    Your last used settings will be remembered.
  • Import » Merge files together in a new file...
    Your last used settings will be remembered, including your last used folder.
  • Range » Paste Special (with combinations)...
    Your last used settings will be remembered.
  • Format » Copy a sheet's page and print settings...
    Your last used settings will be remembered.
  • Range » Find / replace in all sheets...
    Your last used settings will be remembered.
  • Formula » Custom formula error message...
    Your last used settings will be remembered.
  • New worksheet formula: =ASAPSheetName()
    Returns the name of the sheet the formula is placed on.
  • Fill » List filename...
    When creating a list of all filenames in a folder you can now choose whether you want to list the filename including its full path or just the filename (without its folder).
  • All menu-items now have accelerator keys
    An an accelerator key is a single character used as a shortcut for selecting the menu items. Pressing the ALT key, followed by the
    accelerator key gives focus to the menu-item (submenu) or executes the menu-command.
    The accelerator key is also called keyboard accelerator, shortcut key or keyboard shortcut. However they differ from the shortcuts you can use in the ASAP Utilities favorites menu. The shortcuts there give instant access to start the utility while the accelerator keys just provide a more convenient way to browse through the menu.
  • New worksheet function: =ASAPExtractNumbers(ref)
    This function extracts the numbers from a given range or value.
  • New worksheet function: =ASAPStripNumbers(ref)
    This function strips the numbers from a given range or value.
  • Several small additions and improvements.

Bug fixes

  • Information » Count duplicates in selection
    1. Now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
    2. Now supports multiple selected ranges (multiple areas)
  • Select » Conditional select » duplicates
    1. Now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
    2. Select duplicates now works when you have selected multiple areas (non-adjacent cells).
  • Information » Fast calculation
    Better calculation of duplicates and unique values. It now also handles cells with more than 255 characters correctly. It can now recognize cells with the maximum length of 32767 characters.
  • Objects/Comments » Delete all objects from current sheet
    Remove objects handles form/VBA buttons better.
  • Favorites menu
    The cursor stays highlighted after you add or remove a tool.
    The insert and delete button have an accelerator key (Alt+i and Alt+d)
    Improved handling of the location of the favorites menu.
  • Information » Count duplicates in selection.
    In some cases duplicates weren't correctly found (numbers with decimals), and I think also depending on your computer settings (different from US/international).
  • Fill » Fill 'between values' linear in selection (horizontal)
    Didn't work, fixed it and is now working
  • Fill » Copy values to empty cells below filled cells in selection
    Resulted in an error when your selection included a cell in row number 1 and that cell was empty. This is now fixed.
  • General
    When you close Excel, and then chose "No", the ASAP Utilities menu was removed. This is now fixed. The ASAP Utilities menu will only be removed if you really closed down Excel.
  • System » Rename current file...
    When you use this tool to rename a template file (xlt) the renamed file was opened as a workbook based on the template. This is now corrected. The renamed template will be opened for editing.
  • Text » Delete leading and trailing spaces
    Fixed the bug that could incorrectly convert dates. These cells are now skipped.
  • Text » Delete leading and trailing and excessive spaces
    Fixed the bug that could incorrectly convert dates. These cells are now skipped.
  • Range » Find / replace in all sheets...
    Can now handle large text cells too that contain more than 255 characters.
  • Text » Advanced character removal
    Can now handle large text cells too that contain more than 255 characters.
  • Select » Expand selection to last row
    Now support multiple selected areas
  • Select » Expand selection to last column
    Now support multiple selected areas
  • Select » Inverse selection
    Produced an error if you cancelled the selection of a cell.
  • Information » Count unique values in selection
    Produced an error if your selection contained cells with an error.
  • Numbers » Use a significant number of decimals
    Gave an error when you used it on cells without decimals.
    The speed of this utility is increased too.
  • Range » Find / Replace in all sheets...
    Bug fixed in combination with Excel 2003.
  • System » Clear recent files list in file menu
    Used to reset the amount of recent files back to Excel's default which is 4.
    This is now fixed and your setting will be kept.
  • Objects » Select all objects on current sheet
    Gave an error if the sheet contained comments. A workaround has been made to make it work in that occasion too.
  • System » Rename current file
    If you specified a filename of a file that already existed that file was overwritten. ASAP Utilities will now ask you if you want to overwrite the
    existing file. In Excel 2000 the utility made Excel crash when the renamed file was about to be openend. This is now fixed.
  • Sheet » Copy a sheet’s page and print settings
    Fixed a bug during the startup of the utility which caused the utility not to work.
  • General
    Several minor bug fixes.
    Corrected some typing errors.

A few screenshots

Advanced sorting:
advanced sorting
New menu with the shortcuts visible you assigned:
New menu with the shortcuts visible you assigned
Apply formula with a history:
apply formula with a history
A new option to switch on/off the question that sometimes is asked before running the utility
new option to switch on/off the question that sometimes is asked before running the utility
More utilities can be undone
more utilities can be undone
Protect all (selected) sheets improved:
Protect all (selected) sheets improved
Export worksheets a separate files
Export worksheets a separate files
Improved progress indicators:
Improved progress indicators

Installation notice

You must be logged in as an administrator or as a member of the Power Users group when installing ASAP Utilities. When the installation is finished every user on the computer is able to use ASAP Utilities.
Installation is easy. Best way is to make a backup of the current files in the ASAP Utilities folder and then run the installation.
If you have a previous version of ASAP Utilities installed, select that folder (the setup-program should detect it though), usually this is “C:\Program Files\ASAP Utilities\â€. If you are not sure about that location you can see it in ASAP Utilities. Start Excel and then:
ASAP Utilities » ASAP » Options
More information about the installation.



« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years