logo ASAP Utilities

“Smart tools that speed up your workflow in Excel!”

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.2) today!

Date: September 25, 2007

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

You can download 4.2.0, September 24, 2007.

This new version is improved in several ways. Furthermore the ASAP Utilities menu is now nicely inegrated into the new Excel 2007 menu (ribbon).

I would like to thank everybody for their feedback the past months!

If you would like to be informed by email when a new version is released, you can subscribe to our newsletter.


New in this version

  • General
    ASAP Utilities ribbon tab in Excel 2007
    ASAP Utilities in the ribbon of Excel 2007, with black theme
  • Select » Conditional select cells...
    Added the option to select cells with a certain number format
    Added the options to select cells with a certain number format
  • Import » Insert (delimited) text file...
    Insert a (delimited) text file at the position of the selected cells.
    This new import utility has several options you can set but right now the main purpose is that the dates can be imported using your windows regional settings.
    new403_insert_delimited_text_file_menu.png
    new403_insert_delimited_text_file.png
  • Fill » Insert current date and time with seconds
    Insert the current date and time into the active cell. Unlike Excel's built in shortcut "Control+:" this utility also inserts the seconds. (timestamp)
    By default this utility can be started with the shortcut Control+Shift+D
    Screenshot - Insert current date and time with seconds
  • Fill » Insert current time with seconds
    Insert the current time into the active cell. Unlike Excel's built in shortcut "Control+;" this utility also inserts the seconds. (timestamp)
    By default this utility can be started with the shortcut Control+Shift+T
    Screenshot - Insert current time with seconds
  • Export » Export selected chart or range as image (file)...
    New option to open the exported image in your default image-viewer immediately after the export.
    Screenshot - New option to open the exported image in your default image-viewer immediately after the export
    The default filename to save the image is now the name of the selected chart or the address of the selected range.
    Screenshot - The default filename to save the image is now the name of the selected chart or the address of the selected range
    The default proposed filename now contains the name of your workbook and the selected sheet. If you have chosen to export a range of cells instead of the entire sheet, the proposed filename also contains the address of your selection: Export selection or active sheet as new file: default filename
  • Sheets » Freeze panes on multiple sheets at once
    Freeze panes on all or all selected sheets at once, based on your current selection.
    Normally in Excel you can only do this one sheet at a time. With this utility you can now for example freeze the first row on all sheets at once.
  • Sheets » Unfreeze panes on multiple sheets at once
    Unfreeze panes on all or all selected sheets at once.

Bugs fixed

  • Format » The paper saver (split columns)...
    Fixed the error on start.
  • Fill » List filenames in folder...
    Error fixed when reading files from cd-rom or DVD (Last Accessed date not available).
  • Export » Export selection as HTML table to clipboard...
    Fixed 'Runtime error 91: Object variable or With block variable not set.
  • Numbers » Convert "textnumbers" to numbers
    Fixed a bug where fractions such as 1/2 were converted to dates. Fractions will now be detected and converted to fractions you can calculate with.
  • Export » Export selected chart or range as image (file)...
    Several minor improvements. Fixed the bug in combination with Excel 2007. The image quality however in Excel 2007, especially in combination with Windows Vista still needs some improvement compared to previous Excel version. I'm working on a solution for this.
  • Numbers » Round numbers (not formatting, but changing)...
    Fixed a bug that appears in combination with the Norwegian and Czech regional settings. Somehow Excel/ASAP Utilities didn't see the numbers as actual numbers and therefore the utility ignored them. (I could only reproduce this bug with these two regional language settings).
  • Improved worksheet functions
    ASAPSumByCellColor()
    ASAPCountByCellColor()
    ASAPSumByFontColor()
    ASAPCountByFontColor()
    If you work with more than 2 decimals the utility isn't 100% accurate after the fifth decimal of the result. This is corrected in this version.
    These functions can now use a cell-addres to specify the color in stead of only using the colorindex. Furthermore the accuracy of these functions is improved.
    So for example if you have a range of cells with 10 green cells you want to sum you  can use the formula either as
    =ASAPSumByCellColor(A1:E24;4)
    or if cell D4 contains the color you can use:
    =ASAPSumByCellColor(A1:E24;D4)
    Count or sum cells based on their color
  • Improved the progress bar of the utilities
  • Small improvements in the "Organize your favorite tools..." utility
  • Several minor bugfixes


« back


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


Empowering Excel Users Worldwide for 25 Years